DBA Data[Home] [Help]

APPS.PSB_EXCEL_PVT dependencies on FND_API

Line 24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 25: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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: --

Line 33: p_stage_id IN NUMBER := FND_API.G_MISS_NUM,

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: /* ----------------------------------------------------------------------- */

Line 34: p_export_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 60: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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: --

Line 67: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 68: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: );

Line 69: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,

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:

Line 70: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: /* ----------------------------------------------------------------------- */

Line 71: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM

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:

Line 213: p_stage_id IN NUMBER := FND_API.G_MISS_NUM ,

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: /* ----------------------------------------------------------------------- */

Line 255: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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: );

Line 256: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM ,

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:

Line 257: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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: /* ----------------------------------------------------------------------- */

Line 258: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM

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:

Line 281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 282: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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: --