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_SALES_CREDITS

Line 121: p_new_attr_category IN as_sales_credits_denorm.attribute_category%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,
125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,

Line 122: p_new_attr1 IN as_sales_credits_denorm.attribute1%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,
125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,

Line 123: p_new_attr2 IN as_sales_credits_denorm.attribute1%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,
125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,

Line 124: p_new_attr3 IN as_sales_credits_denorm.attribute1%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,
125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,

Line 125: p_new_attr4 IN as_sales_credits_denorm.attribute1%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,
125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,

Line 126: p_new_attr5 IN as_sales_credits_denorm.attribute1%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,
125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,

Line 127: p_new_attr6 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,
125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,

Line 128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,

124: p_new_attr3 IN as_sales_credits_denorm.attribute1%type,
125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,

Line 129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,

125: p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,

Line 130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,

126: p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,

Line 131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,

127: p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,
135: p_new_attr14 IN as_sales_credits_denorm.attribute1%type,

Line 132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,

128: p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,
135: p_new_attr14 IN as_sales_credits_denorm.attribute1%type,
136: p_new_attr15 IN as_sales_credits_denorm.attribute1%type,

Line 133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,

129: p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,
135: p_new_attr14 IN as_sales_credits_denorm.attribute1%type,
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,

Line 134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,

130: p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,
135: p_new_attr14 IN as_sales_credits_denorm.attribute1%type,
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

Line 135: p_new_attr14 IN as_sales_credits_denorm.attribute1%type,

131: p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,
135: p_new_attr14 IN as_sales_credits_denorm.attribute1%type,
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:

Line 136: p_new_attr15 IN as_sales_credits_denorm.attribute1%type,

132: p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,
135: p_new_attr14 IN as_sales_credits_denorm.attribute1%type,
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

Line 137: p_new_sales_methodology_id IN as_sales_credits_denorm.sales_methodology_id%type,

133: p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
134: p_new_attr13 IN as_sales_credits_denorm.attribute1%type,
135: p_new_attr14 IN as_sales_credits_denorm.attribute1%type,
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

Line 142: From as_sales_credits_denorm

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:
145: CURSOR c_no_line_forecasts (p_lead_id as_leads_all.lead_id%type) IS
146: Select lead_line_id

Line 298: Update as_sales_credits_denorm

294: Begin
295: l_total_amount := p_new_total_amount;
296: convert_amounts(p_new_currency_code, trunc(nvl(p_new_decision_date,p_new_creation_date)), l_total_amount,l_sc_amount,l_converted_won_amount,l_converted_weighted_amount, l_conversion_status_flag);
297:
298: Update as_sales_credits_denorm
299: Set object_version_number = nvl(object_version_number,0) + 1, opportunity_last_update_date = p_new_last_update_date
300: ,opportunity_last_updated_by = p_new_last_updated_by
301: ,last_update_date = SYSDATE
302: ,last_updated_by = p_new_last_updated_by

Line 388: Update as_sales_credits_denorm

384: l_converted_won_amount := l_won_amount;
385: End If;
386: convert_amounts(p_new_currency_code, trunc(nvl(p_new_decision_date,p_new_creation_date)), l_total_amount,l_sc_amount,l_converted_won_amount,l_converted_weighted_amount, l_conversion_status_flag);
387:
388: Update as_sales_credits_denorm
389: Set object_version_number = nvl(object_version_number,0) + 1, c1_sales_credit_amount = l_sc_amount,
390: won_amount = l_won_amount,
391: weighted_amount = l_weighted_amount,
392: c1_won_amount = l_converted_won_amount,

Line 404: Update as_sales_credits_denorm

400: -- Update denorm table forecast_dates to the new value where there
401: -- is no line forecast date.
402: If p_new_decision_date <> p_old_decision_date Then
403: For curr_rec_nofrcst IN c_no_line_forecasts (p_new_lead_id) Loop
404: Update as_sales_credits_denorm
405: Set object_version_number = nvl(object_version_number,0) + 1,
406: forecast_date = trunc(p_new_decision_date)
407: Where lead_line_id = curr_rec_nofrcst.lead_line_id;
408: End Loop;

Line 412: Delete as_sales_credits_denorm

408: End Loop;
409: End If;
410: Elsif p_trigger_mode = 'ON-DELETE' then
411: Begin
412: Delete as_sales_credits_denorm
413: Where lead_id = p_old_lead_id;
414: End;
415: End If;
416: Exception

Line 460: From as_sales_credits

456: p_trigger_mode IN VARCHAR2) IS
457:
458: Cursor c_sales_credit_amount (p_lead_line_id as_lead_lines_all.lead_id%type) IS
459: Select sales_credit_id, credit_amount, credit_percent
460: From as_sales_credits
461: Where lead_line_id = p_lead_line_id;
462:
463: --l_interest_type as_interest_types_tl.interest_type%TYPE;
464: --l_primary_interest_code as_interest_codes_tl.code%TYPE;

