APPS.PA_WORK_TYPE_UPGRADE dependencies on PA_TXN_UPGRADE_TEMP

Line 291: INTO pa_txn_upgrade_temp t

287:
288: IF P_Txn_Type = 'WORK TYPE' THEN
289:
290: INSERT /*+ APPEND parallel(t) */
291: INTO pa_txn_upgrade_temp t
292: (row_id,
293: pk1_id,
294: worker_id,
295: pk2_id)

Line 332: INTO pa_txn_upgrade_temp t

328:
329: */
330:
331: INSERT /*+ APPEND parallel(t) */
332: INTO pa_txn_upgrade_temp t
333: (row_id
334: ,pk1_id
335: ,worker_id
336: ,pk2_id

Line 394: UPDATE /*+ parallel(t) */ pa_txn_upgrade_temp t

390: commit;
391:
392: IF P_Txn_Type <> 'SUPPLIER TYPE' THEN
393:
394: UPDATE /*+ parallel(t) */ pa_txn_upgrade_temp t
395: SET worker_id = (ceil(rownum / ceil(l_ins_rowcount / p_num_of_processes )));
396:
397: commit;
398:

Line 496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating Table '|| l_pa_schema || '.pa_txn_upgrade_temp '||

492: IF (NOT FND_INSTALLATION.GET_APP_INFO('PA', l_inssts, l_industry, l_pa_schema)) THEN
493: raise_application_error(-20001,SQLERRM);
494: END IF;
495:
496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating Table '|| l_pa_schema || '.pa_txn_upgrade_temp '||
497: to_char(sysdate,'HH:MI:SS') );
498:
499: execute immediate ('Truncate table ' || l_pa_schema || '.pa_txn_upgrade_temp');
500:

Line 499: execute immediate ('Truncate table ' || l_pa_schema || '.pa_txn_upgrade_temp');

495:
496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating Table '|| l_pa_schema || '.pa_txn_upgrade_temp '||
497: to_char(sysdate,'HH:MI:SS') );
498:
499: execute immediate ('Truncate table ' || l_pa_schema || '.pa_txn_upgrade_temp');
500:
501: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling pa_uom.get_uom for updating UOM Meaning '|| to_char(sysdate,'HH:MI:SS') );
502:
503: l_get_uom := 'F';

Line 535: From pa_txn_upgrade_temp Temp,

531: Cursor C_Ei Is
532: Select Temp.Pk1_Id,
533: Tsk.Work_Type_Id,
534: Wt.Tp_Amt_Type_Code
535: From pa_txn_upgrade_temp Temp,
536: Pa_Tasks Tsk,
537: Pa_Work_Types_B Wt
538: Where Worker_Id = p_worker_id
539: And Temp.Pk2_id = Tsk.Task_Id

Line 549: ,Pa_Txn_Upgrade_Temp Temp

545: ,MSI.Primary_UOM_Code UOM
546: ,Temp.Pk1_Id
547: FROM MTL_MATERIAL_TRANSACTIONS MMT
548: ,MTL_SYSTEM_ITEMS MSI
549: ,Pa_Txn_Upgrade_Temp Temp
550: WHERE Temp.Worker_Id = p_worker_id
551: And Temp.Pk2_id = MMT.Transaction_Id
552: AND MMT.Inventory_Item_Id = MSI.Inventory_Item_Id
553: AND MMT.Organization_Id =MSI.Organization_Id

Line 563: ,Pa_Txn_Upgrade_Temp Temp

559: ,WT.Resource_Id Wip_Resource_ID
560: ,WT.Primary_UOM UOM
561: ,Temp.Pk1_ID
562: FROM WIP_TRANSACTIONS WT
563: ,Pa_Txn_Upgrade_Temp Temp
564: WHERE Temp.Worker_Id = p_worker_id
565: And Temp.Pk2_ID = WT.Transaction_ID
566: AND Temp.Txn_Src IN ('Work In Process'
567: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'

Line 576: FROM Pa_Txn_Upgrade_Temp Temp,

572: SELECT decode(PoDist.destination_type_code, 'INVENTORY' , PoLine.Item_Id, null) Inventory_Item_ID ,
573: decode(PoDist.destination_type_code, 'SHOP FLOOR', PoDist.Bom_Resource_Id, null) Wip_Resource_ID ,
574: 'DOLLARS' UOM ,
575: Temp.Pk1_Id
576: FROM Pa_Txn_Upgrade_Temp Temp,
577: Po_Distributions_All PoDist,
578: Po_Lines_All PoLine
579: WHERE Temp.Worker_Id = p_worker_id
580: AND Temp.Pk2_Id = PoDist.po_distribution_id