DBA Data[Home] [Help]

APPS.AS_LEADS_AUDIT_PKG dependencies on AS_LEAD_LINES_ALL

Line 56: p_new_lead_id IN as_lead_lines_all.lead_id%type,

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,

Line 57: p_old_lead_id IN as_lead_lines_all.lead_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,
61: p_old_last_update_date IN as_lead_lines_all.last_update_date%type,

Line 58: p_new_lead_line_id IN as_lead_lines_all.lead_line_id%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,

Line 59: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%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,

Line 60: p_new_last_update_date IN as_lead_lines_all.last_update_date%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,

Line 61: p_old_last_update_date IN as_lead_lines_all.last_update_date%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,

Line 62: p_new_last_updated_by IN as_lead_lines_all.last_updated_by%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,

Line 63: p_old_last_updated_by IN as_lead_lines_all.last_updated_by%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,

Line 64: p_new_last_update_login IN as_lead_lines_all.last_update_login%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,

Line 65: p_old_last_update_login IN as_lead_lines_all.last_update_login%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,

Line 66: p_new_creation_date IN as_lead_lines_all.creation_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,
70:

Line 67: p_old_creation_date IN as_lead_lines_all.creation_date%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:
71: p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,

Line 68: p_new_created_by IN as_lead_lines_all.created_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,
72: p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,

Line 69: p_old_created_by IN as_lead_lines_all.created_by%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,

Line 71: p_new_interest_type_id IN as_lead_lines_all.interest_type_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,

Line 72: p_old_interest_type_id IN as_lead_lines_all.interest_type_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,

Line 73: p_new_primary_interest_code_id IN as_lead_lines_all.primary_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,

Line 74: p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_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,

Line 75: p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_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,

Line 76: p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_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,

Line 77: p_new_product_category_id IN as_lead_lines_all.product_category_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,

Line 78: p_old_product_category_id IN as_lead_lines_all.product_category_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,

Line 79: p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_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,

Line 80: p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_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,

Line 81: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_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,

Line 82: p_old_inventory_item_id IN as_lead_lines_all.inventory_item_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,

Line 83: p_new_organization_id IN as_lead_lines_all.organization_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,

Line 84: p_old_organization_id IN as_lead_lines_all.organization_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,

Line 85: p_new_source_promotion_id IN as_lead_lines_all.source_promotion_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,

Line 86: p_old_source_promotion_id IN as_lead_lines_all.source_promotion_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,

Line 87: p_new_offer_id IN as_lead_lines_all.offer_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,

Line 88: p_old_offer_id IN as_lead_lines_all.offer_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,
92: p_old_forecast_date IN as_lead_lines_all.forecast_date%type,

Line 89: p_new_org_id IN as_lead_lines_all.org_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,
93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,

Line 90: p_old_org_id IN as_lead_lines_all.org_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,
94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,

Line 91: p_new_forecast_date IN as_lead_lines_all.forecast_date%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 ,

Line 92: p_old_forecast_date IN as_lead_lines_all.forecast_date%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 ,

Line 93: p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%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 ,

Line 94: p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%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 ,

Line 95: p_new_total_amount IN as_lead_lines_all.total_amount%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,

Line 96: p_old_total_amount IN as_lead_lines_all.total_amount%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);

Line 97: p_new_quantity IN as_lead_lines_all.quantity%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:

Line 98: p_old_quantity IN as_lead_lines_all.quantity%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:
102:

Line 99: p_new_uom IN as_lead_lines_all.UOM_CODE%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:
103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,

Line 100: p_old_uom IN as_lead_lines_all.UOM_CODE%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,
104: p_new_lead_id IN as_sales_credits.lead_id%type,