Line 479: l_uom_description as_sales_credits_denorm.uom_description%type;

475: l_converted_weighted_amount NUMBER;
476: l_conversion_status_flag NUMBER;
477: l_sales_credit_amount NUMBER;
478: l_win_probability NUMBER;
479: l_uom_description as_sales_credits_denorm.uom_description%type;
480: l_item_description as_sales_credits_denorm.item_description%type;
481: l_new_frcst_date as_lead_lines_all.forecast_date%type;
482: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
483:

Line 480: l_item_description as_sales_credits_denorm.item_description%type;

476: l_conversion_status_flag NUMBER;
477: l_sales_credit_amount NUMBER;
478: l_win_probability NUMBER;
479: l_uom_description as_sales_credits_denorm.uom_description%type;
480: l_item_description as_sales_credits_denorm.item_description%type;
481: l_new_frcst_date as_lead_lines_all.forecast_date%type;
482: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
483:
484: Begin

Line 530: Update as_sales_credits_denorm

526: ,p_new_sec_interest_code_id, l_secondary_interest_code);
527: */
528:
529: If ((p_new_total_amount = p_old_total_amount) and (nvl(p_old_frcst_date,to_date('01/01/1900','DD/MM/RRRR')) = nvl(p_new_frcst_date,to_date('01/01/1900','DD/MM/RRRR'))) and (nvl(p_old_rolling_frcst_flg,'#') = nvl(p_new_rolling_frcst_flg,'#'))) then
530: Update as_sales_credits_denorm
531: Set object_version_number = nvl(object_version_number,0) + 1, last_update_date = SYSDATE
532: ,last_updated_by = NVL(FND_GLOBAL.login_id,-1)
533: ,creation_date = SYSDATE
534: ,created_by = p_new_created_by

Line 576: Update as_sales_credits_denorm

572: l_won_amount := l_sc_amount;
573: l_converted_won_amount := l_won_amount;
574: End If;
575: convert_amounts(l_currency_code, trunc(nvl(l_decision_date,p_new_creation_date)), l_total_amount,l_sc_amount,l_converted_won_amount,l_converted_weighted_amount, l_conversion_status_flag);
576: Update as_sales_credits_denorm
577: Set object_version_number = nvl(object_version_number,0) + 1, last_update_date = sysdate
578: ,last_updated_by = NVL(FND_GLOBAL.login_id,-1)
579: ,creation_date = sysdate
580: ,created_by = p_new_created_by

Line 611: Delete as_sales_credits_denorm

607: End Loop; -- c_sales_credit_amount Loop
608: End If;
609: End;
610: Elsif p_trigger_mode = 'ON-DELETE' then
611: Delete as_sales_credits_denorm
612: Where lead_line_id = p_old_lead_line_id;
613: End If;
614:
615: Exception

Line 718: l_uom_description as_sales_credits_denorm.uom_description%Type;

714: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
715: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
716: l_quantity as_lead_lines.quantity%Type;
717: l_uom_code as_lead_lines.uom_code%Type;
718: l_uom_description as_sales_credits_denorm.uom_description%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;

Line 721: l_item_description as_sales_credits_denorm.item_description%Type;

717: l_uom_code as_lead_lines.uom_code%Type;
718: l_uom_description as_sales_credits_denorm.uom_description%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;

Line 735: Delete From as_sales_credits_denorm

731: END IF;
732:
733: If (p_Trigger_Mode = 'ON-DELETE') then
734: Begin
735: Delete From as_sales_credits_denorm
736: Where sales_credit_id = p_old_sales_credit_id;
737: Return;
738: End;
739: End If;

Line 1064: Update as_sales_credits_denorm

1060: l_converted_won_amount := l_won_amount;
1061: End If;
1062: convert_amounts(l_currency_code, trunc(nvl(l_decision_date,p_new_creation_date)), l_total_amount,l_sc_amount,l_converted_won_amount,l_converted_weighted_amount, l_conversion_status_flag);
1063: If p_Trigger_Mode = 'ON-UPDATE' then
1064: Update as_sales_credits_denorm
1065: Set object_version_number = nvl(object_version_number,0) + 1, sales_credit_id = p_new_sales_credit_id
1066: ,opportunity_last_update_date = as_sc_denorm.scd_opp_last_upd_date(1)
1067: ,opportunity_last_updated_by = as_sc_denorm.scd_opp_last_upd_by(1)
1068: ,last_update_date = sysdate

Line 1183: Insert Into as_sales_credits_denorm

1179: End If;
1180: End If;
1181:
1182: If p_Trigger_Mode = 'ON-INSERT' then
1183: Insert Into as_sales_credits_denorm
1184: (sales_credit_id
1185: ,opportunity_last_update_date
1186: ,opportunity_last_updated_by
1187: ,last_update_date