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_SC_DENORM_TRG dependencies on AS_LEAD_LINES

Line 147: From as_lead_lines_all

143: Where lead_id = p_lead_id;
144:
145: CURSOR c_no_line_forecasts (p_lead_id as_leads_all.lead_id%type) IS
146: Select lead_line_id
147: From as_lead_lines_all
148: Where lead_id = p_lead_id AND forecast_date IS NULL;
149:
150: l_customer_id as_leads_all.customer_id%TYPE;
151: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;

Line 433: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,

429: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');
430: End Leads_Trigger_Handler;
431:
432: Procedure Lead_Lines_Trigger_Handler(
433: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
434: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
435: p_new_creation_date IN as_lead_lines_all.creation_date%type,
436: p_new_created_by IN as_lead_lines_all.created_by%type,
437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,

Line 434: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,

430: End Leads_Trigger_Handler;
431:
432: Procedure Lead_Lines_Trigger_Handler(
433: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
434: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
435: p_new_creation_date IN as_lead_lines_all.creation_date%type,
436: p_new_created_by IN as_lead_lines_all.created_by%type,
437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
438: p_new_lead_id IN as_lead_lines_all.lead_id%type,

Line 435: p_new_creation_date IN as_lead_lines_all.creation_date%type,

431:
432: Procedure Lead_Lines_Trigger_Handler(
433: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
434: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
435: p_new_creation_date IN as_lead_lines_all.creation_date%type,
436: p_new_created_by IN as_lead_lines_all.created_by%type,
437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
438: p_new_lead_id IN as_lead_lines_all.lead_id%type,
439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,

Line 436: p_new_created_by IN as_lead_lines_all.created_by%type,

432: Procedure Lead_Lines_Trigger_Handler(
433: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
434: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
435: p_new_creation_date IN as_lead_lines_all.creation_date%type,
436: p_new_created_by IN as_lead_lines_all.created_by%type,
437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
438: p_new_lead_id IN as_lead_lines_all.lead_id%type,
439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,

Line 437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,

433: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
434: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
435: p_new_creation_date IN as_lead_lines_all.creation_date%type,
436: p_new_created_by IN as_lead_lines_all.created_by%type,
437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
438: p_new_lead_id IN as_lead_lines_all.lead_id%type,
439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,

Line 438: p_new_lead_id IN as_lead_lines_all.lead_id%type,

434: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
435: p_new_creation_date IN as_lead_lines_all.creation_date%type,
436: p_new_created_by IN as_lead_lines_all.created_by%type,
437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
438: p_new_lead_id IN as_lead_lines_all.lead_id%type,
439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,

Line 439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,

435: p_new_creation_date IN as_lead_lines_all.creation_date%type,
436: p_new_created_by IN as_lead_lines_all.created_by%type,
437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
438: p_new_lead_id IN as_lead_lines_all.lead_id%type,
439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,

Line 440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,

436: p_new_created_by IN as_lead_lines_all.created_by%type,
437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
438: p_new_lead_id IN as_lead_lines_all.lead_id%type,
439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,

Line 441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,

437: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
438: p_new_lead_id IN as_lead_lines_all.lead_id%type,
439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
445: p_new_total_amount IN as_lead_lines_all.total_amount%type,

Line 442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,

438: p_new_lead_id IN as_lead_lines_all.lead_id%type,
439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
445: p_new_total_amount IN as_lead_lines_all.total_amount%type,
446: p_old_total_amount IN as_lead_lines_all.total_amount%type,

Line 443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,

439: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
445: p_new_total_amount IN as_lead_lines_all.total_amount%type,
446: p_old_total_amount IN as_lead_lines_all.total_amount%type,
447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,

Line 444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,

440: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
445: p_new_total_amount IN as_lead_lines_all.total_amount%type,
446: p_old_total_amount IN as_lead_lines_all.total_amount%type,
447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
448: p_new_quantity IN as_lead_lines_all.quantity%type,

Line 445: p_new_total_amount IN as_lead_lines_all.total_amount%type,

441: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
445: p_new_total_amount IN as_lead_lines_all.total_amount%type,
446: p_old_total_amount IN as_lead_lines_all.total_amount%type,
447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
448: p_new_quantity IN as_lead_lines_all.quantity%type,
449: p_new_uom_code IN as_lead_lines_all.uom_code%type,

Line 446: p_old_total_amount IN as_lead_lines_all.total_amount%type,

442: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
445: p_new_total_amount IN as_lead_lines_all.total_amount%type,
446: p_old_total_amount IN as_lead_lines_all.total_amount%type,
447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
448: p_new_quantity IN as_lead_lines_all.quantity%type,
449: p_new_uom_code IN as_lead_lines_all.uom_code%type,
450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,

Line 447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,

443: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
445: p_new_total_amount IN as_lead_lines_all.total_amount%type,
446: p_old_total_amount IN as_lead_lines_all.total_amount%type,
447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
448: p_new_quantity IN as_lead_lines_all.quantity%type,
449: p_new_uom_code IN as_lead_lines_all.uom_code%type,
450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
451: p_new_organization_id IN as_lead_lines_all.organization_id%type,

Line 448: p_new_quantity IN as_lead_lines_all.quantity%type,

444: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
445: p_new_total_amount IN as_lead_lines_all.total_amount%type,
446: p_old_total_amount IN as_lead_lines_all.total_amount%type,
447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
448: p_new_quantity IN as_lead_lines_all.quantity%type,
449: p_new_uom_code IN as_lead_lines_all.uom_code%type,
450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
451: p_new_organization_id IN as_lead_lines_all.organization_id%type,
452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,

Line 449: p_new_uom_code IN as_lead_lines_all.uom_code%type,

445: p_new_total_amount IN as_lead_lines_all.total_amount%type,
446: p_old_total_amount IN as_lead_lines_all.total_amount%type,
447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
448: p_new_quantity IN as_lead_lines_all.quantity%type,
449: p_new_uom_code IN as_lead_lines_all.uom_code%type,
450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
451: p_new_organization_id IN as_lead_lines_all.organization_id%type,
452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
453: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,

Line 450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,

446: p_old_total_amount IN as_lead_lines_all.total_amount%type,
447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
448: p_new_quantity IN as_lead_lines_all.quantity%type,
449: p_new_uom_code IN as_lead_lines_all.uom_code%type,
450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
451: p_new_organization_id IN as_lead_lines_all.organization_id%type,
452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
453: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
454: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,

Line 451: p_new_organization_id IN as_lead_lines_all.organization_id%type,

447: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
448: p_new_quantity IN as_lead_lines_all.quantity%type,
449: p_new_uom_code IN as_lead_lines_all.uom_code%type,
450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
451: p_new_organization_id IN as_lead_lines_all.organization_id%type,
452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
453: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
454: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
455: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,

Line 452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,

448: p_new_quantity IN as_lead_lines_all.quantity%type,
449: p_new_uom_code IN as_lead_lines_all.uom_code%type,
450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
451: p_new_organization_id IN as_lead_lines_all.organization_id%type,
452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
453: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
454: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
455: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
456: p_trigger_mode IN VARCHAR2) IS

Line 453: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,

449: p_new_uom_code IN as_lead_lines_all.uom_code%type,
450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
451: p_new_organization_id IN as_lead_lines_all.organization_id%type,
452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
453: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
454: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
455: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
456: p_trigger_mode IN VARCHAR2) IS
457:

Line 454: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,

450: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
451: p_new_organization_id IN as_lead_lines_all.organization_id%type,
452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
453: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
454: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
455: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
456: p_trigger_mode IN VARCHAR2) IS
457:
458: Cursor c_sales_credit_amount (p_lead_line_id as_lead_lines_all.lead_id%type) IS

Line 455: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,

451: p_new_organization_id IN as_lead_lines_all.organization_id%type,
452: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
453: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
454: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
455: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
456: p_trigger_mode IN VARCHAR2) IS
457:
458: Cursor c_sales_credit_amount (p_lead_line_id as_lead_lines_all.lead_id%type) IS
459: Select sales_credit_id, credit_amount, credit_percent

