54: g_entity VARCHAR2(20) := 'OPPORTUNITY';
55:
56: procedure Create_Opportunity_Post (
57: p_api_version_number IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
62: p_salesforce_id IN NUMBER,
55:
56: procedure Create_Opportunity_Post (
57: p_api_version_number IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
62: p_salesforce_id IN NUMBER,
63: x_return_status OUT NOCOPY VARCHAR2,
56: procedure Create_Opportunity_Post (
57: p_api_version_number IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
62: p_salesforce_id IN NUMBER,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2);
66:
67: procedure Update_Opportunity_Pre (
68: p_api_version_number IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
73: p_salesforce_id IN NUMBER,
66:
67: procedure Update_Opportunity_Pre (
68: p_api_version_number IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
73: p_salesforce_id IN NUMBER,
74: x_return_status OUT NOCOPY VARCHAR2,
67: procedure Update_Opportunity_Pre (
68: p_api_version_number IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
73: p_salesforce_id IN NUMBER,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2);
77:
78: procedure Notify_CM_On_Create_Oppty (
79: p_api_version_number IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
84: p_salesforce_id IN NUMBER,
77:
78: procedure Notify_CM_On_Create_Oppty (
79: p_api_version_number IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
84: p_salesforce_id IN NUMBER,
85: p_relationship_type IN VARCHAR2,
78: procedure Notify_CM_On_Create_Oppty (
79: p_api_version_number IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
84: p_salesforce_id IN NUMBER,
85: p_relationship_type IN VARCHAR2,
86: p_party_relation_id IN NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2);
93:
94: procedure Send_Email_By_Workflow (
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: p_user_name_tbl IN JTF_VARCHAR2_TABLE_100,
100: p_user_type_tbl IN JTF_VARCHAR2_TABLE_100,
93:
94: procedure Send_Email_By_Workflow (
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: p_user_name_tbl IN JTF_VARCHAR2_TABLE_100,
100: p_user_type_tbl IN JTF_VARCHAR2_TABLE_100,
101: p_username IN VARCHAR2,
94: procedure Send_Email_By_Workflow (
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: p_user_name_tbl IN JTF_VARCHAR2_TABLE_100,
100: p_user_type_tbl IN JTF_VARCHAR2_TABLE_100,
101: p_username IN VARCHAR2,
102: p_opp_amt IN VARCHAR2,
113:
114: procedure StartWorkflow
115: (
116: p_api_version_number IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_itemKey IN VARCHAR2,
121: p_itemType IN VARCHAR2,
114: procedure StartWorkflow
115: (
116: p_api_version_number IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_itemKey IN VARCHAR2,
121: p_itemType IN VARCHAR2,
122: p_partner_id IN NUMBER,
115: (
116: p_api_version_number IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_itemKey IN VARCHAR2,
121: p_itemType IN VARCHAR2,
122: p_partner_id IN NUMBER,
123: p_partner_name IN VARCHAR2,
136:
137: PROCEDURE Notify_Party_On_Update_Oppty
138: (
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
144: p_salesforce_id IN NUMBER,
137: PROCEDURE Notify_Party_On_Update_Oppty
138: (
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
144: p_salesforce_id IN NUMBER,
145: x_return_status OUT NOCOPY VARCHAR2,
138: (
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
144: p_salesforce_id IN NUMBER,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
180: );
181:
182: procedure NOTIFY_ON_UPDATE_OPPTY_JBES (
183: p_api_version_number IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_lead_id IN NUMBER,
188: p_status IN VARCHAR2,
181:
182: procedure NOTIFY_ON_UPDATE_OPPTY_JBES (
183: p_api_version_number IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_lead_id IN NUMBER,
188: p_status IN VARCHAR2,
189: p_lead_name IN VARCHAR2,
182: procedure NOTIFY_ON_UPDATE_OPPTY_JBES (
183: p_api_version_number IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_lead_id IN NUMBER,
188: p_status IN VARCHAR2,
189: p_lead_name IN VARCHAR2,
190: p_customer_id IN NUMBER,