APPS.GML_GPOAO dependencies on ECE_OUTPUT

Line 96: FROM ece_output

92: /* end of Y2K issue. */
93:
94: CURSOR c_OutputSource IS
95: SELECT text
96: FROM ece_output
97: WHERE run_id = v_RunID
98: ORDER BY line_id;
99:
100: BEGIN

Line 116: /* records in the output table (ECE_OUTPUT) so that multiple processes may use */

112: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
113:
114:
115: /* Get a unique ID for the run of this script. This ID is used to group the */
116: /* records in the output table (ECE_OUTPUT) so that multiple processes may use */
117: /* this table concurrently. */
118: xProgress := 'GPOAO-10-1010';
119: BEGIN
120: SELECT ece_output_runs_s.NEXTVAL

Line 120: SELECT ece_output_runs_s.NEXTVAL

116: /* records in the output table (ECE_OUTPUT) so that multiple processes may use */
117: /* this table concurrently. */
118: xProgress := 'GPOAO-10-1010';
119: BEGIN
120: SELECT ece_output_runs_s.NEXTVAL
121: INTO v_RunID
122: FROM sys.dual;
123: EXCEPTION
124: WHEN NO_DATA_FOUND THEN

Line 131: 'ECE_OUTPUT_RUNS_S' );

127: 'ECE_GET_NEXT_SEQ_FAILED',
128: 'PROGRESS_LEVEL',
129: xProgress,
130: 'SEQ',
131: 'ECE_OUTPUT_RUNS_S' );
132: END;
133: ec_debug.pl(3, 'v_RunID: ',v_RunID);
134:
135: xProgress := 'GPOAO-10-1015';

Line 189: FROM ece_output

185: xProgress := 'GPOAO-10-1050';
186: BEGIN
187: SELECT COUNT(*)
188: INTO v_OutputRecordCount
189: FROM ece_output
190: WHERE run_id = v_RunID;
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN
193: ec_debug.pl ( 0,

Line 199: 'ECE_OUTPUT' );

195: 'ECE_GET_COUNT_FAILED',
196: 'PROGRESS_LEVEL',
197: xProgress,
198: 'TABLE_NAME',
199: 'ECE_OUTPUT' );
200: END;
201: ec_debug.pl ( 3, 'v_OutputRecordCount: ',v_OutputRecordCount );
202:
203: xProgress := 'GPOAO-10-1060';

Line 234: DELETE FROM ece_output

230: xProgress := 'GPOAO-10-1170';
231: ec_debug.pl ( 0, 'EC', 'GML_GPOAO_COMPLETE' ,NULL );
232:
233: xProgress := 'GPOAO-10-1180';
234: DELETE FROM ece_output
235: WHERE run_id = v_RunID;
236:
237: IF SQL%NOTFOUND
238: THEN

Line 245: 'ECE_OUTPUT' );

241: 'ECE_NO_ROW_DELETED',
242: 'PROGRESS_LEVEL',
243: xProgress,
244: 'TABLE_NAME',
245: 'ECE_OUTPUT' );
246: END IF;
247:
248: ec_debug.pop ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
249: ec_debug.disable_debug;

Line 2662: dbms_output.put_line('Writing to ece_output');

2658: /* */
2659: /* Write the record to the output table. */
2660: /* */
2661: /*
2662: dbms_output.put_line('Writing to ece_output');
2663: dbms_output.put_line('Transaction Type: ' || p_TransactionType);
2664: dbms_output.put_line('Comm Method: ' || p_CommunicationMethod);
2665: dbms_output.put_line('Int: ' || p_ORD_Interface);
2666: dbms_output.put_line('Width: ' || p_OutputWidth);

Line 2671: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

2667: dbms_output.put_line('RnID: ' || p_RunID);
2668: dbms_output.put_line('CommonKey: ' || v_FileCommonKey || '<-' );
2669: */
2670: xProgress := 'GPOAOB-40-2310';
2671: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
2672: p_CommunicationMethod,
2673: p_ORD_Interface,
2674: v_ORD_Table,
2675: p_OutputWidth,

Line 2793: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

2789: /* Write the record to the output table. */
2790: /* */
2791:
2792: xProgress := 'GPOAOB-40-2390';
2793: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
2794: p_CommunicationMethod,
2795: p_OAC_Interface,
2796: v_OAC_Table,
2797: p_OutputWidth,

Line 2897: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

2893: /* Write the record to the output table. */
2894: /* */
2895:
2896: xProgress := 'GPOAOB-40-2490';
2897: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
2898: p_CommunicationMethod,
2899: p_OTX_Interface,
2900: v_OTX_Table,
2901: p_OutputWidth,

Line 3006: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3002: /* Write the record to the output table. */
3003: /* */
3004:
3005: xProgress := 'GPOAOB-40-2600';
3006: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3007: p_CommunicationMethod,
3008: p_DTL_Interface,
3009: v_DTL_Table,
3010: p_OutputWidth,

Line 3106: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3102: /* */
3103: /* Write the record to the output table. */
3104: /* */
3105: xProgress := 'GPOAOB-40-2770';
3106: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3107: p_CommunicationMethod,
3108: p_DAC_Interface,
3109: v_DAC_Table,
3110: p_OutputWidth,

Line 3193: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3189: /* */
3190: /* Write the record to the output table. */
3191: /* */
3192: xProgress := 'GPOAOB-40-2770';
3193: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3194: p_CommunicationMethod,
3195: p_DTX_Interface,
3196: v_DTX_Table,
3197: p_OutputWidth,

Line 3280: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,

3276: /* */
3277: /* Write the record to the output table. */
3278: /* */
3279: xProgress := 'GPOAOB-40-2770';
3280: ece_flatfile_pvt.write_to_ece_output ( p_TransactionType,
3281: p_CommunicationMethod,
3282: p_ALL_Interface,
3283: v_ALL_Table,
3284: p_OutputWidth,