54: p_new_sales_methodology_id IN as_sales_credits_denorm.sales_methodology_id%type,
55: p_trigger_mode IN VARCHAR2);
56:
57: Procedure Lead_Lines_Trigger_Handler(
58: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
59: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
60: p_new_creation_date IN as_lead_lines_all.creation_date%type,
61: p_new_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
55: p_trigger_mode IN VARCHAR2);
56:
57: Procedure Lead_Lines_Trigger_Handler(
58: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
59: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
60: p_new_creation_date IN as_lead_lines_all.creation_date%type,
61: p_new_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
56:
57: Procedure Lead_Lines_Trigger_Handler(
58: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
59: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
60: p_new_creation_date IN as_lead_lines_all.creation_date%type,
61: p_new_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
57: Procedure Lead_Lines_Trigger_Handler(
58: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
59: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
60: p_new_creation_date IN as_lead_lines_all.creation_date%type,
61: p_new_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
58: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
59: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
60: p_new_creation_date IN as_lead_lines_all.creation_date%type,
61: p_new_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
59: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
60: p_new_creation_date IN as_lead_lines_all.creation_date%type,
61: p_new_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
60: p_new_creation_date IN as_lead_lines_all.creation_date%type,
61: p_new_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
61: p_new_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
62: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
63: p_new_lead_id IN as_lead_lines_all.lead_id%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
64: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
68: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
69: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
77: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
70: p_new_total_amount IN as_lead_lines_all.total_amount%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
77: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
78: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
71: p_old_total_amount IN as_lead_lines_all.total_amount%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
77: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
78: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
79: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
77: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
78: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
79: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
80: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
73: p_new_quantity IN as_lead_lines_all.quantity%type,
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
77: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
78: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
79: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
80: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
81: p_trigger_mode IN VARCHAR2);
74: p_new_uom_code IN as_lead_lines_all.uom_code%type,
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
77: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
78: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
79: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
80: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
81: p_trigger_mode IN VARCHAR2);
82:
75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
77: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
78: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
79: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
80: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
81: p_trigger_mode IN VARCHAR2);
82:
83: Procedure Sales_Credit_Trg_Handler(
76: p_new_organization_id IN as_lead_lines_all.organization_id%type,
77: p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
78: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
79: p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
80: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
81: p_trigger_mode IN VARCHAR2);
82:
83: Procedure Sales_Credit_Trg_Handler(
84: p_new_sales_credit_id IN NUMBER,