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.AS_LEADS_AUDIT_PKG dependencies on AS_LEAD_LINES_ALL

Line 352: p_new_lead_id IN as_lead_lines_all.lead_id%type,

348: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Leads_Trigger_Handler');
349: END Leads_Trigger_Handler;
350: Procedure Lead_Lines_Trigger_Handler(
351: p_trigger_mode IN VARCHAR2,
352: p_new_lead_id IN as_lead_lines_all.lead_id%type,
353: p_old_lead_id IN as_lead_lines_all.lead_id%type,
354:
355: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
356: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,

Line 353: p_old_lead_id IN as_lead_lines_all.lead_id%type,

349: END Leads_Trigger_Handler;
350: Procedure Lead_Lines_Trigger_Handler(
351: p_trigger_mode IN VARCHAR2,
352: p_new_lead_id IN as_lead_lines_all.lead_id%type,
353: p_old_lead_id IN as_lead_lines_all.lead_id%type,
354:
355: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
356: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
357:

Line 355: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,

351: p_trigger_mode IN VARCHAR2,
352: p_new_lead_id IN as_lead_lines_all.lead_id%type,
353: p_old_lead_id IN as_lead_lines_all.lead_id%type,
354:
355: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
356: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
357:
358: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
359: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,

Line 356: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,

352: p_new_lead_id IN as_lead_lines_all.lead_id%type,
353: p_old_lead_id IN as_lead_lines_all.lead_id%type,
354:
355: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
356: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
357:
358: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
359: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
360:

Line 358: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,

354:
355: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
356: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
357:
358: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
359: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
360:
361: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
362: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,

Line 359: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,

355: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
356: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
357:
358: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
359: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
360:
361: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
362: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
363:

Line 361: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,

357:
358: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
359: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
360:
361: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
362: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
363:
364: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
365: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,

Line 362: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,

358: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
359: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
360:
361: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
362: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
363:
364: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
365: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
366:

Line 364: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,

360:
361: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
362: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
363:
364: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
365: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
366:
367: p_new_creation_date IN as_lead_lines_all.creation_date%type,
368: p_old_creation_date IN as_lead_lines_all.creation_date%type,

Line 365: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,

361: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
362: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
363:
364: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
365: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
366:
367: p_new_creation_date IN as_lead_lines_all.creation_date%type,
368: p_old_creation_date IN as_lead_lines_all.creation_date%type,
369:

Line 367: p_new_creation_date IN as_lead_lines_all.creation_date%type,

363:
364: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
365: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
366:
367: p_new_creation_date IN as_lead_lines_all.creation_date%type,
368: p_old_creation_date IN as_lead_lines_all.creation_date%type,
369:
370: p_new_created_by IN as_lead_lines_all.created_by%type,
371: p_old_created_by IN as_lead_lines_all.created_by%type,

Line 368: p_old_creation_date IN as_lead_lines_all.creation_date%type,

364: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
365: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
366:
367: p_new_creation_date IN as_lead_lines_all.creation_date%type,
368: p_old_creation_date IN as_lead_lines_all.creation_date%type,
369:
370: p_new_created_by IN as_lead_lines_all.created_by%type,
371: p_old_created_by IN as_lead_lines_all.created_by%type,
372:

Line 370: p_new_created_by IN as_lead_lines_all.created_by%type,

366:
367: p_new_creation_date IN as_lead_lines_all.creation_date%type,
368: p_old_creation_date IN as_lead_lines_all.creation_date%type,
369:
370: p_new_created_by IN as_lead_lines_all.created_by%type,
371: p_old_created_by IN as_lead_lines_all.created_by%type,
372:
373: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,

Line 371: p_old_created_by IN as_lead_lines_all.created_by%type,

367: p_new_creation_date IN as_lead_lines_all.creation_date%type,
368: p_old_creation_date IN as_lead_lines_all.creation_date%type,
369:
370: p_new_created_by IN as_lead_lines_all.created_by%type,
371: p_old_created_by IN as_lead_lines_all.created_by%type,
372:
373: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,

Line 373: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,

369:
370: p_new_created_by IN as_lead_lines_all.created_by%type,
371: p_old_created_by IN as_lead_lines_all.created_by%type,
372:
373: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,

Line 374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,

370: p_new_created_by IN as_lead_lines_all.created_by%type,
371: p_old_created_by IN as_lead_lines_all.created_by%type,
372:
373: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,

Line 375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,

371: p_old_created_by IN as_lead_lines_all.created_by%type,
372:
373: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,

Line 376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,

372:
373: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,

Line 377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,

373: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,

Line 378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,

374: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,

Line 379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,

375: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,

Line 380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,

376: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,

Line 381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,

377: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
385: p_new_organization_id IN as_lead_lines_all.organization_id%type,

Line 382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,

378: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
385: p_new_organization_id IN as_lead_lines_all.organization_id%type,
386: p_old_organization_id IN as_lead_lines_all.organization_id%type,

Line 383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,

379: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
385: p_new_organization_id IN as_lead_lines_all.organization_id%type,
386: p_old_organization_id IN as_lead_lines_all.organization_id%type,
387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,

Line 384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,

380: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
385: p_new_organization_id IN as_lead_lines_all.organization_id%type,
386: p_old_organization_id IN as_lead_lines_all.organization_id%type,
387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,

Line 385: p_new_organization_id IN as_lead_lines_all.organization_id%type,

381: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
385: p_new_organization_id IN as_lead_lines_all.organization_id%type,
386: p_old_organization_id IN as_lead_lines_all.organization_id%type,
387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
389: p_new_offer_id IN as_lead_lines_all.offer_id%type,

Line 386: p_old_organization_id IN as_lead_lines_all.organization_id%type,

382: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
385: p_new_organization_id IN as_lead_lines_all.organization_id%type,
386: p_old_organization_id IN as_lead_lines_all.organization_id%type,
387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
389: p_new_offer_id IN as_lead_lines_all.offer_id%type,
390: p_old_offer_id IN as_lead_lines_all.offer_id%type,

Line 387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,

383: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
385: p_new_organization_id IN as_lead_lines_all.organization_id%type,
386: p_old_organization_id IN as_lead_lines_all.organization_id%type,
387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
389: p_new_offer_id IN as_lead_lines_all.offer_id%type,
390: p_old_offer_id IN as_lead_lines_all.offer_id%type,
391: p_new_org_id IN as_lead_lines_all.org_id%type,

Line 388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,

384: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
385: p_new_organization_id IN as_lead_lines_all.organization_id%type,
386: p_old_organization_id IN as_lead_lines_all.organization_id%type,
387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
389: p_new_offer_id IN as_lead_lines_all.offer_id%type,
390: p_old_offer_id IN as_lead_lines_all.offer_id%type,
391: p_new_org_id IN as_lead_lines_all.org_id%type,
392: p_old_org_id IN as_lead_lines_all.org_id%type,

Line 389: p_new_offer_id IN as_lead_lines_all.offer_id%type,

385: p_new_organization_id IN as_lead_lines_all.organization_id%type,
386: p_old_organization_id IN as_lead_lines_all.organization_id%type,
387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
389: p_new_offer_id IN as_lead_lines_all.offer_id%type,
390: p_old_offer_id IN as_lead_lines_all.offer_id%type,
391: p_new_org_id IN as_lead_lines_all.org_id%type,
392: p_old_org_id IN as_lead_lines_all.org_id%type,
393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,

Line 390: p_old_offer_id IN as_lead_lines_all.offer_id%type,

386: p_old_organization_id IN as_lead_lines_all.organization_id%type,
387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
389: p_new_offer_id IN as_lead_lines_all.offer_id%type,
390: p_old_offer_id IN as_lead_lines_all.offer_id%type,
391: p_new_org_id IN as_lead_lines_all.org_id%type,
392: p_old_org_id IN as_lead_lines_all.org_id%type,
393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,

Line 391: p_new_org_id IN as_lead_lines_all.org_id%type,

387: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
389: p_new_offer_id IN as_lead_lines_all.offer_id%type,
390: p_old_offer_id IN as_lead_lines_all.offer_id%type,
391: p_new_org_id IN as_lead_lines_all.org_id%type,
392: p_old_org_id IN as_lead_lines_all.org_id%type,
393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,

Line 392: p_old_org_id IN as_lead_lines_all.org_id%type,

388: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
389: p_new_offer_id IN as_lead_lines_all.offer_id%type,
390: p_old_offer_id IN as_lead_lines_all.offer_id%type,
391: p_new_org_id IN as_lead_lines_all.org_id%type,
392: p_old_org_id IN as_lead_lines_all.org_id%type,
393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,

Line 393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,

389: p_new_offer_id IN as_lead_lines_all.offer_id%type,
390: p_old_offer_id IN as_lead_lines_all.offer_id%type,
391: p_new_org_id IN as_lead_lines_all.org_id%type,
392: p_old_org_id IN as_lead_lines_all.org_id%type,
393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,

Line 394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,

390: p_old_offer_id IN as_lead_lines_all.offer_id%type,
391: p_new_org_id IN as_lead_lines_all.org_id%type,
392: p_old_org_id IN as_lead_lines_all.org_id%type,
393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,

Line 395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,

391: p_new_org_id IN as_lead_lines_all.org_id%type,
392: p_old_org_id IN as_lead_lines_all.org_id%type,
393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
399: p_new_quantity IN as_lead_lines_all.quantity%type ,

Line 396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,

392: p_old_org_id IN as_lead_lines_all.org_id%type,
393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
399: p_new_quantity IN as_lead_lines_all.quantity%type ,
400: p_old_quantity IN as_lead_lines_all.quantity%type ,

Line 397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,

393: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
399: p_new_quantity IN as_lead_lines_all.quantity%type ,
400: p_old_quantity IN as_lead_lines_all.quantity%type ,
401: p_new_uom IN as_lead_lines_all.UOM_CODE%type,

Line 398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,

394: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
399: p_new_quantity IN as_lead_lines_all.quantity%type ,
400: p_old_quantity IN as_lead_lines_all.quantity%type ,
401: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
402: p_old_uom IN as_lead_lines_all.UOM_CODE%type)

Line 399: p_new_quantity IN as_lead_lines_all.quantity%type ,

395: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
399: p_new_quantity IN as_lead_lines_all.quantity%type ,
400: p_old_quantity IN as_lead_lines_all.quantity%type ,
401: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
402: p_old_uom IN as_lead_lines_all.UOM_CODE%type)
403: IS

Line 400: p_old_quantity IN as_lead_lines_all.quantity%type ,

396: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
399: p_new_quantity IN as_lead_lines_all.quantity%type ,
400: p_old_quantity IN as_lead_lines_all.quantity%type ,
401: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
402: p_old_uom IN as_lead_lines_all.UOM_CODE%type)
403: IS
404: today_date Date;

Line 401: p_new_uom IN as_lead_lines_all.UOM_CODE%type,

397: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
399: p_new_quantity IN as_lead_lines_all.quantity%type ,
400: p_old_quantity IN as_lead_lines_all.quantity%type ,
401: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
402: p_old_uom IN as_lead_lines_all.UOM_CODE%type)
403: IS
404: today_date Date;
405: lookUpTypeFlag BOOLEAN;

Line 402: p_old_uom IN as_lead_lines_all.UOM_CODE%type)

398: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
399: p_new_quantity IN as_lead_lines_all.quantity%type ,
400: p_old_quantity IN as_lead_lines_all.quantity%type ,
401: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
402: p_old_uom IN as_lead_lines_all.UOM_CODE%type)
403: IS
404: today_date Date;
405: lookUpTypeFlag BOOLEAN;
406: IsInsert NUMBER := 0;