APPS.ECE_EXTRACT_UTILS_PUB dependencies on ECE_FLATFILE_PVT

Line 36: p_source_tbl IN ece_flatfile_pvt.interface_tbl_type,

32: PROCEDURE select_clause(
33: cTransaction_Type IN VARCHAR2,
34: cCommunication_Method IN VARCHAR2,
35: cInterface_Table IN VARCHAR2,
36: p_source_tbl IN ece_flatfile_pvt.interface_tbl_type,
37: cSelect_string OUT NOCOPY VARCHAR2,
38: cFrom_string OUT NOCOPY VARCHAR2,
39: cWhere_string OUT NOCOPY VARCHAR2);
40:

Line 46: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,

42: iRun_id IN NUMBER,
43: cTransaction_Type IN VARCHAR2,
44: cCommunication_Method IN VARCHAR2,
45: cInterface_Table IN VARCHAR2,
46: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,
47: p_foreign_key IN NUMBER);
48:
49: PROCEDURE insert_into_prod_interface(
50: p_Interface_Table IN VARCHAR2,

Line 52: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type);

48:
49: PROCEDURE insert_into_prod_interface(
50: p_Interface_Table IN VARCHAR2,
51: p_Insert_cur IN OUT NOCOPY INTEGER,
52: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type);
53:
54: /*Bug 1854866
55: Assigned default values to the parameters
56: p_init_msg_list,p_simulate,p_commit,p_validation_level

Line 73: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type);

69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2,
71: p_interface_table IN VARCHAR2,
72: p_insert_cur IN OUT NOCOPY INTEGER,
73: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type);
74:
75: PROCEDURE find_pos(
76: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,
77: p_in_text IN VARCHAR2,

Line 76: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,

72: p_insert_cur IN OUT NOCOPY INTEGER,
73: p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type);
74:
75: PROCEDURE find_pos(
76: p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,
77: p_in_text IN VARCHAR2,
78: p_Pos IN OUT NOCOPY NUMBER);
79:
80: FUNCTION pos_of(

Line 81: pInterface_tbl IN ece_flatfile_pvt.Interface_tbl_type,

77: p_in_text IN VARCHAR2,
78: p_Pos IN OUT NOCOPY NUMBER);
79:
80: FUNCTION pos_of(
81: pInterface_tbl IN ece_flatfile_pvt.Interface_tbl_type,
82: cCol_name IN VARCHAR2)
83: RETURN NUMBER;
84:
85: -- 2823215

Line 87: l_plsql_tbl IN ece_flatfile_pvt.Interface_tbl_type,

83: RETURN NUMBER;
84:
85: -- 2823215
86: PROCEDURE ext_get_value(
87: l_plsql_tbl IN ece_flatfile_pvt.Interface_tbl_type,
88: p_in_text IN VARCHAR2,
89: p_Position IN OUT NOCOPY NUMBER,
90: o_value OUT NOCOPY varchar2);
91:

Line 93: l_plsql_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

89: p_Position IN OUT NOCOPY NUMBER,
90: o_value OUT NOCOPY varchar2);
91:
92: PROCEDURE ext_insert_value(
93: l_plsql_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
94: p_position IN number,
95: p_value IN varchar2);
96:
97: END ece_extract_utils_pub;