APPS.GMS_PA_API dependencies on PA_TRANSACTION_SOURCES

Line 22: G_trx_source pa_transaction_sources.transaction_source%TYPE ;

18:
19: -- ------------------------------------------
20: -- declare package variables
21: -- ------------------------------------------
22: G_trx_source pa_transaction_sources.transaction_source%TYPE ;
23: G_GL_accted_flag varchar2(1) ;
24:
25: -- ----------------------------------------------------------------------------
26: -- This function returns the error x_error set by the GMS_PA_API.VERT_TRANSFER

Line 813: FROM pa_transaction_sources

809: and reversed_flag is NULL ;
810:
811: CURSOR C_TXN_SOURCE IS
812: SELECT nvl(purgeable_flag, 'N'), nvl(gl_accounted_flag, 'N')
813: FROM pa_transaction_sources
814: WHERE transaction_source = x_trx_src ;
815:
816: -- ---------------------------------------
817: -- PROCEDURE PROC_BURDEN_INTERFACE

Line 1539: from pa_transaction_sources

1535: -- -----------------------------------------------------------------------------------
1536: cursor C_gl_accted is
1537: select gl_accounted_flag ,
1538: pre_processing_extension -- Bug 3035863
1539: from pa_transaction_sources
1540: where transaction_source = X_transaction_source ;
1541: -- -----------------------------------------------------------------
1542: -- BUG: 1361739 - Supplier Invoice Interface cause validation
1543: -- failed. ERROR - GMS_VALIDATION_FAILED.

Line 2223: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;

2219:
2220: l_sponsored_flag varchar2(1);
2221: l_award_id number;
2222: l_stage varchar2(10);
2223: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;
2224: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;
2225: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;
2226: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2227: --

Line 2232: l_predefined_flag pa_transaction_sources.predefined_flag%TYPE ;

2228: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS
2229: --
2230: l_system_reference5 pa_transaction_interface_all.cdl_system_reference5%TYPE ;
2231:
2232: l_predefined_flag pa_transaction_sources.predefined_flag%TYPE ;
2233: BEGIN
2234: x_sch_fixed_date := NULL;
2235: x_rate_sch_rev_id := NULL;
2236: x_status := NULL;

Line 2282: pa_transaction_sources pts

2278: l_system_reference3,
2279: l_system_reference5,
2280: l_predefined_flag
2281: from pa_transaction_interface_all pti,
2282: pa_transaction_sources pts
2283: where pti.txn_interface_id = p_tran_item_id
2284: and pti.transaction_source = pts.transaction_source ;
2285: --
2286: -- Supplier invoice system linkage from pre defined source : get award from