eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_OM_AR_PROCESSING_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 72: (cpv_source IN jai_rgm_trx_records.source%TYPE,

68: pv_process_message OUT NOCOPY VARCHAR2
69: ) AS
70:
71: CURSOR cur_get_man_ar_inv_taxes
72: (cpv_source IN jai_rgm_trx_records.source%TYPE,
73: cpv_regime_code IN jai_rgm_definitions.regime_code%TYPE,
74: cpv_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
75: cpv_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
76: )

Line 74: cpv_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,

70:
71: CURSOR cur_get_man_ar_inv_taxes
72: (cpv_source IN jai_rgm_trx_records.source%TYPE,
73: cpv_regime_code IN jai_rgm_definitions.regime_code%TYPE,
74: cpv_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
75: cpv_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
76: )
77: IS
78: SELECT

Line 75: cpv_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE

71: CURSOR cur_get_man_ar_inv_taxes
72: (cpv_source IN jai_rgm_trx_records.source%TYPE,
73: cpv_regime_code IN jai_rgm_definitions.regime_code%TYPE,
74: cpv_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
75: cpv_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
76: )
77: IS
78: SELECT
79: jctl.customer_trx_id ,

Line 103: FROM jai_rgm_trx_records jrtr

99: jctl.customer_trx_line_id = jcttl.link_to_cust_trx_line_id AND
100: jcttl.tax_id = jtc.tax_id AND
101: jtc.tax_type = jrttv.tax_type AND
102: NOT EXISTS ( SELECT 1
103: FROM jai_rgm_trx_records jrtr
104: WHERE jrtr.source = cpv_source AND
105: jrtr.source_trx_type = cpv_source_trx_type AND
106: jrtr.organization_id = pn_organization_id AND
107: jrtr.location_id = pn_location_id AND

Line 116: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;

112: ) ;
113:
114: lv_process_flag VARCHAR2(2) ;
115: lv_process_message VARCHAR2(2000) ;
116: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
117: lv_regime_code jai_rgm_definitions.regime_code%TYPE ;
118:
119: CURSOR cur_get_deliveries
120: ( cpv_source IN jai_rgm_trx_records.source%TYPE,

Line 120: ( cpv_source IN jai_rgm_trx_records.source%TYPE,

116: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
117: lv_regime_code jai_rgm_definitions.regime_code%TYPE ;
118:
119: CURSOR cur_get_deliveries
120: ( cpv_source IN jai_rgm_trx_records.source%TYPE,
121: cpv_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
122: cpv_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
123: cpv_regime_code IN jai_rgm_definitions.regime_code%TYPE
124: )

Line 121: cpv_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,

117: lv_regime_code jai_rgm_definitions.regime_code%TYPE ;
118:
119: CURSOR cur_get_deliveries
120: ( cpv_source IN jai_rgm_trx_records.source%TYPE,
121: cpv_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
122: cpv_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
123: cpv_regime_code IN jai_rgm_definitions.regime_code%TYPE
124: )
125: IS

Line 122: cpv_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,

118:
119: CURSOR cur_get_deliveries
120: ( cpv_source IN jai_rgm_trx_records.source%TYPE,
121: cpv_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
122: cpv_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
123: cpv_regime_code IN jai_rgm_definitions.regime_code%TYPE
124: )
125: IS
126: SELECT

Line 162: jai_rgm_trx_records jrtr

158: OR cpv_source = jai_constants.source_nsh) AND
159: NOT EXISTS ( SELECT
160: 1
161: FROM
162: jai_rgm_trx_records jrtr
163: WHERE
164: jrtr.source = cpv_source AND
165: jrtr.source_trx_type = cpv_source_trx_type AND
166: jrtr.organization_id = pn_organization_id AND

Line 179: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;

175: )
176:
177: ;
178:
179: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
180: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
181:
182: CURSOR cur_repository_dtl(cpn_repository_id IN NUMBER) IS
183: SELECT regime_code, tax_type, source, source_table_name, source_document_id,

Line 180: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;

176:
177: ;
178:
179: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
180: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
181:
182: CURSOR cur_repository_dtl(cpn_repository_id IN NUMBER) IS
183: SELECT regime_code, tax_type, source, source_table_name, source_document_id,
184: source_trx_type, organization_id

Line 185: FROM jai_rgm_trx_records

181:
182: CURSOR cur_repository_dtl(cpn_repository_id IN NUMBER) IS
183: SELECT regime_code, tax_type, source, source_table_name, source_document_id,
184: source_trx_type, organization_id
185: FROM jai_rgm_trx_records
186: WHERE repository_id = cpn_repository_id;
187:
188: r_repo_dtl cur_repository_dtl%ROWTYPE;
189: