DBA Data[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on ECE_FLATFILE_PVT

Line 30: l_project_tbl ece_flatfile_pvt.Interface_tbl_type;

26:
27: project_sel_c INTEGER:=0;
28: project_del_c1 INTEGER;
29: project_del_c2 INTEGER;
30: l_project_tbl ece_flatfile_pvt.Interface_tbl_type;
31: uFile_type utl_file.file_type;
32: /* BUG:5367903 */
33: C_ANY_VALUE VARCHAR2(120):= '_ANY_VALUE_';
34: PROCEDURE extract_poo_outbound(

Line 87: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

83: cCommunication_Method IN VARCHAR2,
84: cTransaction_Type IN VARCHAR2,
85: iRun_id IN INTEGER,
86: cDistribution_Interface IN VARCHAR2,
87: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
88: cPO_Header_ID IN NUMBER,
89: cPO_Release_ID IN NUMBER,
90: cPO_Line_ID IN NUMBER,
91: cPO_Line_Location_ID IN NUMBER,

Line 122: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

118: cPK3_Value IN VARCHAR2,
119: cPK4_Value IN VARCHAR2,
120: cPK5_Value IN VARCHAR2,
121: cSegment_Size IN NUMBER,
122: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
123: cFile_Common_Key IN VARCHAR2,
124: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
125: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
126: l_key_count IN OUT NOCOPY NUMBER); -- bug 2823215

Line 124: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

120: cPK5_Value IN VARCHAR2,
121: cSegment_Size IN NUMBER,
122: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
123: cFile_Common_Key IN VARCHAR2,
124: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
125: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
126: l_key_count IN OUT NOCOPY NUMBER); -- bug 2823215
127:
128: PROCEDURE populate_text_att_detail(

Line 125: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

121: cSegment_Size IN NUMBER,
122: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
123: cFile_Common_Key IN VARCHAR2,
124: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
125: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
126: l_key_count IN OUT NOCOPY NUMBER); -- bug 2823215
127:
128: PROCEDURE populate_text_att_detail(
129: cCommunication_Method IN VARCHAR2,

Line 144: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

140: cPK4_Value IN VARCHAR2,
141: cPK5_Value IN VARCHAR2,
142: cData_Type_ID IN NUMBER,
143: cSegment_Size IN NUMBER,
144: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
145: cAtt_doc_id IN NUMBER, -- bug 2187958
146: cFile_Common_Key IN VARCHAR2,
147: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type); -- bug 2823215
148:

Line 147: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type); -- bug 2823215

143: cSegment_Size IN NUMBER,
144: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
145: cAtt_doc_id IN NUMBER, -- bug 2187958
146: cFile_Common_Key IN VARCHAR2,
147: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type); -- bug 2823215
148:
149: PROCEDURE put_att_to_output_table(
150: cCommunication_Method IN VARCHAR2,
151: cTransaction_Type IN VARCHAR2,

Line 190: p_Interface_tbl IN ece_flatfile_pvt.Interface_tbl_type,

186: PROCEDURE write_to_file(
187: cTransaction_Type IN VARCHAR2,
188: cCommunication_Method IN VARCHAR2,
189: cInterface_Table IN VARCHAR2,
190: p_Interface_tbl IN ece_flatfile_pvt.Interface_tbl_type,
191: iOutput_width IN INTEGER,
192: iRun_id IN INTEGER,
193: p_common_key IN VARCHAR2,
194: p_foreign_key IN NUMBER);