APPS.PA_WORK_TYPE_UPGRADE dependencies on PA_TXN_UPGRADE_TEMP

Line 280: INTO pa_txn_upgrade_temp t

276:
277: IF P_Txn_Type = 'WORK TYPE' THEN
278:
279: INSERT /*+ APPEND parallel(t) */
280: INTO pa_txn_upgrade_temp t
281: (row_id,
282: pk1_id,
283: worker_id,
284: pk2_id)

Line 321: INTO pa_txn_upgrade_temp t

317:
318: */
319:
320: INSERT /*+ APPEND parallel(t) */
321: INTO pa_txn_upgrade_temp t
322: (row_id
323: ,pk1_id
324: ,worker_id
325: ,pk2_id

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

379: commit;
380:
381: IF P_Txn_Type <> 'SUPPLIER TYPE' THEN
382:
383: UPDATE /*+ parallel(t) */ pa_txn_upgrade_temp t
384: SET worker_id = (ceil(rownum / ceil(l_ins_rowcount / p_num_of_processes )));
385:
386: commit;
387:

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

481: IF (NOT FND_INSTALLATION.GET_APP_INFO('PA', l_inssts, l_industry, l_pa_schema)) THEN
482: raise_application_error(-20001,SQLERRM);
483: END IF;
484:
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating Table '|| l_pa_schema || '.pa_txn_upgrade_temp '||
486: to_char(sysdate,'HH:MI:SS') );
487:
488: execute immediate ('Truncate table ' || l_pa_schema || '.pa_txn_upgrade_temp');
489:

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

484:
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating Table '|| l_pa_schema || '.pa_txn_upgrade_temp '||
486: to_char(sysdate,'HH:MI:SS') );
487:
488: execute immediate ('Truncate table ' || l_pa_schema || '.pa_txn_upgrade_temp');
489:
490: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling pa_uom.get_uom for updating UOM Meaning '|| to_char(sysdate,'HH:MI:SS') );
491:
492: l_get_uom := 'F';

Line 524: From pa_txn_upgrade_temp Temp,

520: Cursor C_Ei Is
521: Select Temp.Pk1_Id,
522: Tsk.Work_Type_Id,
523: Wt.Tp_Amt_Type_Code
524: From pa_txn_upgrade_temp Temp,
525: Pa_Tasks Tsk,
526: Pa_Work_Types_B Wt
527: Where Worker_Id = p_worker_id
528: And Temp.Pk2_id = Tsk.Task_Id

Line 538: ,Pa_Txn_Upgrade_Temp Temp

534: ,MSI.Primary_UOM_Code UOM
535: ,Temp.Pk1_Id
536: FROM MTL_MATERIAL_TRANSACTIONS MMT
537: ,MTL_SYSTEM_ITEMS MSI
538: ,Pa_Txn_Upgrade_Temp Temp
539: WHERE Temp.Worker_Id = p_worker_id
540: And Temp.Pk2_id = MMT.Transaction_Id
541: AND MMT.Inventory_Item_Id = MSI.Inventory_Item_Id
542: AND MMT.Organization_Id =MSI.Organization_Id

Line 552: ,Pa_Txn_Upgrade_Temp Temp

548: ,WT.Resource_Id Wip_Resource_ID
549: ,WT.Primary_UOM UOM
550: ,Temp.Pk1_ID
551: FROM WIP_TRANSACTIONS WT
552: ,Pa_Txn_Upgrade_Temp Temp
553: WHERE Temp.Worker_Id = p_worker_id
554: And Temp.Pk2_ID = WT.Transaction_ID
555: AND Temp.Txn_Src IN ('Work In Process'
556: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'

Line 565: FROM Pa_Txn_Upgrade_Temp Temp,

561: SELECT decode(PoDist.destination_type_code, 'INVENTORY' , PoLine.Item_Id, null) Inventory_Item_ID ,
562: decode(PoDist.destination_type_code, 'SHOP FLOOR', PoDist.Bom_Resource_Id, null) Wip_Resource_ID ,
563: 'DOLLARS' UOM ,
564: Temp.Pk1_Id
565: FROM Pa_Txn_Upgrade_Temp Temp,
566: Po_Distributions_All PoDist,
567: Po_Lines_All PoLine
568: WHERE Temp.Worker_Id = p_worker_id
569: AND Temp.Pk2_Id = PoDist.po_distribution_id