52: p_old_org_id IN as_leads_all.org_id%type,
53: p_trigger_mode IN VARCHAR2);
54: Procedure Lead_Lines_Trigger_Handler(
55: p_trigger_mode IN VARCHAR2,
56: p_new_lead_id IN as_lead_lines_all.lead_id%type,
57: p_old_lead_id IN as_lead_lines_all.lead_id%type,
58: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
53: p_trigger_mode IN VARCHAR2);
54: Procedure Lead_Lines_Trigger_Handler(
55: p_trigger_mode IN VARCHAR2,
56: p_new_lead_id IN as_lead_lines_all.lead_id%type,
57: p_old_lead_id IN as_lead_lines_all.lead_id%type,
58: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
54: Procedure Lead_Lines_Trigger_Handler(
55: p_trigger_mode IN VARCHAR2,
56: p_new_lead_id IN as_lead_lines_all.lead_id%type,
57: p_old_lead_id IN as_lead_lines_all.lead_id%type,
58: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
55: p_trigger_mode IN VARCHAR2,
56: p_new_lead_id IN as_lead_lines_all.lead_id%type,
57: p_old_lead_id IN as_lead_lines_all.lead_id%type,
58: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
56: p_new_lead_id IN as_lead_lines_all.lead_id%type,
57: p_old_lead_id IN as_lead_lines_all.lead_id%type,
58: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
57: p_old_lead_id IN as_lead_lines_all.lead_id%type,
58: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
58: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66: p_new_creation_date IN as_lead_lines_all.creation_date%type,
59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66: p_new_creation_date IN as_lead_lines_all.creation_date%type,
67: p_old_creation_date IN as_lead_lines_all.creation_date%type,
60: p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66: p_new_creation_date IN as_lead_lines_all.creation_date%type,
67: p_old_creation_date IN as_lead_lines_all.creation_date%type,
68: p_new_created_by IN as_lead_lines_all.created_by%type,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66: p_new_creation_date IN as_lead_lines_all.creation_date%type,
67: p_old_creation_date IN as_lead_lines_all.creation_date%type,
68: p_new_created_by IN as_lead_lines_all.created_by%type,
69: p_old_created_by IN as_lead_lines_all.created_by%type,
62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66: p_new_creation_date IN as_lead_lines_all.creation_date%type,
67: p_old_creation_date IN as_lead_lines_all.creation_date%type,
68: p_new_created_by IN as_lead_lines_all.created_by%type,
69: p_old_created_by IN as_lead_lines_all.created_by%type,
70:
63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66: p_new_creation_date IN as_lead_lines_all.creation_date%type,
67: p_old_creation_date IN as_lead_lines_all.creation_date%type,
68: p_new_created_by IN as_lead_lines_all.created_by%type,
69: p_old_created_by IN as_lead_lines_all.created_by%type,
70:
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
64: p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66: p_new_creation_date IN as_lead_lines_all.creation_date%type,
67: p_old_creation_date IN as_lead_lines_all.creation_date%type,
68: p_new_created_by IN as_lead_lines_all.created_by%type,
69: p_old_created_by IN as_lead_lines_all.created_by%type,
70:
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
65: p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66: p_new_creation_date IN as_lead_lines_all.creation_date%type,
67: p_old_creation_date IN as_lead_lines_all.creation_date%type,
68: p_new_created_by IN as_lead_lines_all.created_by%type,
69: p_old_created_by IN as_lead_lines_all.created_by%type,
70:
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67: p_old_creation_date IN as_lead_lines_all.creation_date%type,
68: p_new_created_by IN as_lead_lines_all.created_by%type,
69: p_old_created_by IN as_lead_lines_all.created_by%type,
70:
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68: p_new_created_by IN as_lead_lines_all.created_by%type,
69: p_old_created_by IN as_lead_lines_all.created_by%type,
70:
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
69: p_old_created_by IN as_lead_lines_all.created_by%type,
70:
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
70:
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
77: p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
78: p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
83: p_new_organization_id IN as_lead_lines_all.organization_id%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
84: p_old_organization_id IN as_lead_lines_all.organization_id%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
87: p_new_offer_id IN as_lead_lines_all.offer_id%type,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
88: p_old_offer_id IN as_lead_lines_all.offer_id%type,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
89: p_new_org_id IN as_lead_lines_all.org_id%type,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97: p_new_quantity IN as_lead_lines_all.quantity%type ,
90: p_old_org_id IN as_lead_lines_all.org_id%type,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97: p_new_quantity IN as_lead_lines_all.quantity%type ,
98: p_old_quantity IN as_lead_lines_all.quantity%type ,
91: p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97: p_new_quantity IN as_lead_lines_all.quantity%type ,
98: p_old_quantity IN as_lead_lines_all.quantity%type ,
99: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97: p_new_quantity IN as_lead_lines_all.quantity%type ,
98: p_old_quantity IN as_lead_lines_all.quantity%type ,
99: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
100: p_old_uom IN as_lead_lines_all.UOM_CODE%type);
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97: p_new_quantity IN as_lead_lines_all.quantity%type ,
98: p_old_quantity IN as_lead_lines_all.quantity%type ,
99: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
100: p_old_uom IN as_lead_lines_all.UOM_CODE%type);
101:
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97: p_new_quantity IN as_lead_lines_all.quantity%type ,
98: p_old_quantity IN as_lead_lines_all.quantity%type ,
99: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
100: p_old_uom IN as_lead_lines_all.UOM_CODE%type);
101:
102:
95: p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97: p_new_quantity IN as_lead_lines_all.quantity%type ,
98: p_old_quantity IN as_lead_lines_all.quantity%type ,
99: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
100: p_old_uom IN as_lead_lines_all.UOM_CODE%type);
101:
102:
103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
96: p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97: p_new_quantity IN as_lead_lines_all.quantity%type ,
98: p_old_quantity IN as_lead_lines_all.quantity%type ,
99: p_new_uom IN as_lead_lines_all.UOM_CODE%type,
100: p_old_uom IN as_lead_lines_all.UOM_CODE%type);
101:
102:
103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
104: p_new_lead_id IN as_sales_credits.lead_id%type,