DBA Data[Home] [Help]

APPS.AS_LEADS_AUDIT_PKG dependencies on AS_LEADS_LOG_PKG

Line 83: -- dbms_output.put_line('Before Calling AS_LEADS_LOG_PKG.Insert_Row');

79: and last_update_date = p_old_last_update_date;
80:
81: IF ( p_trigger_mode = 'ON-INSERT' ) THEN
82: -- dbms_output.put_line('I am in ON-INSERT of Leads_Trigger_Handler');
83: -- dbms_output.put_line('Before Calling AS_LEADS_LOG_PKG.Insert_Row');
84:
85: AS_LEADS_LOG_PKG.Insert_Row(
86: px_LOG_ID => l_LOG_ID,
87: p_LEAD_ID => p_new_lead_id,

Line 85: AS_LEADS_LOG_PKG.Insert_Row(

81: IF ( p_trigger_mode = 'ON-INSERT' ) THEN
82: -- dbms_output.put_line('I am in ON-INSERT of Leads_Trigger_Handler');
83: -- dbms_output.put_line('Before Calling AS_LEADS_LOG_PKG.Insert_Row');
84:
85: AS_LEADS_LOG_PKG.Insert_Row(
86: px_LOG_ID => l_LOG_ID,
87: p_LEAD_ID => p_new_lead_id,
88: p_CREATED_BY => p_new_created_by,
89: p_CREATION_DATE => p_new_creation_date,

Line 136: AS_LEADS_LOG_PKG.Insert_Row(

132: WHERE LEAD_ID = p_old_lead_id;
133:
134: IF ( l_lead_count = 0 ) THEN
135: -- dbms_output.put_line('AS_LEADS_LOG: Not exists condition'|| l_lead_count);
136: AS_LEADS_LOG_PKG.Insert_Row(
137: px_LOG_ID => l_LOG_ID,
138: p_LEAD_ID => p_new_lead_id,
139: p_CREATED_BY => p_new_created_by,
140: p_CREATION_DATE => p_new_creation_date,

Line 237: AS_LEADS_LOG_PKG.Update_Row(

233: ( nvl(p_new_owner_sales_group_id,0) <> nvl(p_old_owner_sales_group_id,0) ) OR
234: ( nvl(p_new_org_id,0) <> nvl(p_old_org_id,0) ) ) ) THEN
235: IF ( IsInsert = 0) THEN
236: -- dbms_output.put_line('AS_LEADS_LOG: changed state i am in sam day'|| IsInsert);
237: AS_LEADS_LOG_PKG.Update_Row(
238: p_LOG_ID => l_LOG_ID,
239: p_LEAD_ID => p_new_lead_id,
240: p_OLD_LEAD_ID => p_old_lead_id,
241: p_CREATED_BY => p_new_created_by,

Line 278: AS_LEADS_LOG_PKG.Insert_Row(

274: 'asxopadb: Update Log: '||p_old_lead_id || 'and '|| p_old_last_update_date );
275: END IF;
276: ELSE
277: -- dbms_output.put_line('AS_LEADS_LOG: not changed state i am in diff day'|| IsInsert);
278: AS_LEADS_LOG_PKG.Insert_Row(
279: px_LOG_ID => l_LOG_ID,
280: p_LEAD_ID => p_new_lead_id,
281: p_CREATED_BY => p_new_created_by,
282: p_CREATION_DATE => p_new_creation_date,