DBA Data[Home] [Help]

APPS.JTF_DSP_MSITE_SCT_ITEM_PVT dependencies on FND_API

Line 24: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

20:
21: PROCEDURE update_row
22: (
23: p_mini_site_section_item_id IN NUMBER,
24: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
25: p_start_date_active IN DATE,
26: p_end_date_active IN DATE,
27: p_last_update_date IN DATE,
28: p_last_updated_by IN NUMBER,

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

36:
37: PROCEDURE Create_MSite_Section_Item
38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_mini_site_id IN NUMBER,
44: p_section_item_id IN NUMBER,

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

37: PROCEDURE Create_MSite_Section_Item
38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_mini_site_id IN NUMBER,
44: p_section_item_id IN NUMBER,
45: p_start_date_active IN DATE,

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

38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_mini_site_id IN NUMBER,
44: p_section_item_id IN NUMBER,
45: p_start_date_active IN DATE,
46: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 46: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_mini_site_id IN NUMBER,
44: p_section_item_id IN NUMBER,
45: p_start_date_active IN DATE,
46: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
47: x_mini_site_section_item_id OUT NUMBER,
48: x_return_status OUT VARCHAR2,
49: x_msg_count OUT NUMBER,
50: x_msg_data OUT VARCHAR2

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

52:
53: PROCEDURE Update_MSite_Section_Item
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_object_version_number IN NUMBER,

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

53: PROCEDURE Update_MSite_Section_Item
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_object_version_number IN NUMBER,
61: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_object_version_number IN NUMBER,
61: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
62: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

Line 59: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_object_version_number IN NUMBER,
61: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
62: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

Line 61: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_object_version_number IN NUMBER,
61: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
62: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
64: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
65: x_return_status OUT VARCHAR2,

Line 62: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_object_version_number IN NUMBER,
61: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
62: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
64: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
65: x_return_status OUT VARCHAR2,
66: x_msg_count OUT NUMBER,

Line 63: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

59: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_object_version_number IN NUMBER,
61: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
62: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
64: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
65: x_return_status OUT VARCHAR2,
66: x_msg_count OUT NUMBER,
67: x_msg_data OUT VARCHAR2

Line 64: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

60: p_object_version_number IN NUMBER,
61: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
62: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
64: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
65: x_return_status OUT VARCHAR2,
66: x_msg_count OUT NUMBER,
67: x_msg_data OUT VARCHAR2
68: );

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

69:
70: PROCEDURE Delete_MSite_Section_Item
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_call_from_trigger IN BOOLEAN := FALSE,
77: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

70: PROCEDURE Delete_MSite_Section_Item
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_call_from_trigger IN BOOLEAN := FALSE,
77: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_call_from_trigger IN BOOLEAN := FALSE,
77: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

Line 77: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_call_from_trigger IN BOOLEAN := FALSE,
77: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
80: x_return_status OUT VARCHAR2,
81: x_msg_count OUT NUMBER,

Line 78: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_call_from_trigger IN BOOLEAN := FALSE,
77: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
80: x_return_status OUT VARCHAR2,
81: x_msg_count OUT NUMBER,
82: x_msg_data OUT VARCHAR2

Line 79: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_call_from_trigger IN BOOLEAN := FALSE,
77: p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
80: x_return_status OUT VARCHAR2,
81: x_msg_count OUT NUMBER,
82: x_msg_data OUT VARCHAR2
83: );