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.ZX_JA_EXTRACT_PKG dependencies on RA_BATCH_SOURCES

Line 47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source

43:
44: PROCEDURE GET_GUI_SOURCE
45: (
46: P_TRX_SOURCE_NAME IN VARCHAR2,
47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
51: );

Line 48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num

44: PROCEDURE GET_GUI_SOURCE
45: (
46: P_TRX_SOURCE_NAME IN VARCHAR2,
47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
51: );
52:

Line 49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word

45: (
46: P_TRX_SOURCE_NAME IN VARCHAR2,
47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
51: );
52:
53:

Line 50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num

46: P_TRX_SOURCE_NAME IN VARCHAR2,
47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
51: );
52:
53:
54: PROCEDURE GET_ORG_TRX_NUMBER

Line 163: FROM ra_batch_sources_all

159: /* Taiwanese Output VAT Report */
160: if P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID is NOT NULL then
161: SELECT batch_source_type, TO_NUMBER(global_attribute1)
162: INTO l_loc_trx_src_type, l_referenced_trx_src_id
163: FROM ra_batch_sources_all
164: WHERE batch_source_Id = P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID;
165:
166:
167: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 176: /* l_referenced_trx_src_id :GDF_RA_BATCH_SOURCES_ATT1 is used for Reference

172:
173: if l_loc_trx_src_type = 'INV' and
174: l_referenced_trx_src_id IS NOT NULL and
175: P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_REFERENCED_SOURCE = 'Y' then
176: /* l_referenced_trx_src_id :GDF_RA_BATCH_SOURCES_ATT1 is used for Reference
177: Transaction Source */
178: lp_where_trx_source_id:= ' DET.TRX_BATCH_SOURCE_ID = ' || P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID;
179: lp_where_inc_reference_source:= ' or DET.TRX_BATCH_SOURCE_ID = '|| l_referenced_trx_src_id;
180: else

Line 236: FROM ra_batch_sources

232:
233: if P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID is NOT NULL then
234: SELECT batch_source_type, TO_NUMBER(global_attribute1)
235: INTO l_loc_trx_src_type, l_referenced_trx_src_id
236: FROM ra_batch_sources
237: WHERE batch_source_Id = P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID;
238:
239: if l_loc_trx_src_type = 'INV' and
240: l_referenced_trx_src_id IS NOT NULL and

Line 242: /* l_referenced_trx_src_id is used for GDF_RA_BATCH_SOURCES_ATT1 */

238:
239: if l_loc_trx_src_type = 'INV' and
240: l_referenced_trx_src_id IS NOT NULL and
241: P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_REFERENCED_SOURCE = 'Y' then
242: /* l_referenced_trx_src_id is used for GDF_RA_BATCH_SOURCES_ATT1 */
243: lp_where_trx_source_id:= ' and DET.TRX_BATCH_SOURCE_ID = ' || P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID;
244: lp_where_inc_reference_source:= ' DET.TRX_BATCH_SOURCE_ID = '|| l_referenced_trx_src_id;
245: else
246: lp_where_trx_source_id:= ' DET.TRX_BATCH_SOURCE_ID = ' || P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID;

Line 259: SELECT 1 FROM ra_batch_sources_all rbs,

