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.ECE_AR_TRANSACTION dependencies on ECE_FLATFILE_PVT

Line 314: tbl IN ece_flatfile_pvt.Interface_tbl_type )

310:
311: PROCEDURE Define_Interface_Column ( c IN INTEGER,
312: col IN VARCHAR,
313: col_size IN INTEGER,
314: tbl IN ece_flatfile_pvt.Interface_tbl_type )
315: IS
316:
317: i INTEGER := 0;
318:

Line 1343: l_Header_tbl ece_flatfile_pvt.Interface_tbl_type;

1339: For now, it will be hardcoded to NULL so the default will be the seeded FF transaction
1340: **/
1341: cMap_id NUMBER := NULL;
1342:
1343: l_Header_tbl ece_flatfile_pvt.Interface_tbl_type;
1344: l_Header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
1345: l_alw_chg_h_tbl ece_flatfile_pvt.Interface_tbl_type;
1346: l_Line_tbl ece_flatfile_pvt.Interface_tbl_type;
1347: l_Line_t_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 1344: l_Header_1_tbl ece_flatfile_pvt.Interface_tbl_type;

1340: **/
1341: cMap_id NUMBER := NULL;
1342:
1343: l_Header_tbl ece_flatfile_pvt.Interface_tbl_type;
1344: l_Header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
1345: l_alw_chg_h_tbl ece_flatfile_pvt.Interface_tbl_type;
1346: l_Line_tbl ece_flatfile_pvt.Interface_tbl_type;
1347: l_Line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
1348: l_alw_chg_l_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 1345: l_alw_chg_h_tbl ece_flatfile_pvt.Interface_tbl_type;

1341: cMap_id NUMBER := NULL;
1342:
1343: l_Header_tbl ece_flatfile_pvt.Interface_tbl_type;
1344: l_Header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
1345: l_alw_chg_h_tbl ece_flatfile_pvt.Interface_tbl_type;
1346: l_Line_tbl ece_flatfile_pvt.Interface_tbl_type;
1347: l_Line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
1348: l_alw_chg_l_tbl ece_flatfile_pvt.Interface_tbl_type;
1349:

Line 1346: l_Line_tbl ece_flatfile_pvt.Interface_tbl_type;

1342:
1343: l_Header_tbl ece_flatfile_pvt.Interface_tbl_type;
1344: l_Header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
1345: l_alw_chg_h_tbl ece_flatfile_pvt.Interface_tbl_type;
1346: l_Line_tbl ece_flatfile_pvt.Interface_tbl_type;
1347: l_Line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
1348: l_alw_chg_l_tbl ece_flatfile_pvt.Interface_tbl_type;
1349:
1350: c_Header_common_key_name VARCHAR2(40);

Line 1347: l_Line_t_tbl ece_flatfile_pvt.Interface_tbl_type;

1343: l_Header_tbl ece_flatfile_pvt.Interface_tbl_type;
1344: l_Header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
1345: l_alw_chg_h_tbl ece_flatfile_pvt.Interface_tbl_type;
1346: l_Line_tbl ece_flatfile_pvt.Interface_tbl_type;
1347: l_Line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
1348: l_alw_chg_l_tbl ece_flatfile_pvt.Interface_tbl_type;
1349:
1350: c_Header_common_key_name VARCHAR2(40);
1351: c_Header_1_common_key_name VARCHAR2(40);

Line 1348: l_alw_chg_l_tbl ece_flatfile_pvt.Interface_tbl_type;

1344: l_Header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
1345: l_alw_chg_h_tbl ece_flatfile_pvt.Interface_tbl_type;
1346: l_Line_tbl ece_flatfile_pvt.Interface_tbl_type;
1347: l_Line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
1348: l_alw_chg_l_tbl ece_flatfile_pvt.Interface_tbl_type;
1349:
1350: c_Header_common_key_name VARCHAR2(40);
1351: c_Header_1_common_key_name VARCHAR2(40);
1352: c_Alw_chg_common_key_name VARCHAR2(40);