Line 458: Cursor c_sales_credit_amount (p_lead_line_id as_lead_lines_all.lead_id%type) IS

454: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
455: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
456: p_trigger_mode IN VARCHAR2) IS
457:
458: Cursor c_sales_credit_amount (p_lead_line_id as_lead_lines_all.lead_id%type) IS
459: Select sales_credit_id, credit_amount, credit_percent
460: From as_sales_credits
461: Where lead_line_id = p_lead_line_id;
462:

Line 481: l_new_frcst_date as_lead_lines_all.forecast_date%type;

477: l_sales_credit_amount NUMBER;
478: l_win_probability NUMBER;
479: l_uom_description as_sales_credits_denorm.uom_description%type;
480: l_item_description as_sales_credits_denorm.item_description%type;
481: l_new_frcst_date as_lead_lines_all.forecast_date%type;
482: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
483:
484: Begin
485: IF l_debug THEN

Line 693: l_lead_line_id as_lead_lines_all.lead_line_id%TYPE;

689: l_channel_code as_leads_all.channel_code%TYPE;
690: l_lead_source_code as_leads_all.lead_source_code%TYPE;
691: l_deleted_flag as_leads_all.deleted_flag%Type;
692: l_orig_system_reference as_leads_all.orig_system_reference%TYPE;
693: l_lead_line_id as_lead_lines_all.lead_line_id%TYPE;
694: l_interest_type_id as_lead_lines_all.INTEREST_TYPE_ID%TYPE;
695: l_primary_interest_code_id as_lead_lines_all.PRIMARY_INTEREST_CODE_ID%TYPE;
696: l_secondary_interest_code_id as_lead_lines_all.SECONDARY_INTEREST_CODE_ID%TYPE;
697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;

