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

Line 21: 08/05/99 mguthrie Added calls to ECE_FLATFILE_PVT.INIT_TABLE

17: Changed ECE_ to GML_ prefix. Ported some 11.0 fixes to 11i
18: Corrected some obsolete references to DSNO to GASNO
19: 06/08/99 dgrailic made argumnet list agrree with concurent
20: program parameter list.
21: 08/05/99 mguthrie Added calls to ECE_FLATFILE_PVT.INIT_TABLE
22: 10/27/99 SFeinstein B911176: changed format of date for Y2K
23: 26-OCT-2002 Bug#2642152 RajaSekhar Added NOCOPY hint
24:
25: ===========================================================================*/

Line 359: v_SHP_Table ece_flatfile_pvt.Interface_tbl_type;

355:
356:
357: xProgress VARCHAR2(30);
358:
359: v_SHP_Table ece_flatfile_pvt.Interface_tbl_type;
360: v_STX_Table ece_flatfile_pvt.Interface_tbl_type;
361: v_ORD_Table ece_flatfile_pvt.Interface_tbl_type;
362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;
363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;

Line 360: v_STX_Table ece_flatfile_pvt.Interface_tbl_type;

356:
357: xProgress VARCHAR2(30);
358:
359: v_SHP_Table ece_flatfile_pvt.Interface_tbl_type;
360: v_STX_Table ece_flatfile_pvt.Interface_tbl_type;
361: v_ORD_Table ece_flatfile_pvt.Interface_tbl_type;
362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;
363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;
364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;

Line 361: v_ORD_Table ece_flatfile_pvt.Interface_tbl_type;

357: xProgress VARCHAR2(30);
358:
359: v_SHP_Table ece_flatfile_pvt.Interface_tbl_type;
360: v_STX_Table ece_flatfile_pvt.Interface_tbl_type;
361: v_ORD_Table ece_flatfile_pvt.Interface_tbl_type;
362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;
363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;
364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;
365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;

Line 362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;

358:
359: v_SHP_Table ece_flatfile_pvt.Interface_tbl_type;
360: v_STX_Table ece_flatfile_pvt.Interface_tbl_type;
361: v_ORD_Table ece_flatfile_pvt.Interface_tbl_type;
362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;
363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;
364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;
365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;
366: v_DTX_Table ece_flatfile_pvt.Interface_tbl_type;

Line 363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;

359: v_SHP_Table ece_flatfile_pvt.Interface_tbl_type;
360: v_STX_Table ece_flatfile_pvt.Interface_tbl_type;
361: v_ORD_Table ece_flatfile_pvt.Interface_tbl_type;
362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;
363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;
364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;
365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;
366: v_DTX_Table ece_flatfile_pvt.Interface_tbl_type;
367: v_ALL_Table ece_flatfile_pvt.Interface_tbl_type;

Line 364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;

360: v_STX_Table ece_flatfile_pvt.Interface_tbl_type;
361: v_ORD_Table ece_flatfile_pvt.Interface_tbl_type;
362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;
363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;
364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;
365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;
366: v_DTX_Table ece_flatfile_pvt.Interface_tbl_type;
367: v_ALL_Table ece_flatfile_pvt.Interface_tbl_type;
368: v_CrossRefTable ece_flatfile_pvt.Interface_tbl_type;

Line 365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;

361: v_ORD_Table ece_flatfile_pvt.Interface_tbl_type;
362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;
363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;
364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;
365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;
366: v_DTX_Table ece_flatfile_pvt.Interface_tbl_type;
367: v_ALL_Table ece_flatfile_pvt.Interface_tbl_type;
368: v_CrossRefTable ece_flatfile_pvt.Interface_tbl_type;
369:

Line 366: v_DTX_Table ece_flatfile_pvt.Interface_tbl_type;

362: v_OAC_Table ece_flatfile_pvt.Interface_tbl_type;
363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;
364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;
365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;
366: v_DTX_Table ece_flatfile_pvt.Interface_tbl_type;
367: v_ALL_Table ece_flatfile_pvt.Interface_tbl_type;
368: v_CrossRefTable ece_flatfile_pvt.Interface_tbl_type;
369:
370: v_SHP_Cursor INTEGER;

