eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGR_INQUIRY_PKG dependencies on AS_SALES_LEADS_PUB

Line 88: l_sales_lead_rec as_sales_leads_pub.G_MISS_SALES_LEAD_REC%TYPE ;

84: l_employee_id as_sales_leads.assign_to_person_id%TYPE;
85: l_resource_id as_sales_leads.assign_to_Salesforce_id%TYPE;
86: l_sales_lead_id as_sales_leads.sales_lead_id%TYPE;
87: l_address_id as_sales_leads.address_id%TYPE;
88: l_sales_lead_rec as_sales_leads_pub.G_MISS_SALES_LEAD_REC%TYPE ;
89:
90:
91: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
92: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

Line 91: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

87: l_address_id as_sales_leads.address_id%TYPE;
88: l_sales_lead_rec as_sales_leads_pub.G_MISS_SALES_LEAD_REC%TYPE ;
89:
90:
91: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
92: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
93: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
94: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
95: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

Line 92: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

88: l_sales_lead_rec as_sales_leads_pub.G_MISS_SALES_LEAD_REC%TYPE ;
89:
90:
91: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
92: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
93: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
94: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
95: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
96:

Line 94: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

90:
91: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
92: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
93: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
94: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
95: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
96:
97: CURSOR c_primary_address IS
98: SELECT party_site_id

Line 95: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

91: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
92: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
93: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
94: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
95: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
96:
97: CURSOR c_primary_address IS
98: SELECT party_site_id
99: FROM hz_party_sites

Line 118: AS_SALES_LEADS_PUB.CREATE_SALES_LEAD(

114: l_sales_lead_rec.address_id :=l_address_id;
115: l_sales_lead_rec.source_promotion_id :=x_source_promotion_id ;
116:
117:
118: AS_SALES_LEADS_PUB.CREATE_SALES_LEAD(
119: P_API_VERSION_NUMBER => 2.0,
120: P_INIT_MSG_LIST => FND_API.G_TRUE,
121: P_COMMIT => FND_API.G_FALSE,
122: P_VALIDATION_LEVEL => AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,

Line 219: AS_SALES_LEADS_PUB.Lead_Process_After_Create (

215: -- call Sales Real Time lead assignment API, passing in local ret/msg
216: -- variables, as failure of this API should not preclude lead
217: -- or inquiry creation.
218:
219: AS_SALES_LEADS_PUB.Lead_Process_After_Create (
220: P_Api_Version_Number => 2.0,
221: P_Init_Msg_List => FND_API.G_FALSE,
222: P_Commit => FND_API.G_FALSE,
223: P_Validation_Level => AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,

Line 236: fnd_file.put_line(fnd_file.log, 'AS_SALES_LEADS_PUB.Lead_Process_After_Create failed.');

232: X_Msg_Data => l_lead_proc_msg_data
233: );
234:
235: IF NVL(l_lead_proc_ret_status,'S') IN ('E','U') THEN
236: fnd_file.put_line(fnd_file.log, 'AS_SALES_LEADS_PUB.Lead_Process_After_Create failed.');
237: END IF;
238:
239: END IF; -- end lead properly created
240:

Line 323: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

319: l_tmp_var VARCHAR2(2000);
320: l_employee_id as_sales_leads.assign_to_person_id%TYPE;
321: l_resource_id as_sales_leads.assign_to_Salesforce_id%TYPE;
322: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
323: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
324: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
325: l_sales_lead_rec as_sales_leads_pub.G_MISS_SALES_LEAD_REC%TYPE ;
326:
327: CURSOR cur_last_update_date IS

Line 324: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

320: l_employee_id as_sales_leads.assign_to_person_id%TYPE;
321: l_resource_id as_sales_leads.assign_to_Salesforce_id%TYPE;
322: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
323: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
324: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
325: l_sales_lead_rec as_sales_leads_pub.G_MISS_SALES_LEAD_REC%TYPE ;
326:
327: CURSOR cur_last_update_date IS
328: SELECT last_update_date

Line 325: l_sales_lead_rec as_sales_leads_pub.G_MISS_SALES_LEAD_REC%TYPE ;

321: l_resource_id as_sales_leads.assign_to_Salesforce_id%TYPE;
322: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
323: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
324: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
325: l_sales_lead_rec as_sales_leads_pub.G_MISS_SALES_LEAD_REC%TYPE ;
326:
327: CURSOR cur_last_update_date IS
328: SELECT last_update_date
329: FROM as_sales_leads

Line 355: as_sales_leads_pub.update_sales_lead(

351: OPEN cur_last_update_date ;
352: FETCH cur_last_update_date INTO l_sales_lead_rec.last_update_date ;
353: CLOSE cur_last_update_date;
354:
355: as_sales_leads_pub.update_sales_lead(
356: P_Api_Version_Number => 2.0 ,
357: P_Init_Msg_List => FND_API.G_FALSE,
358: P_Commit => FND_API.G_FALSE,
359: P_Validation_Level => AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,

Line 439: AS_SALES_LEADS_PUB.Lead_Process_After_Update (

435: -- call Sales Real Time lead assignment API, passing in local ret/msg
436: -- variables, as failure of this API should not preclude lead
437: -- or inquiry creation.
438:
439: AS_SALES_LEADS_PUB.Lead_Process_After_Update (
440: P_Api_Version_Number => 2.0,
441: P_Init_Msg_List => FND_API.G_FALSE,
442: P_Commit => FND_API.G_FALSE,
443: P_Validation_Level => AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,

Line 456: fnd_file.put_line(fnd_file.log, 'AS_SALES_LEADS_PUB.Lead_Process_After_Update failed.');

452: X_Msg_Data => l_lead_proc_msg_data
453: );
454:
455: IF NVL(l_lead_proc_ret_status,'S') IN ('E','U') THEN
456: fnd_file.put_line(fnd_file.log, 'AS_SALES_LEADS_PUB.Lead_Process_After_Update failed.');
457: END IF;
458:
459: END IF;
460: