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_ADVO_ADVICE_PKG dependencies on ECE_FLATFILE_PVT

Line 366: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;

362: xProgress VARCHAR2(30);
363: v_LevelProcessed VARCHAR2(40);
364: cOutput_path VARCHAR2(120);
365:
366: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
367: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
368: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
369:
370: Header_sel_c INTEGER;

Line 367: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;

363: v_LevelProcessed VARCHAR2(40);
364: cOutput_path VARCHAR2(120);
365:
366: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
367: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
368: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
369:
370: Header_sel_c INTEGER;
371: Line_sel_c INTEGER;

Line 368: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;

364: cOutput_path VARCHAR2(120);
365:
366: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
367: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
368: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
369:
370: Header_sel_c INTEGER;
371: Line_sel_c INTEGER;
372:

Line 440: ece_flatfile_pvt.INIT_TABLE( cTransaction_Type,

436: **
437: */
438:
439: xProgress := 'ADVOB-10-1000';
440: ece_flatfile_pvt.INIT_TABLE( cTransaction_Type,
441: cHeader_Interface,
442: NULL,
443: FALSE,
444: l_header_tbl,

Line 451: ece_flatfile_pvt.INIT_TABLE( cTransaction_Type,

447: xProgress := 'ADVOB-10-1010';
448: l_key_tbl := l_header_tbl;
449:
450: xProgress := 'ADVOB-10-1030';
451: ece_flatfile_pvt.INIT_TABLE( cTransaction_Type,
452: cLine_Interface,
453: NULL,
454: TRUE,
455: l_Line_tbl,

Line 1188: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;

1184: xProgress VARCHAR2(30);
1185: v_LevelProcessed VARCHAR2(40);
1186: cOutput_path VARCHAR2(120);
1187:
1188: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
1189: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
1190:
1191: c_header_common_key_name VARCHAR2(40);
1192: c_line_common_key_name VARCHAR2(40);

Line 1189: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;

1185: v_LevelProcessed VARCHAR2(40);
1186: cOutput_path VARCHAR2(120);
1187:
1188: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
1189: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
1190:
1191: c_header_common_key_name VARCHAR2(40);
1192: c_line_common_key_name VARCHAR2(40);
1193: c_key_3 VARCHAR2(22):= RPAD(' ',22);

Line 1271: ece_flatfile_pvt.select_clause ( cTransaction_Type,

1267: */
1268:
1269:
1270: xProgress := 'ADVOB-20-1020';
1271: ece_flatfile_pvt.select_clause ( cTransaction_Type,
1272: cCommunication_Method,
1273: cHeader_Interface,
1274: cHeader_X_Interface,
1275: l_header_tbl,

Line 1283: ece_flatfile_pvt.select_clause ( cTransaction_Type,

1279: cHeader_where );
1280:
1281:
1282: xProgress := 'ADVOB-20-1030';
1283: ece_flatfile_pvt.select_clause ( cTransaction_Type,
1284: cCommunication_Method,
1285: cLine_Interface,
1286: cLine_X_Interface,
1287: l_line_tbl,

Line 1514: ece_flatfile_pvt.G_MaxColWidth );

1510: LOOP
1511: dbms_sql.define_column ( Header_sel_c,
1512: k,
1513: cHeader_select,
1514: ece_flatfile_pvt.G_MaxColWidth );
1515: END LOOP;
1516:
1517: /*
1518: **

Line 1548: ece_flatfile_pvt.G_MaxColWidth );

1544: LOOP
1545: dbms_sql.define_column ( Line_sel_c,
1546: k,
1547: cLine_select,
1548: ece_flatfile_pvt.G_MaxColWidth );
1549: END LOOP;
1550:
1551: /*
1552: **

Line 1576: ece_flatfile_pvt.Find_pos ( l_header_tbl,

1572: **
1573: */
1574:
1575: xProgress := 'ADVOB-20-1340';
1576: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1577: ece_flatfile_pvt.G_Translator_Code,
1578: nTrans_code_pos );
1579: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
1580:

Line 1577: ece_flatfile_pvt.G_Translator_Code,

1573: */
1574:
1575: xProgress := 'ADVOB-20-1340';
1576: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1577: ece_flatfile_pvt.G_Translator_Code,
1578: nTrans_code_pos );
1579: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
1580:
1581: xProgress := 'ADVOB-20-1350';

Line 1582: ece_flatfile_pvt.Find_pos ( l_header_tbl,

1578: nTrans_code_pos );
1579: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
1580:
1581: xProgress := 'ADVOB-20-1350';
1582: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1583: c_header_common_key_name,
1584: nHeader_key_pos );
1585: ec_debug.pl ( 3, 'nHeader_key_pos: ',nHeader_key_pos );
1586:

Line 1588: ece_flatfile_pvt.Find_pos ( l_header_tbl,

1584: nHeader_key_pos );
1585: ec_debug.pl ( 3, 'nHeader_key_pos: ',nHeader_key_pos );
1586:
1587: xProgress := 'ADVOB-20-1360';
1588: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1589: 'ADVICE_HEADER_ID',
1590: n_advice_header_id_pos );
1591: ec_debug.pl ( 3, 'n_advice_header_id_pos: ',n_advice_header_id_pos );
1592:

Line 1595: ece_flatfile_pvt.Find_pos ( l_line_tbl,

1591: ec_debug.pl ( 3, 'n_advice_header_id_pos: ',n_advice_header_id_pos );
1592:
1593:
1594: xProgress := 'ADVOB-20-1370';
1595: ece_flatfile_pvt.Find_pos ( l_line_tbl,
1596: c_line_common_key_name,
1597: nLine_key_pos );
1598: ec_debug.pl ( 3, 'nLine_key_pos: ',nLine_key_pos );
1599:

Line 1682: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

1678: **
1679: */
1680:
1681: xProgress := 'ADVOB-20-1450';
1682: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
1683: cCommunication_Method,
1684: cHeader_Interface,
1685: l_header_tbl,
1686: iOutput_width,

Line 1782: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

1778: **
1779: */
1780:
1781: xProgress := 'ADVOB-20-1530';
1782: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
1783: cCommunication_Method,
1784: cLine_Interface,
1785: l_line_tbl,
1786: iOutput_width,