APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_MAPPABLE_TXNS_TMP

Line 7997: Insert into PA_MAPPABLE_TXNS_TMP

7993: IF resList.resource_category_code = 'R' Then
7994: -- call resource mapping api if the budget is categorized by resource
7995: -- Insert the plsql values into a temp tables
7996: FORALL i IN g_tab_bc_packet_id.First ..g_tab_bc_packet_id.Last
7997: Insert into PA_MAPPABLE_TXNS_TMP
7998: (txn_id
7999: ,person_id
8000: ,job_id
8001: ,organization_id

Line 8018: pa_mappable_txns_tmp_s.NEXTVAL

8014: ,system_reference2
8015: ,system_reference3
8016: )
8017: SELECT
8018: pa_mappable_txns_tmp_s.NEXTVAL
8019: ,g_tab_person_id(i)
8020: ,g_tab_job_id(i)
8021: ,g_tab_exp_org_id(i)
8022: ,g_tab_vendor_id(i)

Line 8087: from PA_MAPPABLE_TXNS_TMP tmp

8083: ,pkt.result_code)
8084: ,decode(tmp.resource_list_member_id,NULL
8085: ,decode(substr(nvl(pkt.result_code,'P'),1,1),'P','F128',pkt.result_code)
8086: ,pkt.result_code)
8087: from PA_MAPPABLE_TXNS_TMP tmp
8088: where tmp.system_reference1 = pkt.packet_id
8089: and tmp.system_reference2 = pkt.bc_packet_id)
8090: WHERE pkt.packet_id = p_packet_id
8091: AND EXISTS ( SELECT 'Y'

Line 8092: FROM PA_MAPPABLE_TXNS_TMP tmp

8088: where tmp.system_reference1 = pkt.packet_id
8089: and tmp.system_reference2 = pkt.bc_packet_id)
8090: WHERE pkt.packet_id = p_packet_id
8091: AND EXISTS ( SELECT 'Y'
8092: FROM PA_MAPPABLE_TXNS_TMP tmp
8093: WHERE tmp.system_reference1 = pkt.packet_id
8094: AND tmp.system_reference2 = pkt.bc_packet_id);
8095: 7531681 */
8096: /* 7531681 start **/

Line 8101: PA_MAPPABLE_TXNS_TMP TMP

8097: FORALL i in g_tab_bc_packet_id.FIRST .. g_tab_bc_packet_id.LAST
8098: UPDATE PA_BC_PACKETS PKT SET (PKT.RESOURCE_LIST_MEMBER_ID) =
8099: (select TMP.RESOURCE_LIST_MEMBER_ID
8100: FROM
8101: PA_MAPPABLE_TXNS_TMP TMP
8102: WHERE
8103: TMP.SYSTEM_REFERENCE1 = p_packet_id AND
8104: TMP.SYSTEM_REFERENCE2 = g_tab_bc_packet_id(i))
8105: WHERE

Line 8190: DELETE FROM PA_MAPPABLE_TXNS_TMP tmp

8186: ;
8187: END LOOP;
8188:
8189: /* delete the records from tmp table */
8190: DELETE FROM PA_MAPPABLE_TXNS_TMP tmp
8191: WHERE tmp.system_reference1 = p_packet_id;
8192:
8193: /* CWK labor changes update the pkts with reosurce list member ids of the summary records
8194: * information on the transactions */