Line 367: v_ALL_Table ece_flatfile_pvt.Interface_tbl_type;

363: v_OTX_Table ece_flatfile_pvt.Interface_tbl_type;
364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;
365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;
366: v_DTX_Table ece_flatfile_pvt.Interface_tbl_type;
367: v_ALL_Table ece_flatfile_pvt.Interface_tbl_type;
368: v_CrossRefTable ece_flatfile_pvt.Interface_tbl_type;
369:
370: v_SHP_Cursor INTEGER;
371: v_STX_Cursor INTEGER;

Line 368: v_CrossRefTable ece_flatfile_pvt.Interface_tbl_type;

364: v_DTL_Table ece_flatfile_pvt.Interface_tbl_type;
365: v_DAC_Table ece_flatfile_pvt.Interface_tbl_type;
366: v_DTX_Table ece_flatfile_pvt.Interface_tbl_type;
367: v_ALL_Table ece_flatfile_pvt.Interface_tbl_type;
368: v_CrossRefTable ece_flatfile_pvt.Interface_tbl_type;
369:
370: v_SHP_Cursor INTEGER;
371: v_STX_Cursor INTEGER;
372: v_ORD_Cursor INTEGER;

Line 567: ece_flatfile_pvt.init_table(p_TransactionType,p_SHP_Interface,NULL,FALSE,v_SHP_Table,v_CrossRefTable);

563: ec_debug.pl ( 3, 'v_BOL_No_From : ',v_BOL_No_From );
564: ec_debug.pl ( 3, 'v_BOL_No_To : ',v_BOL_No_To );
565:
566: xProgress := 'GASNOB-10-1000';
567: ece_flatfile_pvt.init_table(p_TransactionType,p_SHP_Interface,NULL,FALSE,v_SHP_Table,v_CrossRefTable);
568:
569: /* */
570: /* Initialize the Cross Reference PL/SQL table. This table is a */
571: /* concatenation of all the interface PL/SQL tables. */

Line 580: ece_flatfile_pvt.init_table(p_TransactionType,p_STX_Interface,NULL,TRUE,v_STX_Table,v_CrossRefTable);

576: v_CrossRefCount := v_SHP_Table.COUNT;
577: ec_debug.pl ( 3, 'v_CrossRefCount: ', v_CrossRefCount );
578:
579: xProgress := 'GASNOB-10-1030';
580: ece_flatfile_pvt.init_table(p_TransactionType,p_STX_Interface,NULL,TRUE,v_STX_Table,v_CrossRefTable);
581:
582: xProgress := 'GASNOB-10-1070';
583: ece_flatfile_pvt.init_table(p_TransactionType,p_ORD_Interface,NULL,TRUE,v_ORD_Table,v_CrossRefTable);
584:

Line 583: ece_flatfile_pvt.init_table(p_TransactionType,p_ORD_Interface,NULL,TRUE,v_ORD_Table,v_CrossRefTable);

579: xProgress := 'GASNOB-10-1030';
580: ece_flatfile_pvt.init_table(p_TransactionType,p_STX_Interface,NULL,TRUE,v_STX_Table,v_CrossRefTable);
581:
582: xProgress := 'GASNOB-10-1070';
583: ece_flatfile_pvt.init_table(p_TransactionType,p_ORD_Interface,NULL,TRUE,v_ORD_Table,v_CrossRefTable);
584:
585: xProgress := 'GASNOB-10-1100';
586: ece_flatfile_pvt.init_table(p_TransactionType,p_OAC_Interface,NULL,TRUE,v_OAC_Table,v_CrossRefTable);
587:

Line 586: ece_flatfile_pvt.init_table(p_TransactionType,p_OAC_Interface,NULL,TRUE,v_OAC_Table,v_CrossRefTable);

