20:
21: PROCEDURE Move_To_Interface
22: (
23: p_api_version IN NUMBER ,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
27: p_return_status OUT NOCOPY VARCHAR2 ,
28: p_msg_count OUT NOCOPY NUMBER ,
21: PROCEDURE Move_To_Interface
22: (
23: p_api_version IN NUMBER ,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
27: p_return_status OUT NOCOPY VARCHAR2 ,
28: p_msg_count OUT NOCOPY NUMBER ,
29: p_msg_data OUT NOCOPY VARCHAR2 ,
22: (
23: p_api_version IN NUMBER ,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
27: p_return_status OUT NOCOPY VARCHAR2 ,
28: p_msg_count OUT NOCOPY NUMBER ,
29: p_msg_data OUT NOCOPY VARCHAR2 ,
30: --
29: p_msg_data OUT NOCOPY VARCHAR2 ,
30: --
31: p_export_name IN VARCHAR2,
32: p_worksheet_id IN NUMBER,
33: p_stage_id IN NUMBER := FND_API.G_MISS_NUM,
34: p_export_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR
35: );
36:
37: /* ----------------------------------------------------------------------- */
30: --
31: p_export_name IN VARCHAR2,
32: p_worksheet_id IN NUMBER,
33: p_stage_id IN NUMBER := FND_API.G_MISS_NUM,
34: p_export_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR
35: );
36:
37: /* ----------------------------------------------------------------------- */
38: -- API name : Move_To_PSB
55:
56: PROCEDURE Move_To_PSB
57: (
58: p_api_version IN NUMBER ,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
62: p_return_status OUT NOCOPY VARCHAR2 ,
63: p_msg_count OUT NOCOPY NUMBER ,
56: PROCEDURE Move_To_PSB
57: (
58: p_api_version IN NUMBER ,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
62: p_return_status OUT NOCOPY VARCHAR2 ,
63: p_msg_count OUT NOCOPY NUMBER ,
64: p_msg_data OUT NOCOPY VARCHAR2 ,
57: (
58: p_api_version IN NUMBER ,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
62: p_return_status OUT NOCOPY VARCHAR2 ,
63: p_msg_count OUT NOCOPY NUMBER ,
64: p_msg_data OUT NOCOPY VARCHAR2 ,
65: --
63: p_msg_count OUT NOCOPY NUMBER ,
64: p_msg_data OUT NOCOPY VARCHAR2 ,
65: --
66: p_export_id IN NUMBER,
67: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
70: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
64: p_msg_data OUT NOCOPY VARCHAR2 ,
65: --
66: p_export_id IN NUMBER,
67: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
70: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
72: );
65: --
66: p_export_id IN NUMBER,
67: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
70: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
72: );
73:
66: p_export_id IN NUMBER,
67: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
70: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
72: );
73:
74: /* ----------------------------------------------------------------------- */
67: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
70: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
72: );
73:
74: /* ----------------------------------------------------------------------- */
75:
209: retcode OUT NOCOPY VARCHAR2 ,
210: --
211: p_export_name IN VARCHAR2 ,
212: p_worksheet_id IN NUMBER ,
213: p_stage_id IN NUMBER := FND_API.G_MISS_NUM ,
214: p_export_worksheet_type IN VARCHAR2
215: );
216:
217: /* ----------------------------------------------------------------------- */
251: retcode OUT NOCOPY VARCHAR2 ,
252: --
253: p_export_id IN NUMBER ,
254: p_import_worksheet_type IN VARCHAR2 ,
255: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM ,
257: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
258: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
259: );
252: --
253: p_export_id IN NUMBER ,
254: p_import_worksheet_type IN VARCHAR2 ,
255: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM ,
257: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
258: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
259: );
260:
253: p_export_id IN NUMBER ,
254: p_import_worksheet_type IN VARCHAR2 ,
255: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM ,
257: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
258: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
259: );
260:
261: /* ----------------------------------------------------------------------- */
254: p_import_worksheet_type IN VARCHAR2 ,
255: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
256: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM ,
257: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
258: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
259: );
260:
261: /* ----------------------------------------------------------------------- */
262:
277:
278: PROCEDURE Del_Worksheet
279: (
280: p_api_version IN NUMBER ,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
284: p_return_status OUT NOCOPY VARCHAR2 ,
285: p_msg_count OUT NOCOPY NUMBER ,
278: PROCEDURE Del_Worksheet
279: (
280: p_api_version IN NUMBER ,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
284: p_return_status OUT NOCOPY VARCHAR2 ,
285: p_msg_count OUT NOCOPY NUMBER ,
286: p_msg_data OUT NOCOPY VARCHAR2 ,
279: (
280: p_api_version IN NUMBER ,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
284: p_return_status OUT NOCOPY VARCHAR2 ,
285: p_msg_count OUT NOCOPY NUMBER ,
286: p_msg_data OUT NOCOPY VARCHAR2 ,
287: --