APPS.CSE_DEPLOYMENT_GRP dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 525: l_transaction_source PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE;

521: l_org_id NUMBER;
522: l_incurred_by_org_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE;
523: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
524: l_user_id NUMBER DEFAULT FND_GLOBAL.USER_ID;
525: l_transaction_source PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE;
526: l_sysdate DATE:=sysdate;
527: l_ref_sufix NUMBER;
528: l_project_number VARCHAR2(25);
529: l_task_number VARCHAR2(25);

Line 576: FROM pa_expenditure_items_all item,

572: dist.system_reference5,
573: exp.expenditure_id,
574: exp.expenditure_ending_date,
575: exp.incurred_by_organization_id
576: FROM pa_expenditure_items_all item,
577: pa_cost_distribution_lines_all dist,
578: pa_expenditures_all exp
579: WHERE item.transaction_source IN ('CSE_PO_RECEIPT','CSE_INV_ISSUE')
580: AND item.project_id = p_trf_pa_attr_rec.project_id

Line 916: -- Here we write the logic for the records not found in pa_expenditure_items_all

912: END IF;
913:
914: END LOOP;
915:
916: -- Here we write the logic for the records not found in pa_expenditure_items_all
917: -- but found in pa_transaction_interface_all
918: BEGIN
919: SELECT segment1
920: INTO l_from_project_number

Line 941: debug('Since the record was not found in pa_expenditure_items_all checking in pa_txn_intf_all ');

937:
938:
939: IF NOT(l_found)
940: THEN
941: debug('Since the record was not found in pa_expenditure_items_all checking in pa_txn_intf_all ');
942: FOR l_txn_intf_csr IN txn_intf_csr
943: LOOP
944: l_found:=TRUE;
945: i := i+1;