582: xProgress := 'GASNOB-10-1070';
583: ece_flatfile_pvt.init_table(p_TransactionType,p_ORD_Interface,NULL,TRUE,v_ORD_Table,v_CrossRefTable);
584:
585: xProgress := 'GASNOB-10-1100';
586: ece_flatfile_pvt.init_table(p_TransactionType,p_OAC_Interface,NULL,TRUE,v_OAC_Table,v_CrossRefTable);
587:
588: xProgress := 'GASNOB-10-1130';
589: ece_flatfile_pvt.init_table(p_TransactionType,p_OTX_Interface,NULL,TRUE,v_OTX_Table,v_CrossRefTable);
590:

Line 589: ece_flatfile_pvt.init_table(p_TransactionType,p_OTX_Interface,NULL,TRUE,v_OTX_Table,v_CrossRefTable);

585: xProgress := 'GASNOB-10-1100';
586: ece_flatfile_pvt.init_table(p_TransactionType,p_OAC_Interface,NULL,TRUE,v_OAC_Table,v_CrossRefTable);
587:
588: xProgress := 'GASNOB-10-1130';
589: ece_flatfile_pvt.init_table(p_TransactionType,p_OTX_Interface,NULL,TRUE,v_OTX_Table,v_CrossRefTable);
590:
591: xProgress := 'GASNOB-10-1160';
592: ece_flatfile_pvt.init_table(p_TransactionType,p_DTL_Interface,NULL,TRUE,v_DTL_Table,v_CrossRefTable);
593:

Line 592: ece_flatfile_pvt.init_table(p_TransactionType,p_DTL_Interface,NULL,TRUE,v_DTL_Table,v_CrossRefTable);

588: xProgress := 'GASNOB-10-1130';
589: ece_flatfile_pvt.init_table(p_TransactionType,p_OTX_Interface,NULL,TRUE,v_OTX_Table,v_CrossRefTable);
590:
591: xProgress := 'GASNOB-10-1160';
592: ece_flatfile_pvt.init_table(p_TransactionType,p_DTL_Interface,NULL,TRUE,v_DTL_Table,v_CrossRefTable);
593:
594:
595: xProgress := 'GASNOB-10-1190';
596: ece_flatfile_pvt.init_table(p_TransactionType,p_DAC_Interface,NULL,TRUE,v_DAC_Table,v_CrossRefTable);

Line 596: ece_flatfile_pvt.init_table(p_TransactionType,p_DAC_Interface,NULL,TRUE,v_DAC_Table,v_CrossRefTable);

592: ece_flatfile_pvt.init_table(p_TransactionType,p_DTL_Interface,NULL,TRUE,v_DTL_Table,v_CrossRefTable);
593:
594:
595: xProgress := 'GASNOB-10-1190';
596: ece_flatfile_pvt.init_table(p_TransactionType,p_DAC_Interface,NULL,TRUE,v_DAC_Table,v_CrossRefTable);
597:
598: xProgress := 'GASNOB-10-1211';
599: ece_flatfile_pvt.init_table(p_TransactionType,p_DTX_Interface,NULL,TRUE,v_DTX_Table,v_CrossRefTable);
600:

Line 599: ece_flatfile_pvt.init_table(p_TransactionType,p_DTX_Interface,NULL,TRUE,v_DTX_Table,v_CrossRefTable);

595: xProgress := 'GASNOB-10-1190';
596: ece_flatfile_pvt.init_table(p_TransactionType,p_DAC_Interface,NULL,TRUE,v_DAC_Table,v_CrossRefTable);
597:
598: xProgress := 'GASNOB-10-1211';
599: ece_flatfile_pvt.init_table(p_TransactionType,p_DTX_Interface,NULL,TRUE,v_DTX_Table,v_CrossRefTable);
600:
601: xProgress := 'GASNOB-10-1213';
602: ece_flatfile_pvt.init_table(p_TransactionType,p_ALL_Interface,NULL,TRUE,v_ALL_Table,v_CrossRefTable);
603:

Line 602: ece_flatfile_pvt.init_table(p_TransactionType,p_ALL_Interface,NULL,TRUE,v_ALL_Table,v_CrossRefTable);

