DBA Data[Home] [Help]

APPS.JTF_DSP_SECTION_ITEM_PVT dependencies on FND_API

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

23:
24: PROCEDURE update_row
25: (
26: p_section_item_id IN NUMBER,
27: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
28: p_start_date_active IN DATE,
29: p_end_date_active IN DATE,
30: p_sort_order IN NUMBER,
31: p_association_reason_code IN VARCHAR2,

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

41:
42: PROCEDURE Create_Section_Item
43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_section_id IN NUMBER,
49: p_inventory_item_id IN NUMBER,

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

42: PROCEDURE Create_Section_Item
43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_section_id IN NUMBER,
49: p_inventory_item_id IN NUMBER,
50: p_organization_id IN NUMBER,

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

43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_section_id IN NUMBER,
49: p_inventory_item_id IN NUMBER,
50: p_organization_id IN NUMBER,
51: p_start_date_active IN DATE,

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

48: p_section_id IN NUMBER,
49: p_inventory_item_id IN NUMBER,
50: p_organization_id IN NUMBER,
51: p_start_date_active IN DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
54: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: x_section_item_id OUT NUMBER,
56: x_return_status OUT VARCHAR2,

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

49: p_inventory_item_id IN NUMBER,
50: p_organization_id IN NUMBER,
51: p_start_date_active IN DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
54: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: x_section_item_id OUT NUMBER,
56: x_return_status OUT VARCHAR2,
57: x_msg_count OUT NUMBER,

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

50: p_organization_id IN NUMBER,
51: p_start_date_active IN DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
54: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: x_section_item_id OUT NUMBER,
56: x_return_status OUT VARCHAR2,
57: x_msg_count OUT NUMBER,
58: x_msg_data OUT VARCHAR2

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

60:
61: PROCEDURE Update_Section_Item
62: (
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_object_version_number IN NUMBER,

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

61: PROCEDURE Update_Section_Item
62: (
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_object_version_number IN NUMBER,
69: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

62: (
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_object_version_number IN NUMBER,
69: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_object_version_number IN NUMBER,
69: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,

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

65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_object_version_number IN NUMBER,
69: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_object_version_number IN NUMBER,
69: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

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

67: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_object_version_number IN NUMBER,
69: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

68: p_object_version_number IN NUMBER,
69: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_return_status OUT VARCHAR2,

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

69: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_return_status OUT VARCHAR2,
77: x_msg_count OUT NUMBER,

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

70: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_return_status OUT VARCHAR2,
77: x_msg_count OUT NUMBER,
78: x_msg_data OUT VARCHAR2

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

71: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_return_status OUT VARCHAR2,
77: x_msg_count OUT NUMBER,
78: x_msg_data OUT VARCHAR2
79: );

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

80:
81: PROCEDURE Delete_Section_Item
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_call_from_trigger IN BOOLEAN := FALSE,
88: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

81: PROCEDURE Delete_Section_Item
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_call_from_trigger IN BOOLEAN := FALSE,
88: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_call_from_trigger IN BOOLEAN := FALSE,
88: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_call_from_trigger IN BOOLEAN := FALSE,
88: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
92: x_return_status OUT VARCHAR2,

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

85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_call_from_trigger IN BOOLEAN := FALSE,
88: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
92: x_return_status OUT VARCHAR2,
93: x_msg_count OUT NUMBER,

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

86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_call_from_trigger IN BOOLEAN := FALSE,
88: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
92: x_return_status OUT VARCHAR2,
93: x_msg_count OUT NUMBER,
94: x_msg_data OUT VARCHAR2

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

87: p_call_from_trigger IN BOOLEAN := FALSE,
88: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
92: x_return_status OUT VARCHAR2,
93: x_msg_count OUT NUMBER,
94: x_msg_data OUT VARCHAR2
95: );

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

95: );
96:
97: PROCEDURE Delete_Section_Items_For_Item
98: (
99: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_organization_id IN NUMBER := FND_API.G_MISS_NUM
101: );
102:
103: PROCEDURE Update_Delete_Sct_Itms

Line 100: p_organization_id IN NUMBER := FND_API.G_MISS_NUM

96:
97: PROCEDURE Delete_Section_Items_For_Item
98: (
99: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_organization_id IN NUMBER := FND_API.G_MISS_NUM
101: );
102:
103: PROCEDURE Update_Delete_Sct_Itms
104: (

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

102:
103: PROCEDURE Update_Delete_Sct_Itms
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_section_item_ids IN JTF_NUMBER_TABLE,
110: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

103: PROCEDURE Update_Delete_Sct_Itms
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_section_item_ids IN JTF_NUMBER_TABLE,
110: p_object_version_numbers IN JTF_NUMBER_TABLE,
111: p_start_date_actives IN JTF_DATE_TABLE,

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

104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_section_item_ids IN JTF_NUMBER_TABLE,
110: p_object_version_numbers IN JTF_NUMBER_TABLE,
111: p_start_date_actives IN JTF_DATE_TABLE,
112: p_end_date_actives IN JTF_DATE_TABLE,