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_LEADS_ALL

Line 88: p_new_last_update_date IN as_leads_all.last_update_date%type ,

84: End convert_amounts;
85:
86:
87: Procedure Leads_Trigger_Handler(
88: p_new_last_update_date IN as_leads_all.last_update_date%type ,
89: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
90: p_new_creation_date IN as_leads_all.creation_date%type,
91: p_new_created_by IN as_leads_all.created_by%type,
92: p_new_last_update_login IN as_leads_all.last_update_login%type,

Line 89: p_new_last_updated_by IN as_leads_all.last_updated_by%type,

85:
86:
87: Procedure Leads_Trigger_Handler(
88: p_new_last_update_date IN as_leads_all.last_update_date%type ,
89: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
90: p_new_creation_date IN as_leads_all.creation_date%type,
91: p_new_created_by IN as_leads_all.created_by%type,
92: p_new_last_update_login IN as_leads_all.last_update_login%type,
93: p_new_customer_id IN as_leads_all.customer_id%type,

Line 90: p_new_creation_date IN as_leads_all.creation_date%type,

86:
87: Procedure Leads_Trigger_Handler(
88: p_new_last_update_date IN as_leads_all.last_update_date%type ,
89: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
90: p_new_creation_date IN as_leads_all.creation_date%type,
91: p_new_created_by IN as_leads_all.created_by%type,
92: p_new_last_update_login IN as_leads_all.last_update_login%type,
93: p_new_customer_id IN as_leads_all.customer_id%type,
94: p_new_address_id IN as_leads_all.address_id%type,

Line 91: p_new_created_by IN as_leads_all.created_by%type,

87: Procedure Leads_Trigger_Handler(
88: p_new_last_update_date IN as_leads_all.last_update_date%type ,
89: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
90: p_new_creation_date IN as_leads_all.creation_date%type,
91: p_new_created_by IN as_leads_all.created_by%type,
92: p_new_last_update_login IN as_leads_all.last_update_login%type,
93: p_new_customer_id IN as_leads_all.customer_id%type,
94: p_new_address_id IN as_leads_all.address_id%type,
95: p_new_lead_id IN as_leads_all.lead_id%type,

Line 92: p_new_last_update_login IN as_leads_all.last_update_login%type,

88: p_new_last_update_date IN as_leads_all.last_update_date%type ,
89: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
90: p_new_creation_date IN as_leads_all.creation_date%type,
91: p_new_created_by IN as_leads_all.created_by%type,
92: p_new_last_update_login IN as_leads_all.last_update_login%type,
93: p_new_customer_id IN as_leads_all.customer_id%type,
94: p_new_address_id IN as_leads_all.address_id%type,
95: p_new_lead_id IN as_leads_all.lead_id%type,
96: p_new_lead_number IN as_leads_all.lead_number%type,

Line 93: p_new_customer_id IN as_leads_all.customer_id%type,

89: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
90: p_new_creation_date IN as_leads_all.creation_date%type,
91: p_new_created_by IN as_leads_all.created_by%type,
92: p_new_last_update_login IN as_leads_all.last_update_login%type,
93: p_new_customer_id IN as_leads_all.customer_id%type,
94: p_new_address_id IN as_leads_all.address_id%type,
95: p_new_lead_id IN as_leads_all.lead_id%type,
96: p_new_lead_number IN as_leads_all.lead_number%type,
97: p_new_description IN as_leads_all.description%type,

Line 94: p_new_address_id IN as_leads_all.address_id%type,

90: p_new_creation_date IN as_leads_all.creation_date%type,
91: p_new_created_by IN as_leads_all.created_by%type,
92: p_new_last_update_login IN as_leads_all.last_update_login%type,
93: p_new_customer_id IN as_leads_all.customer_id%type,
94: p_new_address_id IN as_leads_all.address_id%type,
95: p_new_lead_id IN as_leads_all.lead_id%type,
96: p_new_lead_number IN as_leads_all.lead_number%type,
97: p_new_description IN as_leads_all.description%type,
98: p_new_decision_date IN as_leads_all.decision_date%type ,

Line 95: p_new_lead_id IN as_leads_all.lead_id%type,

91: p_new_created_by IN as_leads_all.created_by%type,
92: p_new_last_update_login IN as_leads_all.last_update_login%type,
93: p_new_customer_id IN as_leads_all.customer_id%type,
94: p_new_address_id IN as_leads_all.address_id%type,
95: p_new_lead_id IN as_leads_all.lead_id%type,
96: p_new_lead_number IN as_leads_all.lead_number%type,
97: p_new_description IN as_leads_all.description%type,
98: p_new_decision_date IN as_leads_all.decision_date%type ,
99: p_old_decision_date IN as_leads_all.decision_date%type ,

Line 96: p_new_lead_number IN as_leads_all.lead_number%type,

92: p_new_last_update_login IN as_leads_all.last_update_login%type,
93: p_new_customer_id IN as_leads_all.customer_id%type,
94: p_new_address_id IN as_leads_all.address_id%type,
95: p_new_lead_id IN as_leads_all.lead_id%type,
96: p_new_lead_number IN as_leads_all.lead_number%type,
97: p_new_description IN as_leads_all.description%type,
98: p_new_decision_date IN as_leads_all.decision_date%type ,
99: p_old_decision_date IN as_leads_all.decision_date%type ,
100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,

Line 97: p_new_description IN as_leads_all.description%type,

93: p_new_customer_id IN as_leads_all.customer_id%type,
94: p_new_address_id IN as_leads_all.address_id%type,
95: p_new_lead_id IN as_leads_all.lead_id%type,
96: p_new_lead_number IN as_leads_all.lead_number%type,
97: p_new_description IN as_leads_all.description%type,
98: p_new_decision_date IN as_leads_all.decision_date%type ,
99: p_old_decision_date IN as_leads_all.decision_date%type ,
100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,

Line 98: p_new_decision_date IN as_leads_all.decision_date%type ,

94: p_new_address_id IN as_leads_all.address_id%type,
95: p_new_lead_id IN as_leads_all.lead_id%type,
96: p_new_lead_number IN as_leads_all.lead_number%type,
97: p_new_description IN as_leads_all.description%type,
98: p_new_decision_date IN as_leads_all.decision_date%type ,
99: p_old_decision_date IN as_leads_all.decision_date%type ,
100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,

Line 99: p_old_decision_date IN as_leads_all.decision_date%type ,

95: p_new_lead_id IN as_leads_all.lead_id%type,
96: p_new_lead_number IN as_leads_all.lead_number%type,
97: p_new_description IN as_leads_all.description%type,
98: p_new_decision_date IN as_leads_all.decision_date%type ,
99: p_old_decision_date IN as_leads_all.decision_date%type ,
100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,

Line 100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,

96: p_new_lead_number IN as_leads_all.lead_number%type,
97: p_new_description IN as_leads_all.description%type,
98: p_new_decision_date IN as_leads_all.decision_date%type ,
99: p_old_decision_date IN as_leads_all.decision_date%type ,
100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,

Line 101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,

97: p_new_description IN as_leads_all.description%type,
98: p_new_decision_date IN as_leads_all.decision_date%type ,
99: p_old_decision_date IN as_leads_all.decision_date%type ,
100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
105: p_new_win_probability IN as_leads_all.win_probability%type,

Line 102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,

98: p_new_decision_date IN as_leads_all.decision_date%type ,
99: p_old_decision_date IN as_leads_all.decision_date%type ,
100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
105: p_new_win_probability IN as_leads_all.win_probability%type,
106: p_old_win_probability IN as_leads_all.win_probability%type,

Line 103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,

99: p_old_decision_date IN as_leads_all.decision_date%type ,
100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
105: p_new_win_probability IN as_leads_all.win_probability%type,
106: p_old_win_probability IN as_leads_all.win_probability%type,
107: p_new_status IN as_leads_all.status%type,

Line 104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,

100: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
105: p_new_win_probability IN as_leads_all.win_probability%type,
106: p_old_win_probability IN as_leads_all.win_probability%type,
107: p_new_status IN as_leads_all.status%type,
108: p_old_status IN as_leads_all.status%type,

Line 105: p_new_win_probability IN as_leads_all.win_probability%type,

101: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
105: p_new_win_probability IN as_leads_all.win_probability%type,
106: p_old_win_probability IN as_leads_all.win_probability%type,
107: p_new_status IN as_leads_all.status%type,
108: p_old_status IN as_leads_all.status%type,
109: p_new_channel_code IN as_leads_all.channel_code%type,

Line 106: p_old_win_probability IN as_leads_all.win_probability%type,

102: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
105: p_new_win_probability IN as_leads_all.win_probability%type,
106: p_old_win_probability IN as_leads_all.win_probability%type,
107: p_new_status IN as_leads_all.status%type,
108: p_old_status IN as_leads_all.status%type,
109: p_new_channel_code IN as_leads_all.channel_code%type,
110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,

Line 107: p_new_status IN as_leads_all.status%type,

103: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
105: p_new_win_probability IN as_leads_all.win_probability%type,
106: p_old_win_probability IN as_leads_all.win_probability%type,
107: p_new_status IN as_leads_all.status%type,
108: p_old_status IN as_leads_all.status%type,
109: p_new_channel_code IN as_leads_all.channel_code%type,
110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,

Line 108: p_old_status IN as_leads_all.status%type,

104: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
105: p_new_win_probability IN as_leads_all.win_probability%type,
106: p_old_win_probability IN as_leads_all.win_probability%type,
107: p_new_status IN as_leads_all.status%type,
108: p_old_status IN as_leads_all.status%type,
109: p_new_channel_code IN as_leads_all.channel_code%type,
110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
112: p_new_currency_code IN as_leads_all.currency_code%type,

Line 109: p_new_channel_code IN as_leads_all.channel_code%type,

105: p_new_win_probability IN as_leads_all.win_probability%type,
106: p_old_win_probability IN as_leads_all.win_probability%type,
107: p_new_status IN as_leads_all.status%type,
108: p_old_status IN as_leads_all.status%type,
109: p_new_channel_code IN as_leads_all.channel_code%type,
110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
112: p_new_currency_code IN as_leads_all.currency_code%type,
113: p_old_currency_code IN as_leads_all.currency_code%type,

Line 110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,

106: p_old_win_probability IN as_leads_all.win_probability%type,
107: p_new_status IN as_leads_all.status%type,
108: p_old_status IN as_leads_all.status%type,
109: p_new_channel_code IN as_leads_all.channel_code%type,
110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
112: p_new_currency_code IN as_leads_all.currency_code%type,
113: p_old_currency_code IN as_leads_all.currency_code%type,
114: p_new_total_amount IN as_leads_all.total_amount%type,

Line 111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,

107: p_new_status IN as_leads_all.status%type,
108: p_old_status IN as_leads_all.status%type,
109: p_new_channel_code IN as_leads_all.channel_code%type,
110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
112: p_new_currency_code IN as_leads_all.currency_code%type,
113: p_old_currency_code IN as_leads_all.currency_code%type,
114: p_new_total_amount IN as_leads_all.total_amount%type,
115: p_old_total_amount IN as_leads_all.total_amount%type,

Line 112: p_new_currency_code IN as_leads_all.currency_code%type,

108: p_old_status IN as_leads_all.status%type,
109: p_new_channel_code IN as_leads_all.channel_code%type,
110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
112: p_new_currency_code IN as_leads_all.currency_code%type,
113: p_old_currency_code IN as_leads_all.currency_code%type,
114: p_new_total_amount IN as_leads_all.total_amount%type,
115: p_old_total_amount IN as_leads_all.total_amount%type,
116: p_old_lead_id IN as_leads_all.lead_id%type,

Line 113: p_old_currency_code IN as_leads_all.currency_code%type,

109: p_new_channel_code IN as_leads_all.channel_code%type,
110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
112: p_new_currency_code IN as_leads_all.currency_code%type,
113: p_old_currency_code IN as_leads_all.currency_code%type,
114: p_new_total_amount IN as_leads_all.total_amount%type,
115: p_old_total_amount IN as_leads_all.total_amount%type,
116: p_old_lead_id IN as_leads_all.lead_id%type,
117: p_new_org_id IN as_leads_all.org_id%type,

Line 114: p_new_total_amount IN as_leads_all.total_amount%type,

110: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
112: p_new_currency_code IN as_leads_all.currency_code%type,
113: p_old_currency_code IN as_leads_all.currency_code%type,
114: p_new_total_amount IN as_leads_all.total_amount%type,
115: p_old_total_amount IN as_leads_all.total_amount%type,
116: p_old_lead_id IN as_leads_all.lead_id%type,
117: p_new_org_id IN as_leads_all.org_id%type,
118: p_new_deleted_flag IN as_leads_all.deleted_flag%type,

Line 115: p_old_total_amount IN as_leads_all.total_amount%type,

111: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
112: p_new_currency_code IN as_leads_all.currency_code%type,
113: p_old_currency_code IN as_leads_all.currency_code%type,
114: p_new_total_amount IN as_leads_all.total_amount%type,
115: p_old_total_amount IN as_leads_all.total_amount%type,
116: p_old_lead_id IN as_leads_all.lead_id%type,
117: p_new_org_id IN as_leads_all.org_id%type,
118: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
119: p_new_parent_project IN as_leads_all.parent_project%type,

Line 116: p_old_lead_id IN as_leads_all.lead_id%type,

112: p_new_currency_code IN as_leads_all.currency_code%type,
113: p_old_currency_code IN as_leads_all.currency_code%type,
114: p_new_total_amount IN as_leads_all.total_amount%type,
115: p_old_total_amount IN as_leads_all.total_amount%type,
116: p_old_lead_id IN as_leads_all.lead_id%type,
117: p_new_org_id IN as_leads_all.org_id%type,
118: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
119: p_new_parent_project IN as_leads_all.parent_project%type,
120: p_new_close_reason IN as_leads_all.close_reason%type,

Line 117: p_new_org_id IN as_leads_all.org_id%type,

113: p_old_currency_code IN as_leads_all.currency_code%type,
114: p_new_total_amount IN as_leads_all.total_amount%type,
115: p_old_total_amount IN as_leads_all.total_amount%type,
116: p_old_lead_id IN as_leads_all.lead_id%type,
117: p_new_org_id IN as_leads_all.org_id%type,
118: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
119: p_new_parent_project IN as_leads_all.parent_project%type,
120: p_new_close_reason IN as_leads_all.close_reason%type,
121: p_new_attr_category IN as_sales_credits_denorm.attribute_category%type,

Line 118: p_new_deleted_flag IN as_leads_all.deleted_flag%type,

114: p_new_total_amount IN as_leads_all.total_amount%type,
115: p_old_total_amount IN as_leads_all.total_amount%type,
116: p_old_lead_id IN as_leads_all.lead_id%type,
117: p_new_org_id IN as_leads_all.org_id%type,
118: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
119: p_new_parent_project IN as_leads_all.parent_project%type,
120: p_new_close_reason IN as_leads_all.close_reason%type,
121: p_new_attr_category IN as_sales_credits_denorm.attribute_category%type,
122: p_new_attr1 IN as_sales_credits_denorm.attribute1%type,

Line 119: p_new_parent_project IN as_leads_all.parent_project%type,

115: p_old_total_amount IN as_leads_all.total_amount%type,
116: p_old_lead_id IN as_leads_all.lead_id%type,
117: p_new_org_id IN as_leads_all.org_id%type,
118: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
119: p_new_parent_project IN as_leads_all.parent_project%type,
120: p_new_close_reason IN as_leads_all.close_reason%type,
121: p_new_attr_category IN as_sales_credits_denorm.attribute_category%type,
122: p_new_attr1 IN as_sales_credits_denorm.attribute1%type,
123: p_new_attr2 IN as_sales_credits_denorm.attribute1%type,

Line 120: p_new_close_reason IN as_leads_all.close_reason%type,

116: p_old_lead_id IN as_leads_all.lead_id%type,
117: p_new_org_id IN as_leads_all.org_id%type,
118: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
119: p_new_parent_project IN as_leads_all.parent_project%type,
120: p_new_close_reason IN as_leads_all.close_reason%type,
121: p_new_attr_category IN as_sales_credits_denorm.attribute_category%type,
122: p_new_attr1 IN as_sales_credits_denorm.attribute1%type,
123: p_new_attr2 IN as_sales_credits_denorm.attribute1%type,
124: p_new_attr3 IN as_sales_credits_denorm.attribute1%type,

Line 140: CURSOR c_sales_credit_amount (p_lead_id as_leads_all.lead_id%type) IS

136: p_new_attr15 IN as_sales_credits_denorm.attribute1%type,
137: p_new_sales_methodology_id IN as_sales_credits_denorm.sales_methodology_id%type,
138: p_trigger_mode IN VARCHAR2) IS
139:
140: CURSOR c_sales_credit_amount (p_lead_id as_leads_all.lead_id%type) IS
141: Select sales_credit_id, sales_credit_amount, forecast_date
142: From as_sales_credits_denorm
143: Where lead_id = p_lead_id;
144:

Line 145: CURSOR c_no_line_forecasts (p_lead_id as_leads_all.lead_id%type) IS

141: Select sales_credit_id, sales_credit_amount, forecast_date
142: From as_sales_credits_denorm
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:

Line 150: l_customer_id as_leads_all.customer_id%TYPE;

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;
152: l_party_type as_party_customers_v.party_type%TYPE;
153: l_sales_stage as_sales_stages.name%TYPE;
154: l_status as_statuses_tl.meaning%TYPE;

Line 466: l_status as_leads_all.status%TYPE;

462:
463: --l_interest_type as_interest_types_tl.interest_type%TYPE;
464: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
465: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
466: l_status as_leads_all.status%TYPE;
467: l_lead_total_amount as_leads_all.total_amount%TYPE;
468: l_decision_date as_leads_all.decision_date%TYPE;
469: l_currency_code AS_LEADS_ALL.currency_code%TYPE;
470: l_total_amount NUMBER;

Line 467: l_lead_total_amount as_leads_all.total_amount%TYPE;

463: --l_interest_type as_interest_types_tl.interest_type%TYPE;
464: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
465: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
466: l_status as_leads_all.status%TYPE;
467: l_lead_total_amount as_leads_all.total_amount%TYPE;
468: l_decision_date as_leads_all.decision_date%TYPE;
469: l_currency_code AS_LEADS_ALL.currency_code%TYPE;
470: l_total_amount NUMBER;
471: l_sc_amount NUMBER;

Line 468: l_decision_date as_leads_all.decision_date%TYPE;

464: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
465: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
466: l_status as_leads_all.status%TYPE;
467: l_lead_total_amount as_leads_all.total_amount%TYPE;
468: l_decision_date as_leads_all.decision_date%TYPE;
469: l_currency_code AS_LEADS_ALL.currency_code%TYPE;
470: l_total_amount NUMBER;
471: l_sc_amount NUMBER;
472: l_won_amount NUMBER;

Line 469: l_currency_code AS_LEADS_ALL.currency_code%TYPE;

465: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
466: l_status as_leads_all.status%TYPE;
467: l_lead_total_amount as_leads_all.total_amount%TYPE;
468: l_decision_date as_leads_all.decision_date%TYPE;
469: l_currency_code AS_LEADS_ALL.currency_code%TYPE;
470: l_total_amount NUMBER;
471: l_sc_amount NUMBER;
472: l_won_amount NUMBER;
473: l_weighted_amount NUMBER;

Line 493: From as_leads_all lead, as_statuses_vl status

489: If p_trigger_mode = 'ON-UPDATE' then
490: Begin
491: Select lead.total_amount , trunc(lead.decision_date) decision_date, lead.currency_code, lead.win_probability, status.win_loss_indicator
492: Into l_lead_total_amount, l_decision_date, l_currency_code, l_win_probability, l_status
493: From as_leads_all lead, as_statuses_vl status
494: Where lead_id = p_new_lead_id
495: And lead.status = status.status_code(+);
496:
497: If p_new_frcst_date IS NULL THEN

Line 663: l_org_id as_leads_all.org_id%TYPE;

659: l_sales_rep_name jtf_rs_resource_extns.source_name%TYPE;
660: l_first_name jtf_rs_resource_extns.source_first_name%TYPE;
661: l_last_name jtf_rs_resource_extns.source_last_name%TYPE;
662: l_employee_number jtf_rs_resource_extns.source_number%TYPE;
663: l_org_id as_leads_all.org_id%TYPE;
664: --l_interest_type as_interest_types_tl.interest_type%TYPE;
665: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
666: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
667: l_customer_id as_leads_all.customer_id%TYPE;

Line 667: l_customer_id as_leads_all.customer_id%TYPE;

663: l_org_id as_leads_all.org_id%TYPE;
664: --l_interest_type as_interest_types_tl.interest_type%TYPE;
665: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
666: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
667: l_customer_id as_leads_all.customer_id%TYPE;
668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
669: l_party_type as_party_customers_v.party_type%TYPE;
670: l_address_id as_leads_all.address_id%TYPE;
671: l_lead_number as_leads_all.lead_number%TYPE;

Line 670: l_address_id as_leads_all.address_id%TYPE;

666: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
667: l_customer_id as_leads_all.customer_id%TYPE;
668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
669: l_party_type as_party_customers_v.party_type%TYPE;
670: l_address_id as_leads_all.address_id%TYPE;
671: l_lead_number as_leads_all.lead_number%TYPE;
672: l_opp_description as_leads_all.description%TYPE;
673: l_decision_date as_leads_all.decision_date%TYPE;
674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;

Line 671: l_lead_number as_leads_all.lead_number%TYPE;

667: l_customer_id as_leads_all.customer_id%TYPE;
668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
669: l_party_type as_party_customers_v.party_type%TYPE;
670: l_address_id as_leads_all.address_id%TYPE;
671: l_lead_number as_leads_all.lead_number%TYPE;
672: l_opp_description as_leads_all.description%TYPE;
673: l_decision_date as_leads_all.decision_date%TYPE;
674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;
675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;

Line 672: l_opp_description as_leads_all.description%TYPE;

668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
669: l_party_type as_party_customers_v.party_type%TYPE;
670: l_address_id as_leads_all.address_id%TYPE;
671: l_lead_number as_leads_all.lead_number%TYPE;
672: l_opp_description as_leads_all.description%TYPE;
673: l_decision_date as_leads_all.decision_date%TYPE;
674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;
675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;
676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;

Line 673: l_decision_date as_leads_all.decision_date%TYPE;

669: l_party_type as_party_customers_v.party_type%TYPE;
670: l_address_id as_leads_all.address_id%TYPE;
671: l_lead_number as_leads_all.lead_number%TYPE;
672: l_opp_description as_leads_all.description%TYPE;
673: l_decision_date as_leads_all.decision_date%TYPE;
674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;
675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;
676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;
677: l_owner_salesforce_id as_leads_all.owner_salesforce_id%TYPE;

Line 674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;

670: l_address_id as_leads_all.address_id%TYPE;
671: l_lead_number as_leads_all.lead_number%TYPE;
672: l_opp_description as_leads_all.description%TYPE;
673: l_decision_date as_leads_all.decision_date%TYPE;
674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;
675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;
676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;
677: l_owner_salesforce_id as_leads_all.owner_salesforce_id%TYPE;
678: l_owner_sales_group_id as_leads_all.owner_sales_group_id%TYPE;

Line 675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;

671: l_lead_number as_leads_all.lead_number%TYPE;
672: l_opp_description as_leads_all.description%TYPE;
673: l_decision_date as_leads_all.decision_date%TYPE;
674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;
675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;
676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;
677: l_owner_salesforce_id as_leads_all.owner_salesforce_id%TYPE;
678: l_owner_sales_group_id as_leads_all.owner_sales_group_id%TYPE;
679: l_competitor_name hz_parties.party_name%TYPE;

Line 676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;

672: l_opp_description as_leads_all.description%TYPE;
673: l_decision_date as_leads_all.decision_date%TYPE;
674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;
675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;
676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;
677: l_owner_salesforce_id as_leads_all.owner_salesforce_id%TYPE;
678: l_owner_sales_group_id as_leads_all.owner_sales_group_id%TYPE;
679: l_competitor_name hz_parties.party_name%TYPE;
680: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;

Line 677: l_owner_salesforce_id as_leads_all.owner_salesforce_id%TYPE;

673: l_decision_date as_leads_all.decision_date%TYPE;
674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;
675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;
676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;
677: l_owner_salesforce_id as_leads_all.owner_salesforce_id%TYPE;
678: l_owner_sales_group_id as_leads_all.owner_sales_group_id%TYPE;
679: l_competitor_name hz_parties.party_name%TYPE;
680: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
681: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;

Line 678: l_owner_sales_group_id as_leads_all.owner_sales_group_id%TYPE;

674: l_sales_stage_id as_leads_all.sales_stage_id%TYPE;
675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;
676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;
677: l_owner_salesforce_id as_leads_all.owner_salesforce_id%TYPE;
678: l_owner_sales_group_id as_leads_all.owner_sales_group_id%TYPE;
679: l_competitor_name hz_parties.party_name%TYPE;
680: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
681: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
682: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;

Line 685: l_win_probability as_leads_all.win_probability%TYPE;

681: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
682: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
683: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
684: l_sales_stage as_sales_stages.name%TYPE;
685: l_win_probability as_leads_all.win_probability%TYPE;
686: l_status_code as_leads_all.status%TYPE;
687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;
688: l_status as_statuses_tl.meaning%TYPE;
689: l_channel_code as_leads_all.channel_code%TYPE;

Line 686: l_status_code as_leads_all.status%TYPE;

682: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
683: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
684: l_sales_stage as_sales_stages.name%TYPE;
685: l_win_probability as_leads_all.win_probability%TYPE;
686: l_status_code as_leads_all.status%TYPE;
687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;
688: l_status as_statuses_tl.meaning%TYPE;
689: l_channel_code as_leads_all.channel_code%TYPE;
690: l_lead_source_code as_leads_all.lead_source_code%TYPE;

Line 687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;

683: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
684: l_sales_stage as_sales_stages.name%TYPE;
685: l_win_probability as_leads_all.win_probability%TYPE;
686: l_status_code as_leads_all.status%TYPE;
687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;
688: l_status as_statuses_tl.meaning%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;

Line 689: l_channel_code as_leads_all.channel_code%TYPE;

685: l_win_probability as_leads_all.win_probability%TYPE;
686: l_status_code as_leads_all.status%TYPE;
687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;
688: l_status as_statuses_tl.meaning%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;

Line 690: l_lead_source_code as_leads_all.lead_source_code%TYPE;

686: l_status_code as_leads_all.status%TYPE;
687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;
688: l_status as_statuses_tl.meaning%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;

Line 691: l_deleted_flag as_leads_all.deleted_flag%Type;

687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;
688: l_status as_statuses_tl.meaning%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;

Line 692: l_orig_system_reference as_leads_all.orig_system_reference%TYPE;

688: l_status as_statuses_tl.meaning%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;

Line 699: l_currency_code as_leads_all.currency_code%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;
703: l_lead_total_amount as_leads_all.total_amount%TYPE;

Line 703: l_lead_total_amount as_leads_all.total_amount%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;
707: l_weighted_amount NUMBER;

Line 723: l_parent_project as_leads_all.parent_project%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;
725: l_business_group_name hr_all_organization_units_tl.name%Type;
726: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
727:

Line 826: From as_leads_all

822: as_sc_denorm.scd_attribute13(1),
823: as_sc_denorm.scd_attribute14(1),
824: as_sc_denorm.scd_attribute15(1),
825: l_sales_methodology_id
826: From as_leads_all
827: Where lead_id = p_new_lead_id;
828:
829: Begin
830: Select group_name

Line 873: From hz_parties cust, as_leads_all lead

869:
870: Begin
871: Select party_name, party_type, category_code
872: Into l_customer_name, l_party_type, l_customer_category_code
873: From hz_parties cust, as_leads_all lead
874: Where lead.customer_id = cust.party_id
875: And lead.lead_id = p_new_lead_id;
876: Exception When Others then
877: l_customer_name := Null;

Line 960: From as_sales_stages_all_tl sales, as_leads_all lead

956:
957: Begin
958: Select name
959: Into l_sales_stage
960: From as_sales_stages_all_tl sales, as_leads_all lead
961: Where sales.sales_stage_id = lead.sales_stage_id
962: And lead.lead_id = p_new_lead_id
963: And sales.language = userenv('LANG');
964: Exception When Others then

Line 972: as_leads_all lead

968: Begin
969: Select meaning, win_loss_indicator, forecast_rollup_flag, opp_open_status_flag
970: Into l_status, l_win_loss_indicator, l_forecast_rollup_flag, l_opp_open_status_flag
971: From as_statuses_vl status,
972: as_leads_all lead
973: Where lead.status = status.status_code
974: --And status.language = userenv('LANG')
975: And lead.lead_id = p_new_lead_id;
976: Exception When Others then