DBA Data[Home] [Help]

APPS.AS_SC_DENORM_TRG dependencies on AS_LEAD_LINES_ALL

Line 58: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,

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,

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

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

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

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

Line 63: p_new_lead_id IN as_lead_lines_all.lead_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,

Line 64: p_new_lead_line_id IN as_lead_lines_all.lead_line_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,

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

Line 66: p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_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,

Line 67: p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%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,

Line 68: p_new_product_category_id IN as_lead_lines_all.product_category_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,
72: p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,

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

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

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

Line 72: p_old_lead_line_id IN as_lead_lines_all.lead_line_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,

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

Line 74: p_new_uom_code IN as_lead_lines_all.uom_code%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,

Line 75: p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%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,

Line 76: p_new_organization_id IN as_lead_lines_all.organization_id%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,

Line 77: p_old_frcst_date IN as_lead_lines_all.forecast_date%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);

Line 78: p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%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);
82:

Line 79: p_new_frcst_date IN as_lead_lines_all.forecast_date%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:
83: Procedure Sales_Credit_Trg_Handler(

Line 80: p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%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(
84: p_new_sales_credit_id IN NUMBER,