598: xProgress := 'GASNOB-10-1211';
599: ece_flatfile_pvt.init_table(p_TransactionType,p_DTX_Interface,NULL,TRUE,v_DTX_Table,v_CrossRefTable);
600:
601: xProgress := 'GASNOB-10-1213';
602: ece_flatfile_pvt.init_table(p_TransactionType,p_ALL_Interface,NULL,TRUE,v_ALL_Table,v_CrossRefTable);
603:
604:
605: /* */
606: /* The 'select_clause' procedure will build the SELECT, FROM and WHERE */

Line 2001: v_SHP_Table ece_flatfile_pvt.interface_tbl_type;

1997: /* */
1998:
1999: xProgress VARCHAR2(30);
2000:
2001: v_SHP_Table ece_flatfile_pvt.interface_tbl_type;
2002: v_STX_Table ece_flatfile_pvt.interface_tbl_type;
2003: v_ORD_Table ece_flatfile_pvt.interface_tbl_type;
2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;
2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;

Line 2002: v_STX_Table ece_flatfile_pvt.interface_tbl_type;

1998:
1999: xProgress VARCHAR2(30);
2000:
2001: v_SHP_Table ece_flatfile_pvt.interface_tbl_type;
2002: v_STX_Table ece_flatfile_pvt.interface_tbl_type;
2003: v_ORD_Table ece_flatfile_pvt.interface_tbl_type;
2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;
2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;
2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;

Line 2003: v_ORD_Table ece_flatfile_pvt.interface_tbl_type;

1999: xProgress VARCHAR2(30);
2000:
2001: v_SHP_Table ece_flatfile_pvt.interface_tbl_type;
2002: v_STX_Table ece_flatfile_pvt.interface_tbl_type;
2003: v_ORD_Table ece_flatfile_pvt.interface_tbl_type;
2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;
2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;
2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;
2007: v_DAC_Table ece_flatfile_pvt.interface_tbl_type;

Line 2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;

2000:
2001: v_SHP_Table ece_flatfile_pvt.interface_tbl_type;
2002: v_STX_Table ece_flatfile_pvt.interface_tbl_type;
2003: v_ORD_Table ece_flatfile_pvt.interface_tbl_type;
2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;
2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;
2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;
2007: v_DAC_Table ece_flatfile_pvt.interface_tbl_type;
2008: v_DTX_Table ece_flatfile_pvt.interface_tbl_type;

Line 2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;

2001: v_SHP_Table ece_flatfile_pvt.interface_tbl_type;
2002: v_STX_Table ece_flatfile_pvt.interface_tbl_type;
2003: v_ORD_Table ece_flatfile_pvt.interface_tbl_type;
2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;
2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;
2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;
2007: v_DAC_Table ece_flatfile_pvt.interface_tbl_type;
2008: v_DTX_Table ece_flatfile_pvt.interface_tbl_type;
2009: v_ALL_Table ece_flatfile_pvt.interface_tbl_type;

Line 2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;

2002: v_STX_Table ece_flatfile_pvt.interface_tbl_type;
2003: v_ORD_Table ece_flatfile_pvt.interface_tbl_type;
2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;
2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;
2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;
2007: v_DAC_Table ece_flatfile_pvt.interface_tbl_type;
2008: v_DTX_Table ece_flatfile_pvt.interface_tbl_type;
2009: v_ALL_Table ece_flatfile_pvt.interface_tbl_type;
2010:

Line 2007: v_DAC_Table ece_flatfile_pvt.interface_tbl_type;

2003: v_ORD_Table ece_flatfile_pvt.interface_tbl_type;
2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;
2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;
2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;
2007: v_DAC_Table ece_flatfile_pvt.interface_tbl_type;
2008: v_DTX_Table ece_flatfile_pvt.interface_tbl_type;
2009: v_ALL_Table ece_flatfile_pvt.interface_tbl_type;
2010:
2011: v_SHP_CommonKeyName VARCHAR2(40);

Line 2008: v_DTX_Table ece_flatfile_pvt.interface_tbl_type;

2004: v_OAC_Table ece_flatfile_pvt.interface_tbl_type;
2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;
2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;
2007: v_DAC_Table ece_flatfile_pvt.interface_tbl_type;
2008: v_DTX_Table ece_flatfile_pvt.interface_tbl_type;
2009: v_ALL_Table ece_flatfile_pvt.interface_tbl_type;
2010:
2011: v_SHP_CommonKeyName VARCHAR2(40);
2012: v_STX_CommonKeyName VARCHAR2(40);