Line 1544: ece_flatfile_pvt.select_clause ( cTransaction_Type,

1540:
1541: ec_debug.pl ( 3, 'cAlw_chg_l_output_level: ',cAlw_chg_l_output_level );
1542:
1543: xProgress := '2020-60';
1544: ece_flatfile_pvt.select_clause ( cTransaction_Type,
1545: cCommunication_Method,
1546: cHeader_Interface,
1547: cHeader_X_Interface,
1548: l_Header_tbl,

Line 1555: ece_flatfile_pvt.select_clause ( cTransaction_Type,

1551: cHeader_from,
1552: cHeader_where );
1553:
1554: xProgress := '2030-60';
1555: ece_flatfile_pvt.select_clause ( cTransaction_Type,
1556: cCommunication_Method,
1557: cHeader_1_Interface,
1558: cHeader_1_X_Interface,
1559: l_Header_1_tbl,

Line 1566: ece_flatfile_pvt.select_clause ( cTransaction_Type,

1562: cHeader_1_from,
1563: cHeader_1_where );
1564:
1565: xProgress := '2040-60';
1566: ece_flatfile_pvt.select_clause ( cTransaction_Type,
1567: cCommunication_Method,
1568: cAlw_chg_Interface,
1569: cAlw_chg_X_Interface,
1570: l_alw_chg_h_tbl,

Line 1578: ece_flatfile_pvt.select_clause ( cTransaction_Type,

1574: cAlw_chg_h_where,
1575: cAlw_chg_h_output_level );
1576:
1577: xProgress := '2050-60';
1578: ece_flatfile_pvt.select_clause ( cTransaction_Type,
1579: cCommunication_Method,
1580: cLine_Interface,
1581: cLine_X_Interface,
1582: l_Line_tbl,

Line 1588: ece_flatfile_pvt.select_clause ( cTransaction_Type,

1584: cLine_select,
1585: cLine_from, cLine_where );
1586:
1587: xProgress := '2060-60';
1588: ece_flatfile_pvt.select_clause ( cTransaction_Type,
1589: cCommunication_Method,
1590: cLine_t_Interface,
1591: cLine_t_X_Interface,
1592: l_Line_t_tbl,

Line 1599: ece_flatfile_pvt.select_clause ( cTransaction_Type,

1595: cLine_t_from,
1596: cLine_t_where );
1597:
1598: xProgress := '2070-60';
1599: ece_flatfile_pvt.select_clause ( cTransaction_Type,
1600: cCommunication_Method,
1601: cAlw_chg_Interface,
1602: cAlw_chg_X_Interface,
1603: l_alw_chg_l_tbl,

Line 2219: ece_flatfile_pvt.G_MaxColWidth );

2215: LOOP
2216: dbms_sql.define_column ( Header_sel_c,
2217: k,
2218: cHeader_select,
2219: ece_flatfile_pvt.G_MaxColWidth );
2220: END LOOP;
2221:
2222: /***
2223: *** Need rowid for delete (Header Level)

Line 2248: ece_flatfile_pvt.G_MaxColWidth );

2244: LOOP
2245: dbms_sql.define_column ( Header_1_sel_c,
2246: k,
2247: cHeader_1_select,
2248: ece_flatfile_pvt.G_MaxColWidth );
2249: END LOOP;
2250:
2251: /***
2252: *** Need rowid for delete (Header 1 Level)

Line 2271: ece_flatfile_pvt.G_MaxColWidth );

2267: LOOP
2268: dbms_sql.define_column ( Alw_chg_h_sel_c,
2269: k,
2270: cAlw_chg_h_select,
2271: ece_flatfile_pvt.G_MaxColWidth );
2272: END LOOP;
2273:
2274: /***
2275: *** Need rowid for delete (Allowance Charges Header Level)

Line 2294: ece_flatfile_pvt.G_MaxColWidth );

2290: LOOP
2291: dbms_sql.define_column ( Line_sel_c,
2292: k,
2293: cLine_select,
2294: ece_flatfile_pvt.G_MaxColWidth );
2295: END LOOP;
2296:
2297: /***
2298: *** Need rowid for delete (Line Level)

Line 2317: ece_flatfile_pvt.G_MaxColWidth );

2313: LOOP
2314: dbms_sql.define_column ( Line_t_sel_c,
2315: k,
2316: cLine_t_select,
2317: ece_flatfile_pvt.G_MaxColWidth );
2318: END LOOP;
2319:
2320: /***
2321: *** Need rowid for delete (Line Level)

Line 2340: ece_flatfile_pvt.G_MaxColWidth );

2336: LOOP
2337: dbms_sql.define_column ( Alw_chg_l_sel_c,
2338: k,
2339: cAlw_chg_l_select,
2340: ece_flatfile_pvt.G_MaxColWidth );
2341: END LOOP;
2342:
2343: /***
2344: *** Need rowid for delete (Allowance Charges Detail Level)

Line 2368: ece_flatfile_pvt.Find_pos ( l_Line_tbl,

2364: *** we will need values for the join condition.
2365: ***/
2366:
2367: xProgress := '2380-60';
2368: ece_flatfile_pvt.Find_pos ( l_Line_tbl,
2369: 'LINE_NUMBER',
2370: nPos1 );
2371: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
2372:

Line 2424: ece_flatfile_pvt.Find_pos ( l_Header_tbl,

2420: iHeader_count + 3,
2421: nTrans_id );
2422:
2423: xProgress := '2430-60';
2424: ece_flatfile_pvt.Find_pos ( l_Header_tbl,
2425: ece_flatfile_pvt.G_Translator_Code,
2426: nTrans_code_pos );
2427: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
2428:

Line 2425: ece_flatfile_pvt.G_Translator_Code,

2421: nTrans_id );
2422:
2423: xProgress := '2430-60';
2424: ece_flatfile_pvt.Find_pos ( l_Header_tbl,
2425: ece_flatfile_pvt.G_Translator_Code,
2426: nTrans_code_pos );
2427: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
2428:
2429: xProgress := '2432-60';

Line 2430: ece_flatfile_pvt.Find_pos ( l_Header_tbl,

2426: nTrans_code_pos );
2427: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
2428:
2429: xProgress := '2432-60';
2430: ece_flatfile_pvt.Find_pos ( l_Header_tbl,
2431: c_header_common_key_name,
2432: nHeader_key_pos );
2433: ec_debug.pl ( 3, 'nHeader_key_pos: ',nHeader_key_pos );
2434:

Line 2452: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2448: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
2449:
2450:
2451: xProgress := '2450-60';
2452: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2453: cCommunication_Method,
2454: cHeader_Interface,
2455: l_Header_tbl,
2456: iOutput_width,

Line 2527: ece_flatfile_pvt.write_to_ece_output( cTransaction_Type,

2523: iHeader_1_count + 2,
2524: rHeader_1_X_rowid );
2525:
2526: xProgress := '2520-60';
2527: ece_flatfile_pvt.write_to_ece_output( cTransaction_Type,
2528: cCommunication_Method,
2529: cHeader_1_Interface,
2530: l_Header_1_tbl,
2531: iOutput_width,

Line 2603: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2599: iAlw_chg_h_count + 2,
2600: rAlw_chg_X_rowid );
2601:
2602: xProgress := '2570-60';
2603: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2604: cCommunication_Method,
2605: cAlw_chg_Interface,
2606: l_alw_chg_h_tbl,
2607: iOutput_width,

Line 2686: ece_flatfile_pvt.Find_pos ( l_Line_tbl,

2682: iLine_count + 2,
2683: rLine_X_rowid );
2684:
2685: xProgress := '2640-60';
2686: ece_flatfile_pvt.Find_pos ( l_Line_tbl,
2687: c_line_common_key_name,
2688: nLine_key_pos );
2689: ec_debug.pl ( 3, 'nLine_key_pos: ',nLine_key_pos );
2690:

Line 2705: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2701: RPAD(' ',22);
2702: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
2703:
2704: xProgress := '2660-60';
2705: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2706: cCommunication_Method,
2707: cLine_Interface,
2708: l_Line_tbl,
2709: iOutput_width,

Line 2761: ece_flatfile_pvt.Find_pos (l_Line_t_tbl,

2757: iLine_t_count + 2,
2758: rLine_t_X_rowid );
2759:
2760: xProgress := '2720-60';
2761: ece_flatfile_pvt.Find_pos (l_Line_t_tbl,
2762: c_Line_t_common_key_name,
2763: nLine_t_key_pos );
2764: ec_debug.pl ( 3, 'nLine_t_key_pos: ',nLine_t_key_pos );
2765:

Line 2782: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2778: 22);
2779: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
2780:
2781: xProgress := '2740-60';
2782: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2783: cCommunication_Method,
2784: cLine_t_Interface,
2785: l_Line_t_tbl,
2786: iOutput_width,

Line 2863: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2859: iAlw_chg_l_count + 2,
2860: rAlw_chg_X_rowid );
2861:
2862: xProgress := '2820-60';
2863: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2864: cCommunication_Method,
2865: cAlw_chg_Interface,
2866: l_alw_chg_l_tbl,
2867: iOutput_width,

Line 3133: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;

3129: For now, it will be hardcoded to NULL so the default will be the seeded FF transaction
3130: **/
3131: cMap_id NUMBER := NULL;
3132:
3133: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
3134: l_header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
3135: l_alw_chg_tbl ece_flatfile_pvt.Interface_tbl_type;
3136: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
3137: l_line_t_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 3134: l_header_1_tbl ece_flatfile_pvt.Interface_tbl_type;

3130: **/
3131: cMap_id NUMBER := NULL;
3132:
3133: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
3134: l_header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
3135: l_alw_chg_tbl ece_flatfile_pvt.Interface_tbl_type;
3136: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
3137: l_line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
3138: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 3135: l_alw_chg_tbl ece_flatfile_pvt.Interface_tbl_type;

3131: cMap_id NUMBER := NULL;
3132:
3133: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
3134: l_header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
3135: l_alw_chg_tbl ece_flatfile_pvt.Interface_tbl_type;
3136: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
3137: l_line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
3138: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
3139: -- l_veh_alw_chg_tbl veh_allowance_charge_sv.tab_for_allowance_charge;

Line 3136: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;

3132:
3133: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
3134: l_header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
3135: l_alw_chg_tbl ece_flatfile_pvt.Interface_tbl_type;
3136: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
3137: l_line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
3138: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
3139: -- l_veh_alw_chg_tbl veh_allowance_charge_sv.tab_for_allowance_charge;
3140:

Line 3137: l_line_t_tbl ece_flatfile_pvt.Interface_tbl_type;

3133: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
3134: l_header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
3135: l_alw_chg_tbl ece_flatfile_pvt.Interface_tbl_type;
3136: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
3137: l_line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
3138: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
3139: -- l_veh_alw_chg_tbl veh_allowance_charge_sv.tab_for_allowance_charge;
3140:
3141: Header_sel_c INTEGER;

Line 3138: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;

3134: l_header_1_tbl ece_flatfile_pvt.Interface_tbl_type;
3135: l_alw_chg_tbl ece_flatfile_pvt.Interface_tbl_type;
3136: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
3137: l_line_t_tbl ece_flatfile_pvt.Interface_tbl_type;
3138: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
3139: -- l_veh_alw_chg_tbl veh_allowance_charge_sv.tab_for_allowance_charge;
3140:
3141: Header_sel_c INTEGER;
3142: Header_1_sel_c INTEGER;

Line 3391: ece_flatfile_pvt.init_table(cTransaction_Type,cHeader_Interface,NULL,FALSE,l_header_tbl,l_key_tbl);

3387: ec_debug.pl ( 3, 'cDocument_Type: ',cDocument_Type );
3388: ec_debug.pl ( 3, 'cTransaction_Number: ',cTransaction_Number );
3389:
3390: xProgress := '2000-70';
3391: ece_flatfile_pvt.init_table(cTransaction_Type,cHeader_Interface,NULL,FALSE,l_header_tbl,l_key_tbl);
3392:
3393: xProgress := '2020-70';
3394: l_key_tbl := l_header_tbl;
3395:

Line 3400: ece_flatfile_pvt.init_table(cTransaction_Type,cHeader_1_Interface,NULL,TRUE,l_header_1_tbl,l_key_tbl);

3396: xProgress := '2022-70';
3397: iKey_count := l_header_tbl.count;
3398:
3399: xProgress := '2030-70';
3400: ece_flatfile_pvt.init_table(cTransaction_Type,cHeader_1_Interface,NULL,TRUE,l_header_1_tbl,l_key_tbl);
3401:
3402:
3403: /*
3404: * The output level is passed on for Allowance Charges table because the Interface

Line 3439: ece_flatfile_pvt.init_table(cTransaction_Type,cAlw_chg_Interface,l_alw_chg_output_level,TRUE,l_alw_chg_tbl,l_key_tbl);

3435: ec_debug.pl ( 3, 'l_alw_chg_output_level: ',l_alw_chg_output_level );
3436:
3437:
3438: xProgress := '2070-70';
3439: ece_flatfile_pvt.init_table(cTransaction_Type,cAlw_chg_Interface,l_alw_chg_output_level,TRUE,l_alw_chg_tbl,l_key_tbl);
3440:
3441: xProgress := '2100-70';
3442: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
3443:

Line 3442: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);

3438: xProgress := '2070-70';
3439: ece_flatfile_pvt.init_table(cTransaction_Type,cAlw_chg_Interface,l_alw_chg_output_level,TRUE,l_alw_chg_tbl,l_key_tbl);
3440:
3441: xProgress := '2100-70';
3442: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
3443:
3444: xProgress := '2130-70';
3445: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_t_Interface,NULL,TRUE,l_line_t_tbl,l_key_tbl);
3446:

Line 3445: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_t_Interface,NULL,TRUE,l_line_t_tbl,l_key_tbl);

3441: xProgress := '2100-70';
3442: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
3443:
3444: xProgress := '2130-70';
3445: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_t_Interface,NULL,TRUE,l_line_t_tbl,l_key_tbl);
3446:
3447: -- ***************************************************************************
3448: --
3449: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic

Line 4055: ece_flatfile_pvt.G_Transaction_date,

4051: -- ***************************************************
4052:
4053: xProgress := '2460-70';
4054: ece_extract_utils_pub.Find_pos ( l_header_tbl,
4055: ece_flatfile_pvt.G_Transaction_date,
4056: n_trx_date_pos );
4057:
4058: xProgress := '2470-70';
4059: l_header_tbl(n_trx_date_pos).value := TO_CHAR(dTransaction_date,'YYYYMMDD HH24MISS');