DBA Data[Home] [Help]

APPS.IBE_DSP_SECTION_ITEM_PVT dependencies on FND_API

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

28:
29: PROCEDURE update_row
30: (
31: p_section_item_id IN NUMBER,
32: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
33: p_start_date_active IN DATE,
34: p_end_date_active IN DATE,
35: p_usage_name IN VARCHAR2,
36: p_sort_order IN NUMBER,

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

47:
48: PROCEDURE Create_Section_Item
49: (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: p_section_id IN NUMBER,
55: p_inventory_item_id IN NUMBER,

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

48: PROCEDURE Create_Section_Item
49: (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: p_section_id IN NUMBER,
55: p_inventory_item_id IN NUMBER,
56: p_organization_id IN NUMBER,

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

49: (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: p_section_id IN NUMBER,
55: p_inventory_item_id IN NUMBER,
56: p_organization_id IN NUMBER,
57: p_start_date_active IN DATE,

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

54: p_section_id IN NUMBER,
55: p_inventory_item_id IN NUMBER,
56: p_organization_id IN NUMBER,
57: p_start_date_active IN DATE,
58: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
59: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
60: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: x_section_item_id OUT NOCOPY NUMBER,
62: x_return_status OUT NOCOPY VARCHAR2,

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

55: p_inventory_item_id IN NUMBER,
56: p_organization_id IN NUMBER,
57: p_start_date_active IN DATE,
58: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
59: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
60: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: x_section_item_id OUT NOCOPY NUMBER,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,

Line 60: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

56: p_organization_id IN NUMBER,
57: p_start_date_active IN DATE,
58: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
59: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
60: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: x_section_item_id OUT NOCOPY NUMBER,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2

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

66:
67: PROCEDURE Update_Section_Item
68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
74: p_object_version_number IN NUMBER,

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

67: PROCEDURE Update_Section_Item
68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
74: p_object_version_number IN NUMBER,
75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
74: p_object_version_number IN NUMBER,
75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
74: p_object_version_number IN NUMBER,
75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
77: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,

Line 75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
74: p_object_version_number IN NUMBER,
75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
77: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
74: p_object_version_number IN NUMBER,
75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
77: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
80: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

73: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
74: p_object_version_number IN NUMBER,
75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
77: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
80: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

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

74: p_object_version_number IN NUMBER,
75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
77: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
80: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
82: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

75: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
77: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
80: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
82: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: x_return_status OUT NOCOPY VARCHAR2,

Line 80: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

76: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
77: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
80: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
82: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,

Line 81: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

77: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
78: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
80: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
82: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2

Line 82: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

78: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
80: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
82: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2
86: );

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

87:
88: PROCEDURE Delete_Section_Item
89: (
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_call_from_trigger IN BOOLEAN := FALSE,
95: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

88: PROCEDURE Delete_Section_Item
89: (
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_call_from_trigger IN BOOLEAN := FALSE,
95: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

89: (
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_call_from_trigger IN BOOLEAN := FALSE,
95: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_call_from_trigger IN BOOLEAN := FALSE,
95: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
99: x_return_status OUT NOCOPY VARCHAR2,

Line 96: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_call_from_trigger IN BOOLEAN := FALSE,
95: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,

Line 97: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_call_from_trigger IN BOOLEAN := FALSE,
95: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2

Line 98: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,

94: p_call_from_trigger IN BOOLEAN := FALSE,
95: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2
102: );

Line 106: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

102: );
103:
104: PROCEDURE Delete_Section_Items_For_Item
105: (
106: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_organization_id IN NUMBER := FND_API.G_MISS_NUM
108: );
109:
110: PROCEDURE Update_Delete_Sct_Itms

Line 107: p_organization_id IN NUMBER := FND_API.G_MISS_NUM

103:
104: PROCEDURE Delete_Section_Items_For_Item
105: (
106: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_organization_id IN NUMBER := FND_API.G_MISS_NUM
108: );
109:
110: PROCEDURE Update_Delete_Sct_Itms
111: (

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

109:
110: PROCEDURE Update_Delete_Sct_Itms
111: (
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_section_item_ids IN JTF_NUMBER_TABLE,
117: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

110: PROCEDURE Update_Delete_Sct_Itms
111: (
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_section_item_ids IN JTF_NUMBER_TABLE,
117: p_object_version_numbers IN JTF_NUMBER_TABLE,
118: p_start_date_actives IN JTF_DATE_TABLE,

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

111: (
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_section_item_ids IN JTF_NUMBER_TABLE,
117: p_object_version_numbers IN JTF_NUMBER_TABLE,
118: p_start_date_actives IN JTF_DATE_TABLE,
119: p_end_date_actives IN JTF_DATE_TABLE,