23:
24: PROCEDURE Cascade_To_Child_Entities
25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
29: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
30: x_return_status OUT VARCHAR2,
31: x_msg_count OUT NUMBER,
24: PROCEDURE Cascade_To_Child_Entities
25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
29: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
30: x_return_status OUT VARCHAR2,
31: x_msg_count OUT NUMBER,
32: x_msg_data OUT VARCHAR2,
25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
29: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
30: x_return_status OUT VARCHAR2,
31: x_msg_count OUT NUMBER,
32: x_msg_data OUT VARCHAR2,
33: p_cp_id IN NUMBER,
37:
38: PROCEDURE Create_Base_Product
39: (
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT VARCHAR2,
45: x_msg_count OUT NUMBER,
38: PROCEDURE Create_Base_Product
39: (
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT VARCHAR2,
45: x_msg_count OUT NUMBER,
46: x_msg_data OUT VARCHAR2,
39: (
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT VARCHAR2,
45: x_msg_count OUT NUMBER,
46: x_msg_data OUT VARCHAR2,
47: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
45: x_msg_count OUT NUMBER,
46: x_msg_data OUT VARCHAR2,
47: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
48: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
49: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
50: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
51: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
46: x_msg_data OUT VARCHAR2,
47: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
48: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
49: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
50: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
51: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: x_cp_id OUT NUMBER,
47: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
48: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
49: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
50: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
51: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: x_cp_id OUT NUMBER,
55: x_object_version_number OUT NUMBER
48: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
49: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
50: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
51: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: x_cp_id OUT NUMBER,
55: x_object_version_number OUT NUMBER
56: );
49: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
50: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
51: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54: x_cp_id OUT NUMBER,
55: x_object_version_number OUT NUMBER
56: );
57:
58:
59: PROCEDURE Create_Revision
60: (
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT VARCHAR2,
66: x_msg_count OUT NUMBER,
59: PROCEDURE Create_Revision
60: (
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT VARCHAR2,
66: x_msg_count OUT NUMBER,
67: x_msg_data OUT VARCHAR2,
60: (
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT VARCHAR2,
66: x_msg_count OUT NUMBER,
67: x_msg_data OUT VARCHAR2,
68: p_cp_id IN NUMBER,
70: p_order_info IN CS_InstalledBase_PUB.OrderInfo_Rec_Type,
71: --p_net_amount IN NUMBER,
72: --p_currency_code IN VARCHAR2,
73: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
74: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
75: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
76: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
77: x_cp_rev_id OUT NUMBER,
78: x_curr_rev_of_cp_updtd OUT VARCHAR2,
71: --p_net_amount IN NUMBER,
72: --p_currency_code IN VARCHAR2,
73: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
74: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
75: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
76: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
77: x_cp_rev_id OUT NUMBER,
78: x_curr_rev_of_cp_updtd OUT VARCHAR2,
79: x_object_version_number OUT NUMBER
72: --p_currency_code IN VARCHAR2,
73: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
74: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
75: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
76: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
77: x_cp_rev_id OUT NUMBER,
78: x_curr_rev_of_cp_updtd OUT VARCHAR2,
79: x_object_version_number OUT NUMBER
80: );
82:
83: PROCEDURE Update_Revision
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT VARCHAR2,
90: x_msg_count OUT NUMBER,
83: PROCEDURE Update_Revision
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT VARCHAR2,
90: x_msg_count OUT NUMBER,
91: x_msg_data OUT VARCHAR2,
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT VARCHAR2,
90: x_msg_count OUT NUMBER,
91: x_msg_data OUT VARCHAR2,
92: p_cp_rev_id IN NUMBER,
90: x_msg_count OUT NUMBER,
91: x_msg_data OUT VARCHAR2,
92: p_cp_rev_id IN NUMBER,
93: p_object_version_number IN NUMBER,
94: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
95: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
96: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
97: x_object_version_number OUT NUMBER
98: );
91: x_msg_data OUT VARCHAR2,
92: p_cp_rev_id IN NUMBER,
93: p_object_version_number IN NUMBER,
94: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
95: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
96: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
97: x_object_version_number OUT NUMBER
98: );
99:
99:
100: PROCEDURE Record_Shipment_Info
101: (
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
106: x_return_status OUT VARCHAR2,
107: x_msg_count OUT NUMBER,
100: PROCEDURE Record_Shipment_Info
101: (
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
106: x_return_status OUT VARCHAR2,
107: x_msg_count OUT NUMBER,
108: x_msg_data OUT VARCHAR2,
101: (
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
106: x_return_status OUT VARCHAR2,
107: x_msg_count OUT NUMBER,
108: x_msg_data OUT VARCHAR2,
109: p_ship_rec IN CS_InstalledBase_PUB.CP_Ship_Rec_Type,
106: x_return_status OUT VARCHAR2,
107: x_msg_count OUT NUMBER,
108: x_msg_data OUT VARCHAR2,
109: p_ship_rec IN CS_InstalledBase_PUB.CP_Ship_Rec_Type,
110: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
111: x_new_cp_id OUT NUMBER,
112: p_savepoint_rec_lvl IN NUMBER DEFAULT 1
113: );
114:
117:
118: PROCEDURE Upgrade_Product
119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
124: x_return_status OUT VARCHAR2,
125: x_msg_count OUT NUMBER,
118: PROCEDURE Upgrade_Product
119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
124: x_return_status OUT VARCHAR2,
125: x_msg_count OUT NUMBER,
126: x_msg_data OUT VARCHAR2,
119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
124: x_return_status OUT VARCHAR2,
125: x_msg_count OUT NUMBER,
126: x_msg_data OUT VARCHAR2,
127: p_cp_id IN NUMBER,
126: x_msg_data OUT VARCHAR2,
127: p_cp_id IN NUMBER,
128: p_old_cp_status_id IN NUMBER,
129: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
130: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: x_new_cp_id OUT NUMBER,
133: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
127: p_cp_id IN NUMBER,
128: p_old_cp_status_id IN NUMBER,
129: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
130: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: x_new_cp_id OUT NUMBER,
133: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
135: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
129: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
130: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: x_new_cp_id OUT NUMBER,
133: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
135: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: );
131: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: x_new_cp_id OUT NUMBER,
133: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
135: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: );
138:
139:
132: x_new_cp_id OUT NUMBER,
133: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
135: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: );
138:
139:
140: PROCEDURE Update_Product
139:
140: PROCEDURE Update_Product
141: (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
144: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
145: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
146: x_return_status OUT VARCHAR2,
147: x_msg_count OUT NUMBER,
140: PROCEDURE Update_Product
141: (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
144: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
145: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
146: x_return_status OUT VARCHAR2,
147: x_msg_count OUT NUMBER,
148: x_msg_data OUT VARCHAR2,
141: (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
144: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
145: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
146: x_return_status OUT VARCHAR2,
147: x_msg_count OUT NUMBER,
148: x_msg_data OUT VARCHAR2,
149: p_cp_id IN NUMBER,
152: p_ship_rec IN CS_InstalledBase_PUB.CP_Ship_Rec_Type,
153: p_comments IN VARCHAR2 DEFAULT NULL,
154: p_split_cp_id IN NUMBER DEFAULT NULL,
155: p_split_reason_code IN VARCHAR2 DEFAULT NULL,
156: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: p_abort_on_warn_flag IN CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
158: p_cascade_updates_flag IN CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
159: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
160: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
155: p_split_reason_code IN VARCHAR2 DEFAULT NULL,
156: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: p_abort_on_warn_flag IN CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
158: p_cascade_updates_flag IN CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
159: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
160: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161: p_savepoint_rec_lvl IN NUMBER DEFAULT 1
162: );
163:
156: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: p_abort_on_warn_flag IN CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
158: p_cascade_updates_flag IN CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
159: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
160: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161: p_savepoint_rec_lvl IN NUMBER DEFAULT 1
162: );
163:
164:
164:
165: PROCEDURE Specify_Contact
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
169: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT VARCHAR2,
172: x_msg_count OUT NUMBER,
165: PROCEDURE Specify_Contact
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
169: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT VARCHAR2,
172: x_msg_count OUT NUMBER,
173: x_msg_data OUT VARCHAR2,
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
169: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT VARCHAR2,
172: x_msg_count OUT NUMBER,
173: x_msg_data OUT VARCHAR2,
174: p_contact_rec IN CS_InstalledBase_PUB.CP_Contact_Rec_Type,