APPS.ECE_EXTRACT_UTILS_PUB dependencies on ECE_FLATFILE_PVT

Line 25: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,

21: PROCEDURE select_clause(
22: cTransaction_Type IN VARCHAR2,
23: cCommunication_Method IN VARCHAR2,
24: cInterface_Table IN VARCHAR2,
25: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,
26: cSelect_string OUT NOCOPY VARCHAR2,
27: cFrom_string OUT NOCOPY VARCHAR2,
28: cWhere_string OUT NOCOPY VARCHAR2) IS
29: xProgress VARCHAR2(30);

Line 180: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,

176: iRun_id IN NUMBER,
177: cTransaction_Type IN VARCHAR2,
178: cCommunication_Method IN VARCHAR2,
179: cInterface_Table IN VARCHAR2,
180: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,
181: p_foreign_key IN NUMBER
182: )
183: IS
184:

Line 537: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type)

533:
534: PROCEDURE insert_into_prod_interface(
535: p_Interface_Table IN VARCHAR2,
536: p_Insert_cur IN OUT NOCOPY INTEGER,
537: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type)
538:
539: IS
540: xProgress VARCHAR2(30);
541: cOutput_path VARCHAR2(120);

Line 766: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type) IS

762: x_msg_count OUT NOCOPY NUMBER,
763: x_msg_data OUT NOCOPY VARCHAR2,
764: p_interface_table IN VARCHAR2,
765: p_insert_cur IN OUT NOCOPY INTEGER,
766: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type) IS
767:
768: l_api_name CONSTANT VARCHAR2(30) := 'insert_into_prod_interface_pvt';
769: l_api_version_number CONSTANT NUMBER := 1.0;
770: l_return_status VARCHAR2(10);

Line 1069: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,

1065:
1066: END insert_into_prod_interface_pvt;
1067:
1068: PROCEDURE find_pos(
1069: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,
1070: p_in_text IN VARCHAR2,
1071: p_pos IN OUT NOCOPY NUMBER) IS
1072:
1073: cIn_string VARCHAR2(1000) := UPPER(p_in_text);

Line 1114: FUNCTION POS_OF (pInterface_tbl IN ece_flatfile_pvt.Interface_tbl_type,

1110: app_exception.raise_exception;
1111:
1112: END find_pos;
1113:
1114: FUNCTION POS_OF (pInterface_tbl IN ece_flatfile_pvt.Interface_tbl_type,
1115: cCol_name IN VARCHAR2)
1116: RETURN NUMBER
1117: IS
1118: l_Row_count NUMBER := pInterface_tbl.count;

Line 1158: l_plsql_tbl IN ece_flatfile_pvt.Interface_tbl_type,

1154: END pos_of;
1155:
1156: -- 2823215
1157: PROCEDURE ext_get_value(
1158: l_plsql_tbl IN ece_flatfile_pvt.Interface_tbl_type,
1159: p_in_text IN VARCHAR2,
1160: p_Position IN OUT NOCOPY NUMBER,
1161: o_value OUT NOCOPY varchar2)
1162: IS

Line 1206: l_plsql_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

1202: app_exception.raise_exception;
1203: END ext_get_value;
1204:
1205: PROCEDURE ext_insert_value(
1206: l_plsql_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
1207: p_position IN number,
1208: p_value IN varchar2)
1209: IS
1210: BEGIN