Line 694: l_interest_type_id as_lead_lines_all.INTEREST_TYPE_ID%TYPE;

690: l_lead_source_code as_leads_all.lead_source_code%TYPE;
691: l_deleted_flag as_leads_all.deleted_flag%Type;
692: l_orig_system_reference as_leads_all.orig_system_reference%TYPE;
693: l_lead_line_id as_lead_lines_all.lead_line_id%TYPE;
694: l_interest_type_id as_lead_lines_all.INTEREST_TYPE_ID%TYPE;
695: l_primary_interest_code_id as_lead_lines_all.PRIMARY_INTEREST_CODE_ID%TYPE;
696: l_secondary_interest_code_id as_lead_lines_all.SECONDARY_INTEREST_CODE_ID%TYPE;
697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;
698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;

Line 695: l_primary_interest_code_id as_lead_lines_all.PRIMARY_INTEREST_CODE_ID%TYPE;

691: l_deleted_flag as_leads_all.deleted_flag%Type;
692: l_orig_system_reference as_leads_all.orig_system_reference%TYPE;
693: l_lead_line_id as_lead_lines_all.lead_line_id%TYPE;
694: l_interest_type_id as_lead_lines_all.INTEREST_TYPE_ID%TYPE;
695: l_primary_interest_code_id as_lead_lines_all.PRIMARY_INTEREST_CODE_ID%TYPE;
696: l_secondary_interest_code_id as_lead_lines_all.SECONDARY_INTEREST_CODE_ID%TYPE;
697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;
698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;
699: l_currency_code as_leads_all.currency_code%TYPE;

Line 696: l_secondary_interest_code_id as_lead_lines_all.SECONDARY_INTEREST_CODE_ID%TYPE;

692: l_orig_system_reference as_leads_all.orig_system_reference%TYPE;
693: l_lead_line_id as_lead_lines_all.lead_line_id%TYPE;
694: l_interest_type_id as_lead_lines_all.INTEREST_TYPE_ID%TYPE;
695: l_primary_interest_code_id as_lead_lines_all.PRIMARY_INTEREST_CODE_ID%TYPE;
696: l_secondary_interest_code_id as_lead_lines_all.SECONDARY_INTEREST_CODE_ID%TYPE;
697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;
698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;
699: l_currency_code as_leads_all.currency_code%TYPE;
700: l_customer_category ar_lookups.meaning%TYPE;

Line 697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;

693: l_lead_line_id as_lead_lines_all.lead_line_id%TYPE;
694: l_interest_type_id as_lead_lines_all.INTEREST_TYPE_ID%TYPE;
695: l_primary_interest_code_id as_lead_lines_all.PRIMARY_INTEREST_CODE_ID%TYPE;
696: l_secondary_interest_code_id as_lead_lines_all.SECONDARY_INTEREST_CODE_ID%TYPE;
697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;
698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;
699: l_currency_code as_leads_all.currency_code%TYPE;
700: l_customer_category ar_lookups.meaning%TYPE;
701: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;

