APPS.GML_GASNO dependencies on ECE_OUTPUT

Line 70: FROM ece_output

66: xProgress VARCHAR2(80);
67:
68: CURSOR c_OutputSource IS
69: SELECT text
70: FROM ece_output
71: WHERE run_id = p_RunID
72: ORDER BY line_id;
73:
74: BEGIN

Line 90: SELECT ece_output_runs_s.NEXTVAL

86: ec_debug.pl ( 3, 'p_debug_mode: ', p_debug_mode );
87:
88: xProgress := 'GASNO-10-1005';
89: BEGIN
90: SELECT ece_output_runs_s.NEXTVAL
91: INTO p_RunID
92: FROM sys.dual;
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN

Line 101: 'ECE_OUTPUT_RUNS_S' );

97: 'GML_GET_NEXT_SEQ_FAILED',
98: 'PROGRESS_LEVEL',
99: xProgress,
100: 'SEQ',
101: 'ECE_OUTPUT_RUNS_S' );
102: END;
103: ec_debug.pl(3, 'p_RunID: ',p_RunID);
104:
105: xProgress := 'GASNO-10-1015';

Line 156: FROM ece_output

152: xProgress := 'GASNO-10-1050';
153: BEGIN
154: SELECT COUNT(*)
155: INTO v_OutputRecordCount
156: FROM ece_output
157: WHERE run_id = p_RunID;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: ec_debug.pl ( 0,

Line 166: 'ECE_OUTPUT' );

162: 'ECE_GET_COUNT_FAILED',
163: 'PROGRESS_LEVEL',
164: xProgress,
165: 'TABLE_NAME',
166: 'ECE_OUTPUT' );
167: END;
168: ec_debug.pl ( 3, 'v_OutputRecordCount: ', v_OutputRecordCount );
169:
170: xProgress := 'GASNO-10-1060';

Line 207: DELETE FROM ece_output

203: xProgress := 'GASNO-10-1170';
204: ec_debug.pl ( 0, 'EC', 'GML_GASNO_COMPLETE', NULL );
205:
206: xProgress := 'GASNO-10-1180';
207: DELETE FROM ece_output
208: WHERE run_id = p_RunID;
209:
210: IF SQL%NOTFOUND
211: THEN

Line 218: 'ECE_OUTPUT' );

214: 'ECE_NO_ROW_DELETED',
215: 'PROGRESS_LEVEL',
216: xProgress,
217: 'TABLE_NAME',
218: 'ECE_OUTPUT' );
219: END IF;
220:
221: ec_debug.pop ( 'GML_GASNO.Extract_GASNO_Outbound' );
222: ec_debug.disable_debug;

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 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 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 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 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 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 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,