APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_MAPPABLE_TXNS_TMP

Line 7799: Insert into PA_MAPPABLE_TXNS_TMP

7795: IF resList.resource_category_code = 'R' Then
7796: -- call resource mapping api if the budget is categorized by resource
7797: -- Insert the plsql values into a temp tables
7798: FORALL i IN g_tab_bc_packet_id.First ..g_tab_bc_packet_id.Last
7799: Insert into PA_MAPPABLE_TXNS_TMP
7800: (txn_id
7801: ,person_id
7802: ,job_id
7803: ,organization_id

Line 7820: pa_mappable_txns_tmp_s.NEXTVAL

7816: ,system_reference2
7817: ,system_reference3
7818: )
7819: SELECT
7820: pa_mappable_txns_tmp_s.NEXTVAL
7821: ,g_tab_person_id(i)
7822: ,g_tab_job_id(i)
7823: ,g_tab_exp_org_id(i)
7824: ,g_tab_vendor_id(i)

Line 7885: from PA_MAPPABLE_TXNS_TMP tmp

7881: ,pkt.result_code)
7882: ,decode(tmp.resource_list_member_id,NULL
7883: ,decode(substr(nvl(pkt.result_code,'P'),1,1),'P','F128',pkt.result_code)
7884: ,pkt.result_code)
7885: from PA_MAPPABLE_TXNS_TMP tmp
7886: where tmp.system_reference1 = pkt.packet_id
7887: and tmp.system_reference2 = pkt.bc_packet_id)
7888: WHERE pkt.packet_id = p_packet_id
7889: AND EXISTS ( SELECT 'Y'

Line 7890: FROM PA_MAPPABLE_TXNS_TMP tmp

7886: where tmp.system_reference1 = pkt.packet_id
7887: and tmp.system_reference2 = pkt.bc_packet_id)
7888: WHERE pkt.packet_id = p_packet_id
7889: AND EXISTS ( SELECT 'Y'
7890: FROM PA_MAPPABLE_TXNS_TMP tmp
7891: WHERE tmp.system_reference1 = pkt.packet_id
7892: AND tmp.system_reference2 = pkt.bc_packet_id);
7893:
7894: END IF;

Line 7969: DELETE FROM PA_MAPPABLE_TXNS_TMP tmp

7965: ;
7966: END LOOP;
7967:
7968: /* delete the records from tmp table */
7969: DELETE FROM PA_MAPPABLE_TXNS_TMP tmp
7970: WHERE tmp.system_reference1 = p_packet_id;
7971:
7972: /* CWK labor changes update the pkts with reosurce list member ids of the summary records
7973: * information on the transactions */