Line 698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;

694: l_interest_type_id as_lead_lines_all.INTEREST_TYPE_ID%TYPE;
695: l_primary_interest_code_id as_lead_lines_all.PRIMARY_INTEREST_CODE_ID%TYPE;
696: l_secondary_interest_code_id as_lead_lines_all.SECONDARY_INTEREST_CODE_ID%TYPE;
697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;
698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;
699: l_currency_code as_leads_all.currency_code%TYPE;
700: l_customer_category ar_lookups.meaning%TYPE;
701: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;
702: l_leadline_total_amount as_lead_lines_all.total_amount%TYPE;

Line 702: l_leadline_total_amount as_lead_lines_all.total_amount%TYPE;

698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;
699: l_currency_code as_leads_all.currency_code%TYPE;
700: l_customer_category ar_lookups.meaning%TYPE;
701: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;
702: l_leadline_total_amount as_lead_lines_all.total_amount%TYPE;
703: l_lead_total_amount as_leads_all.total_amount%TYPE;
704: l_total_amount NUMBER;
705: l_sc_amount NUMBER;
706: l_won_amount NUMBER;

Line 716: l_quantity as_lead_lines.quantity%Type;

712: l_sales_credit_amount NUMBER;
713: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
714: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
715: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
716: l_quantity as_lead_lines.quantity%Type;
717: l_uom_code as_lead_lines.uom_code%Type;
718: l_uom_description as_sales_credits_denorm.uom_description%Type;
719: l_item_id as_lead_lines.inventory_item_id%Type;
720: l_organization_id as_lead_lines.organization_id%Type;

Line 717: l_uom_code as_lead_lines.uom_code%Type;

713: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
714: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
715: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
716: l_quantity as_lead_lines.quantity%Type;
717: l_uom_code as_lead_lines.uom_code%Type;
718: l_uom_description as_sales_credits_denorm.uom_description%Type;
719: l_item_id as_lead_lines.inventory_item_id%Type;
720: l_organization_id as_lead_lines.organization_id%Type;
721: l_item_description as_sales_credits_denorm.item_description%Type;

Line 719: l_item_id as_lead_lines.inventory_item_id%Type;

715: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
716: l_quantity as_lead_lines.quantity%Type;
717: l_uom_code as_lead_lines.uom_code%Type;
718: l_uom_description as_sales_credits_denorm.uom_description%Type;
719: l_item_id as_lead_lines.inventory_item_id%Type;
720: l_organization_id as_lead_lines.organization_id%Type;
721: l_item_description as_sales_credits_denorm.item_description%Type;
722: l_revenue_flag aso_i_sales_credit_types_v.quota_flag%Type;
723: l_parent_project as_leads_all.parent_project%Type;

Line 720: l_organization_id as_lead_lines.organization_id%Type;

716: l_quantity as_lead_lines.quantity%Type;
717: l_uom_code as_lead_lines.uom_code%Type;
718: l_uom_description as_sales_credits_denorm.uom_description%Type;
719: l_item_id as_lead_lines.inventory_item_id%Type;
720: l_organization_id as_lead_lines.organization_id%Type;
721: l_item_description as_sales_credits_denorm.item_description%Type;
722: l_revenue_flag aso_i_sales_credit_types_v.quota_flag%Type;
723: l_parent_project as_leads_all.parent_project%Type;
724: l_partner_cust_name hz_parties.party_name%Type;

Line 991: From as_lead_lines_all

987: nvl(product_category_id, -1), nvl(product_cat_set_id, -1),
988: total_amount, quantity, uom_code, inventory_item_id, organization_id, trunc(nvl(forecast_date, l_decision_date)), rolling_forecast_flag
989: Into l_lead_line_id, l_interest_type_id, l_primary_interest_code_id,
990: l_secondary_interest_code_id, l_product_category_id, l_product_cat_set_id, l_leadline_total_amount, l_quantity, l_uom_code, l_item_id, l_organization_id, as_sc_denorm.scd_frcst_date(1), as_sc_denorm.scd_rolling_frcst_flg(1)
991: From as_lead_lines_all
992: Where lead_id = p_new_lead_id
993: And lead_line_id = p_new_lead_line_id;
994: Exception When Others then
995: l_lead_line_id := Null;