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 2210: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;

2206:
2207: l_sponsored_flag varchar2(1);
2208: l_award_id number;
2209: l_stage varchar2(10);
2210: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;
2211: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;
2212: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;
2213: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2214: --

Line 2219: l_predefined_flag pa_transaction_sources.predefined_flag%TYPE ;

2215: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS
2216: --
2217: l_system_reference5 pa_transaction_interface_all.cdl_system_reference5%TYPE ;
2218:
2219: l_predefined_flag pa_transaction_sources.predefined_flag%TYPE ;
2220: BEGIN
2221: x_sch_fixed_date := NULL;
2222: x_rate_sch_rev_id := NULL;
2223: x_status := NULL;

Line 2269: pa_transaction_sources pts

2265: l_system_reference3,
2266: l_system_reference5,
2267: l_predefined_flag
2268: from pa_transaction_interface_all pti,
2269: pa_transaction_sources pts
2270: where pti.txn_interface_id = p_tran_item_id
2271: and pti.transaction_source = pts.transaction_source ;
2272: --
2273: -- Supplier invoice system linkage from pre defined source : get award from