6: * (customer/global/item-lot hierarchy)
7: * Pre-reqs: Package assumes validation is done in calling program/form
8: * Parameters for main procedure (populate_coa_data):
9: * IN: p_api_version IN NUMBER
10: * p_init_msg_list IN VARCHAR2 optional default = FND_API.G_FALSE
11: * p_commit IN VARCHAR2 optional default = FND_API.G_FALSE
12: * p_validation_level IN NUMBER optional
13: * default = FND_API.G_VALID_LEVEL_FULL
14: * rec_param IN t_coa_parameters record of parameters
7: * Pre-reqs: Package assumes validation is done in calling program/form
8: * Parameters for main procedure (populate_coa_data):
9: * IN: p_api_version IN NUMBER
10: * p_init_msg_list IN VARCHAR2 optional default = FND_API.G_FALSE
11: * p_commit IN VARCHAR2 optional default = FND_API.G_FALSE
12: * p_validation_level IN NUMBER optional
13: * default = FND_API.G_VALID_LEVEL_FULL
14: * rec_param IN t_coa_parameters record of parameters
15: * OUT: x_return_status OUT VARCHAR2(1)
9: * IN: p_api_version IN NUMBER
10: * p_init_msg_list IN VARCHAR2 optional default = FND_API.G_FALSE
11: * p_commit IN VARCHAR2 optional default = FND_API.G_FALSE
12: * p_validation_level IN NUMBER optional
13: * default = FND_API.G_VALID_LEVEL_FULL
14: * rec_param IN t_coa_parameters record of parameters
15: * OUT: x_return_status OUT VARCHAR2(1)
16: * x_msg_count OUT NUMBER
17: * x_msg_data OUT VARCHAR2(2000)
114: empty_text t_coa_text_tbl;
115:
116: PROCEDURE Populate_CoA_Data (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: rec_param IN t_coa_parameters,
122: x_return_status OUT NOCOPY VARCHAR2,
115:
116: PROCEDURE Populate_CoA_Data (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: rec_param IN t_coa_parameters,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
116: PROCEDURE Populate_CoA_Data (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: rec_param IN t_coa_parameters,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
128: tbl_rslt_text OUT NOCOPY t_coa_text_tbl);
129:
130: PROCEDURE Dump_To_Db_Tables (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: tbl_hdr IN t_coa_header_tbl,
136: tbl_dtl IN t_coa_detail_tbl,
129:
130: PROCEDURE Dump_To_Db_Tables (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: tbl_hdr IN t_coa_header_tbl,
136: tbl_dtl IN t_coa_detail_tbl,
137: tbl_spec_text IN t_coa_text_tbl,
130: PROCEDURE Dump_To_Db_Tables (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: tbl_hdr IN t_coa_header_tbl,
136: tbl_dtl IN t_coa_detail_tbl,
137: tbl_spec_text IN t_coa_text_tbl,
138: tbl_rslt_text IN t_coa_text_tbl,