255: 'DELETE from ZX_REP_TRX_DETAIL_T DET
256: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
257: NOT EXISTS
258: (
259: SELECT 1 FROM ra_batch_sources_all rbs,
260: ra_customer_trx_all rct
261: WHERE
262: rbs.batch_source_id = DET.TRX_BATCH_SOURCE_ID and
263: rct.batch_source_id = rbs.batch_source_id and

Line 783: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;

779: TYPE EXPORT_TYPE_TBL is TABLE OF
780: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
781:
782: TYPE INVOICE_WORD_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;
784:
785: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
787:

Line 786: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;

782: TYPE INVOICE_WORD_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;
784:
785: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
787:
788: TYPE FINAL_TRX_NUM_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
790:

Line 789: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;

785: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
787:
788: TYPE FINAL_TRX_NUM_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
790:
791: TYPE REFERENCE_TRX_SRC_TBL is TABLE OF
792: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;
793:

Line 792: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;

788: TYPE FINAL_TRX_NUM_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
790:
791: TYPE REFERENCE_TRX_SRC_TBL is TABLE OF
792: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;
793:
794: TYPE ORG_TRX_NUMBER_TBL is TABLE OF
795: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE INDEX BY BINARY_INTEGER;
796:

Line 1010: gdf_ra_batch_sources_att1, -- reference transaction source ZXTWRUIL

1006: (detail_tax_line_ext_id,
1007: detail_tax_line_id,
1008: tax_status_mng, -- government tax type meaning
1009: gdf_ra_cust_trx_att9, -- orginal transaction number ZXTWRUIL
1010: gdf_ra_batch_sources_att1, -- reference transaction source ZXTWRUIL
1011: gdf_ra_batch_sources_att2, -- initial trx num ZXTWRUIL
1012: gdf_ra_batch_sources_att3, -- invoice word ZXTWRUIL
1013: gdf_ra_batch_sources_att4, -- final trx num ZXTWRUIL
1014: attribute15, --Bug 5251425

Line 1011: gdf_ra_batch_sources_att2, -- initial trx num ZXTWRUIL

1007: detail_tax_line_id,
1008: tax_status_mng, -- government tax type meaning
1009: gdf_ra_cust_trx_att9, -- orginal transaction number ZXTWRUIL
1010: gdf_ra_batch_sources_att1, -- reference transaction source ZXTWRUIL
1011: gdf_ra_batch_sources_att2, -- initial trx num ZXTWRUIL
1012: gdf_ra_batch_sources_att3, -- invoice word ZXTWRUIL
1013: gdf_ra_batch_sources_att4, -- final trx num ZXTWRUIL
1014: attribute15, --Bug 5251425
1015: created_by,

Line 1012: gdf_ra_batch_sources_att3, -- invoice word ZXTWRUIL

1008: tax_status_mng, -- government tax type meaning
1009: gdf_ra_cust_trx_att9, -- orginal transaction number ZXTWRUIL
1010: gdf_ra_batch_sources_att1, -- reference transaction source ZXTWRUIL
1011: gdf_ra_batch_sources_att2, -- initial trx num ZXTWRUIL
1012: gdf_ra_batch_sources_att3, -- invoice word ZXTWRUIL
1013: gdf_ra_batch_sources_att4, -- final trx num ZXTWRUIL
1014: attribute15, --Bug 5251425
1015: created_by,
1016: creation_date,

Line 1013: gdf_ra_batch_sources_att4, -- final trx num ZXTWRUIL

1009: gdf_ra_cust_trx_att9, -- orginal transaction number ZXTWRUIL
1010: gdf_ra_batch_sources_att1, -- reference transaction source ZXTWRUIL
1011: gdf_ra_batch_sources_att2, -- initial trx num ZXTWRUIL
1012: gdf_ra_batch_sources_att3, -- invoice word ZXTWRUIL
1013: gdf_ra_batch_sources_att4, -- final trx num ZXTWRUIL
1014: attribute15, --Bug 5251425
1015: created_by,
1016: creation_date,
1017: last_updated_by,

Line 2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source

2218:
2219: PROCEDURE GET_GUI_SOURCE
2220: (
2221: P_TRX_SOURCE_NAME IN VARCHAR2,
2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2226:

Line 2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num

2219: PROCEDURE GET_GUI_SOURCE
2220: (
2221: P_TRX_SOURCE_NAME IN VARCHAR2,
2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2226:
2227: )

Line 2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word

2220: (
2221: P_TRX_SOURCE_NAME IN VARCHAR2,
2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2226:
2227: )
2228: IS

Line 2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num

2221: P_TRX_SOURCE_NAME IN VARCHAR2,
2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2226:
2227: )
2228: IS
2229:

Line 2245: INTO X_GDF_RA_BATCH_SOURCES_ATT1

2241:
2242: IF P_TRX_SOURCE_NAME is not null THEN
2243: SELECT decode(src.global_attribute1, NULL, src.batch_source_id,
2244: src.global_attribute1)
2245: INTO X_GDF_RA_BATCH_SOURCES_ATT1
2246: FROM ra_batch_sources src
2247: WHERE src.name = P_TRX_SOURCE_NAME;
2248:
2249: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2246: FROM ra_batch_sources src

2242: IF P_TRX_SOURCE_NAME is not null THEN
2243: SELECT decode(src.global_attribute1, NULL, src.batch_source_id,
2244: src.global_attribute1)
2245: INTO X_GDF_RA_BATCH_SOURCES_ATT1
2246: FROM ra_batch_sources src
2247: WHERE src.name = P_TRX_SOURCE_NAME;
2248:
2249: IF ( g_level_statement>= g_current_runtime_level ) THEN
2250: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

Line 2251: ' X_GDF_RA_BATCH_SOURCES_ATT1 : '||X_GDF_RA_BATCH_SOURCES_ATT1 );

2247: WHERE src.name = P_TRX_SOURCE_NAME;
2248:
2249: IF ( g_level_statement>= g_current_runtime_level ) THEN
2250: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2251: ' X_GDF_RA_BATCH_SOURCES_ATT1 : '||X_GDF_RA_BATCH_SOURCES_ATT1 );
2252: END IF;
2253:
2254: SELECT substr(global_attribute3,1,2),
2255: to_number(global_attribute2),