Line 2009: v_ALL_Table ece_flatfile_pvt.interface_tbl_type;

2005: v_OTX_Table ece_flatfile_pvt.interface_tbl_type;
2006: v_DTL_Table ece_flatfile_pvt.interface_tbl_type;
2007: v_DAC_Table ece_flatfile_pvt.interface_tbl_type;
2008: v_DTX_Table ece_flatfile_pvt.interface_tbl_type;
2009: v_ALL_Table ece_flatfile_pvt.interface_tbl_type;
2010:
2011: v_SHP_CommonKeyName VARCHAR2(40);
2012: v_STX_CommonKeyName VARCHAR2(40);
2013: v_ORD_CommonKeyName VARCHAR2(40);

Line 2221: ece_flatfile_pvt.select_clause ( p_TransactionType,

2217: /* */
2218:
2219: v_RunID := p_RunID;
2220: xProgress := 'GASNOB-40-1000';
2221: ece_flatfile_pvt.select_clause ( p_TransactionType,
2222: p_CommunicationMethod,
2223: p_SHP_Interface,
2224: v_SHP_XInterface,
2225: v_SHP_Table,

Line 2232: ece_flatfile_pvt.select_clause ( p_TransactionType,

2228: v_SHP_From,
2229: v_SHP_Where );
2230:
2231: xProgress := 'GASNOB-40-1010';
2232: ece_flatfile_pvt.select_clause ( p_TransactionType,
2233: p_CommunicationMethod,
2234: p_STX_Interface,
2235: v_STX_XInterface,
2236: v_STX_Table,

Line 2243: ece_flatfile_pvt.select_clause ( p_TransactionType,

2239: v_STX_From,
2240: v_STX_Where );
2241:
2242: xProgress := 'GASNOB-40-1020';
2243: ece_flatfile_pvt.select_clause ( p_TransactionType,
2244: p_CommunicationMethod,
2245: p_ORD_Interface,
2246: v_ORD_XInterface,
2247: v_ORD_Table,

Line 2254: ece_flatfile_pvt.select_clause ( p_TransactionType,

2250: v_ORD_From,
2251: v_ORD_Where );
2252:
2253: xProgress := 'GASNOB-40-1030';
2254: ece_flatfile_pvt.select_clause ( p_TransactionType,
2255: p_CommunicationMethod,
2256: p_OAC_Interface,
2257: v_OAC_XInterface,
2258: v_OAC_Table,

Line 2265: ece_flatfile_pvt.select_clause ( p_TransactionType,

2261: v_OAC_From,
2262: v_OAC_Where );
2263:
2264: xProgress := 'GASNOB-40-1040';
2265: ece_flatfile_pvt.select_clause ( p_TransactionType,
2266: p_CommunicationMethod,
2267: p_OTX_Interface,
2268: v_OTX_XInterface,
2269: v_OTX_Table,

Line 2277: ece_flatfile_pvt.select_clause ( p_TransactionType,

2273: v_OTX_Where );
2274:
2275:
2276: xProgress := 'GASNOB-40-1050';
2277: ece_flatfile_pvt.select_clause ( p_TransactionType,
2278: p_CommunicationMethod,
2279: p_DTL_Interface,
2280: v_DTL_XInterface,
2281: v_DTL_Table,

Line 2288: ece_flatfile_pvt.select_clause ( p_TransactionType,

2284: v_DTL_From,
2285: v_DTL_Where );
2286:
2287: xProgress := 'GASNOB-40-1060';
2288: ece_flatfile_pvt.select_clause ( p_TransactionType,
2289: p_CommunicationMethod,
2290: p_DAC_Interface,
2291: v_DAC_XInterface,
2292: v_DAC_Table,

Line 2299: ece_flatfile_pvt.select_clause ( p_TransactionType,

2295: v_DAC_From,
2296: v_DAC_Where );
2297:
2298: xProgress := 'GASNOB-40-1070';
2299: ece_flatfile_pvt.select_clause ( p_TransactionType,
2300: p_CommunicationMethod,
2301: p_DTX_Interface,
2302: v_DTX_XInterface,
2303: v_DTX_Table,

Line 2310: ece_flatfile_pvt.select_clause ( p_TransactionType,

2306: v_DTX_From,
2307: v_DTX_Where );
2308:
2309: xProgress := 'GASNOB-40-1070';
2310: ece_flatfile_pvt.select_clause ( p_TransactionType,
2311: p_CommunicationMethod,
2312: p_ALL_Interface,
2313: v_ALL_XInterface,
2314: v_ALL_Table,

Line 3443: ece_flatfile_pvt.find_pos ( v_SHP_Table,

3439: /* record, so save the values. */
3440: /* */
3441:
3442: xProgress := 'GASNOB-40-1880';
3443: ece_flatfile_pvt.find_pos ( v_SHP_Table,
3444: /*ece_flatfile_pvt.G_Translator_Code, */
3445: 'TP_CODE',
3446: v_TranslatorCodePosition );
3447: /*

Line 3444: /ece_flatfile_pvt.G_Translator_Code, /

3440: /* */
3441:
3442: xProgress := 'GASNOB-40-1880';
3443: ece_flatfile_pvt.find_pos ( v_SHP_Table,
3444: /*ece_flatfile_pvt.G_Translator_Code, */
3445: 'TP_CODE',
3446: v_TranslatorCodePosition );
3447: /*
3448: dbms_output.put_line(' v_shp_commonkeyname = ' || v_shp_commonkeyname);

Line 3452: ece_flatfile_pvt.find_pos ( v_SHP_Table,

3448: dbms_output.put_line(' v_shp_commonkeyname = ' || v_shp_commonkeyname);
3449: dbms_output.put_line(' v_shp_cknameposition = ' || v_shp_cknameposition);
3450: */
3451: xProgress := 'GASNOB-40-1890';
3452: ece_flatfile_pvt.find_pos ( v_SHP_Table,
3453: v_SHP_CommonKeyName,
3454: v_SHP_CKNamePosition );
3455:
3456: xProgress := 'GASNOB-40-1900';

Line 3475: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3471: /* Write the record to the output table. */
3472: /* */
3473:
3474: xProgress := 'GASNOB-40-1930';
3475: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3476: p_CommunicationMethod,
3477: p_SHP_Interface,
3478: v_SHP_Table,
3479: p_OutputWidth,

Line 3497: ece_flatfile_pvt.find_pos( v_SHP_Table,

3493: v_TransactionRecordID );
3494:
3495:
3496: xProgress := 'GASNOB-40-2020';
3497: ece_flatfile_pvt.find_pos( v_SHP_Table,
3498: 'BOL_ID',
3499: v_BOL_ID_Position );
3500:
3501: /* */

Line 3550: ece_flatfile_pvt.find_pos ( v_STX_Table,

3546: v_STX_Count + 2,
3547: v_STX_XRowID );
3548:
3549: xProgress := 'GASNOB-40-2082';
3550: ece_flatfile_pvt.find_pos ( v_STX_Table,
3551: v_STX_CommonKeyName,
3552: v_STX_CKNamePosition );
3553:
3554: xProgress := 'GASNOB-40-2084';

Line 3568: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3564: /* Write the record to the output table. */
3565: /* */
3566:
3567: xProgress := 'GASNOB-40-2090';
3568: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3569: p_CommunicationMethod,
3570: p_STX_Interface,
3571: v_STX_Table,
3572: p_OutputWidth,

Line 3639: ece_flatfile_pvt.find_pos ( v_ORD_Table,

3635: v_ORD_Count + 2,
3636: v_ORD_XRowID );
3637:
3638: xProgress := 'GASNOB-40-2151';
3639: ece_flatfile_pvt.find_pos ( v_ORD_Table,
3640: v_ORD_CommonKeyName,
3641: v_ORD_CKNamePosition );
3642:
3643: xProgress := 'GASNOB-40-2152';

Line 3658: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3654: /* Write the record to the output table. */
3655: /* */
3656:
3657: xProgress := 'GASNOB-40-2160';
3658: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3659: p_CommunicationMethod,
3660: p_ORD_Interface,
3661: v_ORD_Table,
3662: p_OutputWidth,

Line 3694: ece_flatfile_pvt.find_pos( v_ORD_Table,

3690: /* */
3691: /* Execute the Order DAC SELECT statement. */
3692: /* */
3693: xProgress := 'GASNOB-40-2205';
3694: ece_flatfile_pvt.find_pos( v_ORD_Table,
3695: 'Order_ID',
3696: v_Order_ID_Position );
3697:
3698: xProgress := 'GASNOB-40-2206';

Line 3744: ece_flatfile_pvt.find_pos ( v_OAC_Table,

3740: v_OAC_Count + 2,
3741: v_OAC_XRowID );
3742:
3743: xProgress := 'GASNOB-40-2270';
3744: ece_flatfile_pvt.find_pos ( v_OAC_Table,
3745: v_OAC_CommonKeyName,
3746: v_OAC_CKNamePosition);
3747:
3748: xProgress := 'GASNOB-40-2280';

Line 3764: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3760: /* Write the record to the output table. */
3761: /* */
3762:
3763: xProgress := 'GASNOB-40-2300';
3764: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3765: p_CommunicationMethod,
3766: p_OAC_Interface,
3767: v_OAC_Table,
3768: p_OutputWidth,

Line 3835: ece_flatfile_pvt.find_pos ( v_OTX_Table,

3831: v_OTX_Count + 2,
3832: v_OTX_XRowID );
3833:
3834: xProgress := 'GASNOB-40-2420';
3835: ece_flatfile_pvt.find_pos ( v_OTX_Table,
3836: v_OTX_CommonKeyName,
3837: v_OTX_CKNamePosition);
3838:
3839: xProgress := 'GASNOB-40-2430';

Line 3854: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3850: /* Write the record to the output table. */
3851: /* */
3852:
3853: xProgress := 'GASNOB-40-2450';
3854: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3855: p_CommunicationMethod,
3856: p_OTX_Interface,
3857: v_OTX_Table,
3858: p_OutputWidth,

Line 3933: ece_flatfile_pvt.find_pos ( v_DTL_Table,

3929: /* value to the common key. */
3930: /* */
3931:
3932: xProgress := 'GASNOB-40-2570';
3933: ece_flatfile_pvt.find_pos ( v_DTL_Table,
3934: v_DTL_CommonKeyName,
3935: v_DTL_CKNamePosition);
3936:
3937: xProgress := 'GASNOB-40-2580';

Line 3953: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3949: /* Write the record to the output table. */
3950: /* */
3951:
3952: xProgress := 'GASNOB-40-2600';
3953: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3954: p_CommunicationMethod,
3955: p_DTL_Interface,
3956: v_DTL_Table,
3957: p_OutputWidth,

Line 3985: ece_flatfile_pvt.find_pos( v_DTL_Table,

3981: /* */
3982: /* Execute the Detail DAC SELECT statement. */
3983: /* */
3984: xProgress := 'GASNOB-40-2650';
3985: ece_flatfile_pvt.find_pos( v_DTL_Table,
3986: 'Line_ID',
3987: v_Line_ID_Position );
3988:
3989: xProgress := 'GASNOB-40-2660';

Line 4048: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

4044: /* Write the record to the output table. */
4045: /* */
4046:
4047: xProgress := 'GASNOB-40-2770';
4048: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
4049: p_CommunicationMethod,
4050: p_DAC_Interface,
4051: v_DAC_Table,
4052: p_OutputWidth,

Line 4128: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

4124: /* Write the record to the output table. */
4125: /* */
4126:
4127: xProgress := 'GASNOB-40-2920';
4128: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
4129: p_CommunicationMethod,
4130: p_DTX_Interface,
4131: v_DTX_Table,
4132: p_OutputWidth,

Line 4208: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

4204: /* Write the record to the output table. */
4205: /* */
4206:
4207: xProgress := 'GASNOB-40-3030';
4208: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
4209: p_CommunicationMethod,
4210: p_ALL_Interface,
4211: v_ALL_Table,
4212: p_OutputWidth,