Line 2257: INTO X_GDF_RA_BATCH_SOURCES_ATT3,

2253:
2254: SELECT substr(global_attribute3,1,2),
2255: to_number(global_attribute2),
2256: to_number(global_attribute4)
2257: INTO X_GDF_RA_BATCH_SOURCES_ATT3,
2258: X_GDF_RA_BATCH_SOURCES_ATT2,
2259: X_GDF_RA_BATCH_SOURCES_ATT4
2260: FROM ra_batch_sources
2261: WHERE batch_source_id = X_GDF_RA_BATCH_SOURCES_ATT1;

Line 2258: X_GDF_RA_BATCH_SOURCES_ATT2,

2254: SELECT substr(global_attribute3,1,2),
2255: to_number(global_attribute2),
2256: to_number(global_attribute4)
2257: INTO X_GDF_RA_BATCH_SOURCES_ATT3,
2258: X_GDF_RA_BATCH_SOURCES_ATT2,
2259: X_GDF_RA_BATCH_SOURCES_ATT4
2260: FROM ra_batch_sources
2261: WHERE batch_source_id = X_GDF_RA_BATCH_SOURCES_ATT1;
2262:

Line 2259: X_GDF_RA_BATCH_SOURCES_ATT4

2255: to_number(global_attribute2),
2256: to_number(global_attribute4)
2257: INTO X_GDF_RA_BATCH_SOURCES_ATT3,
2258: X_GDF_RA_BATCH_SOURCES_ATT2,
2259: X_GDF_RA_BATCH_SOURCES_ATT4
2260: FROM ra_batch_sources
2261: WHERE batch_source_id = X_GDF_RA_BATCH_SOURCES_ATT1;
2262:
2263: END IF;

Line 2260: FROM ra_batch_sources

2256: to_number(global_attribute4)
2257: INTO X_GDF_RA_BATCH_SOURCES_ATT3,
2258: X_GDF_RA_BATCH_SOURCES_ATT2,
2259: X_GDF_RA_BATCH_SOURCES_ATT4
2260: FROM ra_batch_sources
2261: WHERE batch_source_id = X_GDF_RA_BATCH_SOURCES_ATT1;
2262:
2263: END IF;
2264:

Line 2261: WHERE batch_source_id = X_GDF_RA_BATCH_SOURCES_ATT1;

2257: INTO X_GDF_RA_BATCH_SOURCES_ATT3,
2258: X_GDF_RA_BATCH_SOURCES_ATT2,
2259: X_GDF_RA_BATCH_SOURCES_ATT4
2260: FROM ra_batch_sources
2261: WHERE batch_source_id = X_GDF_RA_BATCH_SOURCES_ATT1;
2262:
2263: END IF;
2264:
2265: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2267: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );

2263: END IF;
2264:
2265: IF ( g_level_statement>= g_current_runtime_level ) THEN
2266: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2267: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2268: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2269: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2270: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2271: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );

Line 2269: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );

2265: IF ( g_level_statement>= g_current_runtime_level ) THEN
2266: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2267: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2268: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2269: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2270: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2271: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );
2272: END IF;
2273:

Line 2271: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );

2267: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2268: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2269: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2270: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2271: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );
2272: END IF;
2273:
2274: IF (g_level_procedure >= g_current_runtime_level ) THEN
2275: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

Line 2432: ra_batcH_sources_all rbs

2428: SELECT rct_org.trx_number
2429: INTO X_ORG_TRX_NUMBER
2430: FROM ra_customer_trx_all rct,
2431: ra_customer_trx_all rct_org,
2432: ra_batcH_sources_all rbs
2433: WHERE rct_org.customer_Trx_id = rct.previous_customer_trx_id and
2434: rct.batch_source_id = rbs.batch_source_id and
2435: rbs.batch_source_id = P_TRX_SOURCE_ID and
2436: rct.customer_trx_id = p_trx_id;