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_SC_DENORM

Line 1: Package body AS_SC_DENORM_TRG AS

1: Package body AS_SC_DENORM_TRG AS
2: /* $Header: asxopdtb.pls 120.1.12010000.3 2008/09/22 09:18:48 dkailash ship $ */
3:
4: --
5: -- HISTORY

Line 240: Into as_sc_denorm.scd_close_reason_men(1)

236: End;
237:
238: Begin
239: Select meaning
240: Into as_sc_denorm.scd_close_reason_men(1)
241: From as_lookups aslkp
242: Where aslkp.lookup_type = 'CLOSE_REASON'
243: And aslkp.lookup_code = p_new_close_reason;
244: Exception

Line 246: as_sc_denorm.scd_close_reason_men(1) := NULL;

242: Where aslkp.lookup_type = 'CLOSE_REASON'
243: And aslkp.lookup_code = p_new_close_reason;
244: Exception
245: When others then
246: as_sc_denorm.scd_close_reason_men(1) := NULL;
247: End;
248:
249: Begin
250: Select source_name

Line 251: Into as_sc_denorm.scd_opp_created_name(1)

247: End;
248:
249: Begin
250: Select source_name
251: Into as_sc_denorm.scd_opp_created_name(1)
252: From jtf_rs_resource_extns
253: Where user_id = p_new_created_by;
254: Exception
255: When Others then

Line 256: as_sc_denorm.scd_opp_created_name(1) := Null;

252: From jtf_rs_resource_extns
253: Where user_id = p_new_created_by;
254: Exception
255: When Others then
256: as_sc_denorm.scd_opp_created_name(1) := Null;
257: End;
258:
259: Begin
260: Select source_name

Line 261: Into as_sc_denorm.scd_opp_last_upd_name(1)

257: End;
258:
259: Begin
260: Select source_name
261: Into as_sc_denorm.scd_opp_last_upd_name(1)
262: From jtf_rs_resource_extns
263: Where user_id = p_new_last_updated_by;
264: Exception
265: When Others then

Line 266: as_sc_denorm.scd_opp_last_upd_name(1) := Null;

262: From jtf_rs_resource_extns
263: Where user_id = p_new_last_updated_by;
264: Exception
265: When Others then
266: as_sc_denorm.scd_opp_last_upd_name(1) := Null;
267: End;
268:
269: Begin
270: Select name

Line 362: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)

358: ,attribute13 = p_new_attr13
359: ,attribute14 = p_new_attr14
360: ,attribute15 = p_new_attr15
361: ,close_reason = p_new_close_reason
362: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
363: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
364: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
365: ,opportunity_created_by = p_new_created_by
366: ,opportunity_creation_date = p_new_creation_date

Line 363: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)

359: ,attribute14 = p_new_attr14
360: ,attribute15 = p_new_attr15
361: ,close_reason = p_new_close_reason
362: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
363: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
364: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
365: ,opportunity_created_by = p_new_created_by
366: ,opportunity_creation_date = p_new_creation_date
367: ,sales_methodology_id = p_new_sales_methodology_id

Line 364: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)

360: ,attribute15 = p_new_attr15
361: ,close_reason = p_new_close_reason
362: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
363: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
364: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
365: ,opportunity_created_by = p_new_created_by
366: ,opportunity_creation_date = p_new_creation_date
367: ,sales_methodology_id = p_new_sales_methodology_id
368: Where lead_id = p_old_lead_id;

Line 422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');

418: IF l_debug THEN
419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, 'Error in Leads Trg:' || sqlerrm);
420: END IF;
421:
422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: When Others then
425: IF l_debug THEN
426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 429: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');

425: IF l_debug THEN
426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
427: 'Error in Leads Trg:' || sqlerrm);
428: END IF;
429: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');
430: End Leads_Trigger_Handler;
431:
432: Procedure Lead_Lines_Trigger_Handler(
433: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,

Line 622: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');

618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
619: 'Error in Lead Lines Trg:' || sqlerrm);
620: END IF;
621:
622: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: When Others then
625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 630: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');

626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
627: 'Error in Lead Lines Trg:' || sqlerrm);
628: END IF;
629:
630: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');
631: End Lead_Lines_Trigger_Handler;
632:
633: Procedure Sales_Credit_Trg_Handler(
634: p_new_sales_credit_id IN NUMBER,

Line 804: as_sc_denorm.scd_opp_last_upd_date(1),

800: l_lead_total_amount,
801: l_org_id,
802: l_deleted_flag,
803: l_parent_project,
804: as_sc_denorm.scd_opp_last_upd_date(1),
805: as_sc_denorm.scd_opp_last_upd_by(1),
806: as_sc_denorm.scd_opp_creation_date(1),
807: as_sc_denorm.scd_opp_created_by(1),
808: as_sc_denorm.scd_close_reason(1),

Line 805: as_sc_denorm.scd_opp_last_upd_by(1),

801: l_org_id,
802: l_deleted_flag,
803: l_parent_project,
804: as_sc_denorm.scd_opp_last_upd_date(1),
805: as_sc_denorm.scd_opp_last_upd_by(1),
806: as_sc_denorm.scd_opp_creation_date(1),
807: as_sc_denorm.scd_opp_created_by(1),
808: as_sc_denorm.scd_close_reason(1),
809: as_sc_denorm.scd_attribute_category(1),

Line 806: as_sc_denorm.scd_opp_creation_date(1),

802: l_deleted_flag,
803: l_parent_project,
804: as_sc_denorm.scd_opp_last_upd_date(1),
805: as_sc_denorm.scd_opp_last_upd_by(1),
806: as_sc_denorm.scd_opp_creation_date(1),
807: as_sc_denorm.scd_opp_created_by(1),
808: as_sc_denorm.scd_close_reason(1),
809: as_sc_denorm.scd_attribute_category(1),
810: as_sc_denorm.scd_attribute1(1),

Line 807: as_sc_denorm.scd_opp_created_by(1),

803: l_parent_project,
804: as_sc_denorm.scd_opp_last_upd_date(1),
805: as_sc_denorm.scd_opp_last_upd_by(1),
806: as_sc_denorm.scd_opp_creation_date(1),
807: as_sc_denorm.scd_opp_created_by(1),
808: as_sc_denorm.scd_close_reason(1),
809: as_sc_denorm.scd_attribute_category(1),
810: as_sc_denorm.scd_attribute1(1),
811: as_sc_denorm.scd_attribute2(1),

Line 808: as_sc_denorm.scd_close_reason(1),

804: as_sc_denorm.scd_opp_last_upd_date(1),
805: as_sc_denorm.scd_opp_last_upd_by(1),
806: as_sc_denorm.scd_opp_creation_date(1),
807: as_sc_denorm.scd_opp_created_by(1),
808: as_sc_denorm.scd_close_reason(1),
809: as_sc_denorm.scd_attribute_category(1),
810: as_sc_denorm.scd_attribute1(1),
811: as_sc_denorm.scd_attribute2(1),
812: as_sc_denorm.scd_attribute3(1),

Line 809: as_sc_denorm.scd_attribute_category(1),

805: as_sc_denorm.scd_opp_last_upd_by(1),
806: as_sc_denorm.scd_opp_creation_date(1),
807: as_sc_denorm.scd_opp_created_by(1),
808: as_sc_denorm.scd_close_reason(1),
809: as_sc_denorm.scd_attribute_category(1),
810: as_sc_denorm.scd_attribute1(1),
811: as_sc_denorm.scd_attribute2(1),
812: as_sc_denorm.scd_attribute3(1),
813: as_sc_denorm.scd_attribute4(1),

Line 810: as_sc_denorm.scd_attribute1(1),

806: as_sc_denorm.scd_opp_creation_date(1),
807: as_sc_denorm.scd_opp_created_by(1),
808: as_sc_denorm.scd_close_reason(1),
809: as_sc_denorm.scd_attribute_category(1),
810: as_sc_denorm.scd_attribute1(1),
811: as_sc_denorm.scd_attribute2(1),
812: as_sc_denorm.scd_attribute3(1),
813: as_sc_denorm.scd_attribute4(1),
814: as_sc_denorm.scd_attribute5(1),

Line 811: as_sc_denorm.scd_attribute2(1),

807: as_sc_denorm.scd_opp_created_by(1),
808: as_sc_denorm.scd_close_reason(1),
809: as_sc_denorm.scd_attribute_category(1),
810: as_sc_denorm.scd_attribute1(1),
811: as_sc_denorm.scd_attribute2(1),
812: as_sc_denorm.scd_attribute3(1),
813: as_sc_denorm.scd_attribute4(1),
814: as_sc_denorm.scd_attribute5(1),
815: as_sc_denorm.scd_attribute6(1),

Line 812: as_sc_denorm.scd_attribute3(1),

808: as_sc_denorm.scd_close_reason(1),
809: as_sc_denorm.scd_attribute_category(1),
810: as_sc_denorm.scd_attribute1(1),
811: as_sc_denorm.scd_attribute2(1),
812: as_sc_denorm.scd_attribute3(1),
813: as_sc_denorm.scd_attribute4(1),
814: as_sc_denorm.scd_attribute5(1),
815: as_sc_denorm.scd_attribute6(1),
816: as_sc_denorm.scd_attribute7(1),

Line 813: as_sc_denorm.scd_attribute4(1),

809: as_sc_denorm.scd_attribute_category(1),
810: as_sc_denorm.scd_attribute1(1),
811: as_sc_denorm.scd_attribute2(1),
812: as_sc_denorm.scd_attribute3(1),
813: as_sc_denorm.scd_attribute4(1),
814: as_sc_denorm.scd_attribute5(1),
815: as_sc_denorm.scd_attribute6(1),
816: as_sc_denorm.scd_attribute7(1),
817: as_sc_denorm.scd_attribute8(1),

Line 814: as_sc_denorm.scd_attribute5(1),

810: as_sc_denorm.scd_attribute1(1),
811: as_sc_denorm.scd_attribute2(1),
812: as_sc_denorm.scd_attribute3(1),
813: as_sc_denorm.scd_attribute4(1),
814: as_sc_denorm.scd_attribute5(1),
815: as_sc_denorm.scd_attribute6(1),
816: as_sc_denorm.scd_attribute7(1),
817: as_sc_denorm.scd_attribute8(1),
818: as_sc_denorm.scd_attribute9(1),

Line 815: as_sc_denorm.scd_attribute6(1),

811: as_sc_denorm.scd_attribute2(1),
812: as_sc_denorm.scd_attribute3(1),
813: as_sc_denorm.scd_attribute4(1),
814: as_sc_denorm.scd_attribute5(1),
815: as_sc_denorm.scd_attribute6(1),
816: as_sc_denorm.scd_attribute7(1),
817: as_sc_denorm.scd_attribute8(1),
818: as_sc_denorm.scd_attribute9(1),
819: as_sc_denorm.scd_attribute10(1),

Line 816: as_sc_denorm.scd_attribute7(1),

812: as_sc_denorm.scd_attribute3(1),
813: as_sc_denorm.scd_attribute4(1),
814: as_sc_denorm.scd_attribute5(1),
815: as_sc_denorm.scd_attribute6(1),
816: as_sc_denorm.scd_attribute7(1),
817: as_sc_denorm.scd_attribute8(1),
818: as_sc_denorm.scd_attribute9(1),
819: as_sc_denorm.scd_attribute10(1),
820: as_sc_denorm.scd_attribute11(1),

Line 817: as_sc_denorm.scd_attribute8(1),

813: as_sc_denorm.scd_attribute4(1),
814: as_sc_denorm.scd_attribute5(1),
815: as_sc_denorm.scd_attribute6(1),
816: as_sc_denorm.scd_attribute7(1),
817: as_sc_denorm.scd_attribute8(1),
818: as_sc_denorm.scd_attribute9(1),
819: as_sc_denorm.scd_attribute10(1),
820: as_sc_denorm.scd_attribute11(1),
821: as_sc_denorm.scd_attribute12(1),

Line 818: as_sc_denorm.scd_attribute9(1),

814: as_sc_denorm.scd_attribute5(1),
815: as_sc_denorm.scd_attribute6(1),
816: as_sc_denorm.scd_attribute7(1),
817: as_sc_denorm.scd_attribute8(1),
818: as_sc_denorm.scd_attribute9(1),
819: as_sc_denorm.scd_attribute10(1),
820: as_sc_denorm.scd_attribute11(1),
821: as_sc_denorm.scd_attribute12(1),
822: as_sc_denorm.scd_attribute13(1),

Line 819: as_sc_denorm.scd_attribute10(1),

815: as_sc_denorm.scd_attribute6(1),
816: as_sc_denorm.scd_attribute7(1),
817: as_sc_denorm.scd_attribute8(1),
818: as_sc_denorm.scd_attribute9(1),
819: as_sc_denorm.scd_attribute10(1),
820: as_sc_denorm.scd_attribute11(1),
821: as_sc_denorm.scd_attribute12(1),
822: as_sc_denorm.scd_attribute13(1),
823: as_sc_denorm.scd_attribute14(1),

Line 820: as_sc_denorm.scd_attribute11(1),

816: as_sc_denorm.scd_attribute7(1),
817: as_sc_denorm.scd_attribute8(1),
818: as_sc_denorm.scd_attribute9(1),
819: as_sc_denorm.scd_attribute10(1),
820: as_sc_denorm.scd_attribute11(1),
821: as_sc_denorm.scd_attribute12(1),
822: as_sc_denorm.scd_attribute13(1),
823: as_sc_denorm.scd_attribute14(1),
824: as_sc_denorm.scd_attribute15(1),

Line 821: as_sc_denorm.scd_attribute12(1),

817: as_sc_denorm.scd_attribute8(1),
818: as_sc_denorm.scd_attribute9(1),
819: as_sc_denorm.scd_attribute10(1),
820: as_sc_denorm.scd_attribute11(1),
821: as_sc_denorm.scd_attribute12(1),
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

Line 822: as_sc_denorm.scd_attribute13(1),

818: as_sc_denorm.scd_attribute9(1),
819: as_sc_denorm.scd_attribute10(1),
820: as_sc_denorm.scd_attribute11(1),
821: as_sc_denorm.scd_attribute12(1),
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

Line 823: as_sc_denorm.scd_attribute14(1),

819: as_sc_denorm.scd_attribute10(1),
820: as_sc_denorm.scd_attribute11(1),
821: as_sc_denorm.scd_attribute12(1),
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;

Line 824: as_sc_denorm.scd_attribute15(1),

820: as_sc_denorm.scd_attribute11(1),
821: as_sc_denorm.scd_attribute12(1),
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:

Line 928: Into as_sc_denorm.scd_close_reason_men(1)

924:
925:
926: Begin
927: Select meaning
928: Into as_sc_denorm.scd_close_reason_men(1)
929: From as_lookups aslkp
930: Where aslkp.lookup_type = 'CLOSE_REASON'
931: And aslkp.lookup_code = as_sc_denorm.scd_close_reason(1);
932: Exception

Line 931: And aslkp.lookup_code = as_sc_denorm.scd_close_reason(1);

927: Select meaning
928: Into as_sc_denorm.scd_close_reason_men(1)
929: From as_lookups aslkp
930: Where aslkp.lookup_type = 'CLOSE_REASON'
931: And aslkp.lookup_code = as_sc_denorm.scd_close_reason(1);
932: Exception
933: When others then
934: as_sc_denorm.scd_close_reason_men(1) := NULL;
935: End;

Line 934: as_sc_denorm.scd_close_reason_men(1) := NULL;

930: Where aslkp.lookup_type = 'CLOSE_REASON'
931: And aslkp.lookup_code = as_sc_denorm.scd_close_reason(1);
932: Exception
933: When others then
934: as_sc_denorm.scd_close_reason_men(1) := NULL;
935: End;
936:
937: Begin
938: Select source_name

Line 939: Into as_sc_denorm.scd_opp_created_name(1)

935: End;
936:
937: Begin
938: Select source_name
939: Into as_sc_denorm.scd_opp_created_name(1)
940: From jtf_rs_resource_extns
941: Where user_id = as_sc_denorm.scd_opp_created_by(1);
942: Exception
943: When Others then

Line 941: Where user_id = as_sc_denorm.scd_opp_created_by(1);

937: Begin
938: Select source_name
939: Into as_sc_denorm.scd_opp_created_name(1)
940: From jtf_rs_resource_extns
941: Where user_id = as_sc_denorm.scd_opp_created_by(1);
942: Exception
943: When Others then
944: as_sc_denorm.scd_opp_created_name(1) := Null;
945: End;

Line 944: as_sc_denorm.scd_opp_created_name(1) := Null;

940: From jtf_rs_resource_extns
941: Where user_id = as_sc_denorm.scd_opp_created_by(1);
942: Exception
943: When Others then
944: as_sc_denorm.scd_opp_created_name(1) := Null;
945: End;
946:
947: Begin
948: Select source_name

Line 949: Into as_sc_denorm.scd_opp_last_upd_name(1)

945: End;
946:
947: Begin
948: Select source_name
949: Into as_sc_denorm.scd_opp_last_upd_name(1)
950: From jtf_rs_resource_extns
951: Where user_id = as_sc_denorm.scd_opp_last_upd_by(1);
952: Exception
953: When Others then

Line 951: Where user_id = as_sc_denorm.scd_opp_last_upd_by(1);

947: Begin
948: Select source_name
949: Into as_sc_denorm.scd_opp_last_upd_name(1)
950: From jtf_rs_resource_extns
951: Where user_id = as_sc_denorm.scd_opp_last_upd_by(1);
952: Exception
953: When Others then
954: as_sc_denorm.scd_opp_last_upd_name(1) := Null;
955: End;

Line 954: as_sc_denorm.scd_opp_last_upd_name(1) := Null;

950: From jtf_rs_resource_extns
951: Where user_id = as_sc_denorm.scd_opp_last_upd_by(1);
952: Exception
953: When Others then
954: as_sc_denorm.scd_opp_last_upd_name(1) := Null;
955: End;
956:
957: Begin
958: Select name

Line 990: l_secondary_interest_code_id, l_product_category_id, l_product_cat_set_id, l_leadline_total_amount, l_quantity, l_uom_code, l_item_id, l_organization_id, as_sc_denorm.scd_frcst_date(1), as_sc_denorm.scd_rolling_frcst_flg(1)

986: nvl(secondary_interest_code_id,-1),
987: nvl(product_category_id, -1), nvl(product_cat_set_id, -1),
988: total_amount, quantity, uom_code, inventory_item_id, organization_id, trunc(nvl(forecast_date, l_decision_date)), rolling_forecast_flag
989: Into l_lead_line_id, l_interest_type_id, l_primary_interest_code_id,
990: l_secondary_interest_code_id, l_product_category_id, l_product_cat_set_id, l_leadline_total_amount, l_quantity, l_uom_code, l_item_id, l_organization_id, as_sc_denorm.scd_frcst_date(1), as_sc_denorm.scd_rolling_frcst_flg(1)
991: From as_lead_lines_all
992: Where lead_id = p_new_lead_id
993: And lead_line_id = p_new_lead_line_id;
994: Exception When Others then

Line 1006: as_sc_denorm.scd_frcst_date(1) := l_decision_date;

1002: l_quantity := Null;
1003: l_uom_code := Null;
1004: l_item_id := Null;
1005: l_organization_id := Null;
1006: as_sc_denorm.scd_frcst_date(1) := l_decision_date;
1007: as_sc_denorm.scd_rolling_frcst_flg(1) := Null;
1008: End;
1009:
1010: Begin

Line 1007: as_sc_denorm.scd_rolling_frcst_flg(1) := Null;

1003: l_uom_code := Null;
1004: l_item_id := Null;
1005: l_organization_id := Null;
1006: as_sc_denorm.scd_frcst_date(1) := l_decision_date;
1007: as_sc_denorm.scd_rolling_frcst_flg(1) := Null;
1008: End;
1009:
1010: Begin
1011: Select unit_of_measure_tl Into l_uom_description

Line 1066: ,opportunity_last_update_date = as_sc_denorm.scd_opp_last_upd_date(1)

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
1069: ,last_updated_by = NVL(FND_GLOBAL.login_id,-1)
1070: ,creation_date = sysdate

Line 1067: ,opportunity_last_updated_by = as_sc_denorm.scd_opp_last_upd_by(1)

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
1069: ,last_updated_by = NVL(FND_GLOBAL.login_id,-1)
1070: ,creation_date = sysdate
1071: ,created_by = p_new_created_by

Line 1147: ,attribute_category = as_sc_denorm.scd_attribute_category(1)

1143: ,parent_project = l_parent_project
1144: ,partner_customer_id = p_new_partner_customer_id
1145: ,partner_address_id = p_new_partner_address_id
1146: ,partner_customer_name = l_partner_cust_name
1147: ,attribute_category = as_sc_denorm.scd_attribute_category(1)
1148: ,attribute1 = as_sc_denorm.scd_attribute1(1)
1149: ,attribute2 = as_sc_denorm.scd_attribute2(1)
1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)
1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)

Line 1148: ,attribute1 = as_sc_denorm.scd_attribute1(1)

1144: ,partner_customer_id = p_new_partner_customer_id
1145: ,partner_address_id = p_new_partner_address_id
1146: ,partner_customer_name = l_partner_cust_name
1147: ,attribute_category = as_sc_denorm.scd_attribute_category(1)
1148: ,attribute1 = as_sc_denorm.scd_attribute1(1)
1149: ,attribute2 = as_sc_denorm.scd_attribute2(1)
1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)
1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)
1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)

Line 1149: ,attribute2 = as_sc_denorm.scd_attribute2(1)

1145: ,partner_address_id = p_new_partner_address_id
1146: ,partner_customer_name = l_partner_cust_name
1147: ,attribute_category = as_sc_denorm.scd_attribute_category(1)
1148: ,attribute1 = as_sc_denorm.scd_attribute1(1)
1149: ,attribute2 = as_sc_denorm.scd_attribute2(1)
1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)
1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)
1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)
1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)

Line 1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)

1146: ,partner_customer_name = l_partner_cust_name
1147: ,attribute_category = as_sc_denorm.scd_attribute_category(1)
1148: ,attribute1 = as_sc_denorm.scd_attribute1(1)
1149: ,attribute2 = as_sc_denorm.scd_attribute2(1)
1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)
1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)
1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)
1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)
1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)

Line 1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)

1147: ,attribute_category = as_sc_denorm.scd_attribute_category(1)
1148: ,attribute1 = as_sc_denorm.scd_attribute1(1)
1149: ,attribute2 = as_sc_denorm.scd_attribute2(1)
1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)
1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)
1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)
1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)
1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)
1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)

Line 1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)

1148: ,attribute1 = as_sc_denorm.scd_attribute1(1)
1149: ,attribute2 = as_sc_denorm.scd_attribute2(1)
1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)
1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)
1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)
1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)
1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)
1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)
1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)

Line 1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)

1149: ,attribute2 = as_sc_denorm.scd_attribute2(1)
1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)
1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)
1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)
1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)
1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)
1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)
1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)
1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)

Line 1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)

1150: ,attribute3 = as_sc_denorm.scd_attribute3(1)
1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)
1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)
1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)
1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)
1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)
1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)
1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)
1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)

Line 1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)

1151: ,attribute4 = as_sc_denorm.scd_attribute4(1)
1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)
1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)
1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)
1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)
1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)
1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)
1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)
1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)

Line 1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)

1152: ,attribute5 = as_sc_denorm.scd_attribute5(1)
1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)
1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)
1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)
1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)
1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)
1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)
1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)
1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)

Line 1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)

1153: ,attribute6 = as_sc_denorm.scd_attribute6(1)
1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)
1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)
1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)
1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)
1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)
1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)
1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)
1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)

Line 1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)

1154: ,attribute7 = as_sc_denorm.scd_attribute7(1)
1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)
1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)
1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)
1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)
1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)
1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)
1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)
1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)

Line 1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)

1155: ,attribute8 = as_sc_denorm.scd_attribute8(1)
1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)
1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)
1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)
1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)
1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)
1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)
1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)
1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)

Line 1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)

1156: ,attribute9 = as_sc_denorm.scd_attribute9(1)
1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)
1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)
1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)
1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)
1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)
1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)
1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)
1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)

Line 1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)

1157: ,attribute10 = as_sc_denorm.scd_attribute10(1)
1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)
1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)
1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)
1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)
1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)
1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)
1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)
1165: ,close_reason = as_sc_denorm.scd_close_reason(1)

Line 1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)

1158: ,attribute11 = as_sc_denorm.scd_attribute11(1)
1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)
1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)
1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)
1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)
1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)
1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)
1165: ,close_reason = as_sc_denorm.scd_close_reason(1)
1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)

Line 1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)

1159: ,attribute12 = as_sc_denorm.scd_attribute12(1)
1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)
1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)
1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)
1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)
1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)
1165: ,close_reason = as_sc_denorm.scd_close_reason(1)
1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)

Line 1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)

1160: ,attribute13 = as_sc_denorm.scd_attribute13(1)
1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)
1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)
1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)
1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)
1165: ,close_reason = as_sc_denorm.scd_close_reason(1)
1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
1168: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)

Line 1165: ,close_reason = as_sc_denorm.scd_close_reason(1)

1161: ,attribute14 = as_sc_denorm.scd_attribute14(1)
1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)
1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)
1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)
1165: ,close_reason = as_sc_denorm.scd_close_reason(1)
1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
1168: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
1169: ,opportunity_created_by = as_sc_denorm.scd_opp_created_by(1)

Line 1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)

1162: ,attribute15 = as_sc_denorm.scd_attribute15(1)
1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)
1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)
1165: ,close_reason = as_sc_denorm.scd_close_reason(1)
1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
1168: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
1169: ,opportunity_created_by = as_sc_denorm.scd_opp_created_by(1)
1170: ,opportunity_creation_date = as_sc_denorm.scd_opp_creation_date(1)

Line 1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)

1163: ,forecast_date = as_sc_denorm.scd_frcst_date(1)
1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)
1165: ,close_reason = as_sc_denorm.scd_close_reason(1)
1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
1168: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
1169: ,opportunity_created_by = as_sc_denorm.scd_opp_created_by(1)
1170: ,opportunity_creation_date = as_sc_denorm.scd_opp_creation_date(1)
1171: ,sales_methodology_id = l_sales_methodology_id

Line 1168: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)

1164: ,rolling_forecast_flag = as_sc_denorm.scd_rolling_frcst_flg(1)
1165: ,close_reason = as_sc_denorm.scd_close_reason(1)
1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
1168: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
1169: ,opportunity_created_by = as_sc_denorm.scd_opp_created_by(1)
1170: ,opportunity_creation_date = as_sc_denorm.scd_opp_creation_date(1)
1171: ,sales_methodology_id = l_sales_methodology_id
1172: ,opp_worst_forecast_amount = p_opp_worst_forecast_amount

Line 1169: ,opportunity_created_by = as_sc_denorm.scd_opp_created_by(1)

1165: ,close_reason = as_sc_denorm.scd_close_reason(1)
1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
1168: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
1169: ,opportunity_created_by = as_sc_denorm.scd_opp_created_by(1)
1170: ,opportunity_creation_date = as_sc_denorm.scd_opp_creation_date(1)
1171: ,sales_methodology_id = l_sales_methodology_id
1172: ,opp_worst_forecast_amount = p_opp_worst_forecast_amount
1173: ,opp_forecast_amount = p_opp_forecast_amount

Line 1170: ,opportunity_creation_date = as_sc_denorm.scd_opp_creation_date(1)

1166: ,close_reason_meaning = as_sc_denorm.scd_close_reason_men(1)
1167: ,opportunity_last_updated_name = as_sc_denorm.scd_opp_last_upd_name(1)
1168: ,opportunity_created_name = as_sc_denorm.scd_opp_created_name(1)
1169: ,opportunity_created_by = as_sc_denorm.scd_opp_created_by(1)
1170: ,opportunity_creation_date = as_sc_denorm.scd_opp_creation_date(1)
1171: ,sales_methodology_id = l_sales_methodology_id
1172: ,opp_worst_forecast_amount = p_opp_worst_forecast_amount
1173: ,opp_forecast_amount = p_opp_forecast_amount
1174: ,opp_best_forecast_amount = p_opp_best_forecast_amount

Line 1295: ,as_sc_denorm.scd_opp_last_upd_date(1)

1291: ,opp_forecast_amount
1292: ,opp_best_forecast_amount)
1293: Values
1294: (p_new_sales_credit_id
1295: ,as_sc_denorm.scd_opp_last_upd_date(1)
1296: ,as_sc_denorm.scd_opp_last_upd_by(1)
1297: ,sysdate
1298: ,NVL(FND_GLOBAL.login_id,-1)
1299: ,SYSDATE

Line 1296: ,as_sc_denorm.scd_opp_last_upd_by(1)

1292: ,opp_best_forecast_amount)
1293: Values
1294: (p_new_sales_credit_id
1295: ,as_sc_denorm.scd_opp_last_upd_date(1)
1296: ,as_sc_denorm.scd_opp_last_upd_by(1)
1297: ,sysdate
1298: ,NVL(FND_GLOBAL.login_id,-1)
1299: ,SYSDATE
1300: ,p_new_created_by

Line 1375: ,as_sc_denorm.scd_opp_last_upd_name(1)

1371: ,l_parent_project
1372: ,p_new_partner_address_id
1373: ,p_new_partner_customer_id
1374: ,l_partner_cust_name
1375: ,as_sc_denorm.scd_opp_last_upd_name(1)
1376: ,as_sc_denorm.scd_opp_created_name(1)
1377: ,as_sc_denorm.scd_opp_creation_date(1)
1378: ,as_sc_denorm.scd_opp_created_by(1)
1379: ,as_sc_denorm.scd_close_reason(1)

Line 1376: ,as_sc_denorm.scd_opp_created_name(1)

1372: ,p_new_partner_address_id
1373: ,p_new_partner_customer_id
1374: ,l_partner_cust_name
1375: ,as_sc_denorm.scd_opp_last_upd_name(1)
1376: ,as_sc_denorm.scd_opp_created_name(1)
1377: ,as_sc_denorm.scd_opp_creation_date(1)
1378: ,as_sc_denorm.scd_opp_created_by(1)
1379: ,as_sc_denorm.scd_close_reason(1)
1380: ,as_sc_denorm.scd_close_reason_men(1)

Line 1377: ,as_sc_denorm.scd_opp_creation_date(1)

1373: ,p_new_partner_customer_id
1374: ,l_partner_cust_name
1375: ,as_sc_denorm.scd_opp_last_upd_name(1)
1376: ,as_sc_denorm.scd_opp_created_name(1)
1377: ,as_sc_denorm.scd_opp_creation_date(1)
1378: ,as_sc_denorm.scd_opp_created_by(1)
1379: ,as_sc_denorm.scd_close_reason(1)
1380: ,as_sc_denorm.scd_close_reason_men(1)
1381: ,as_sc_denorm.scd_attribute_category(1)

Line 1378: ,as_sc_denorm.scd_opp_created_by(1)

1374: ,l_partner_cust_name
1375: ,as_sc_denorm.scd_opp_last_upd_name(1)
1376: ,as_sc_denorm.scd_opp_created_name(1)
1377: ,as_sc_denorm.scd_opp_creation_date(1)
1378: ,as_sc_denorm.scd_opp_created_by(1)
1379: ,as_sc_denorm.scd_close_reason(1)
1380: ,as_sc_denorm.scd_close_reason_men(1)
1381: ,as_sc_denorm.scd_attribute_category(1)
1382: ,as_sc_denorm.scd_attribute1(1)

Line 1379: ,as_sc_denorm.scd_close_reason(1)

1375: ,as_sc_denorm.scd_opp_last_upd_name(1)
1376: ,as_sc_denorm.scd_opp_created_name(1)
1377: ,as_sc_denorm.scd_opp_creation_date(1)
1378: ,as_sc_denorm.scd_opp_created_by(1)
1379: ,as_sc_denorm.scd_close_reason(1)
1380: ,as_sc_denorm.scd_close_reason_men(1)
1381: ,as_sc_denorm.scd_attribute_category(1)
1382: ,as_sc_denorm.scd_attribute1(1)
1383: ,as_sc_denorm.scd_attribute2(1)

Line 1380: ,as_sc_denorm.scd_close_reason_men(1)

1376: ,as_sc_denorm.scd_opp_created_name(1)
1377: ,as_sc_denorm.scd_opp_creation_date(1)
1378: ,as_sc_denorm.scd_opp_created_by(1)
1379: ,as_sc_denorm.scd_close_reason(1)
1380: ,as_sc_denorm.scd_close_reason_men(1)
1381: ,as_sc_denorm.scd_attribute_category(1)
1382: ,as_sc_denorm.scd_attribute1(1)
1383: ,as_sc_denorm.scd_attribute2(1)
1384: ,as_sc_denorm.scd_attribute3(1)

Line 1381: ,as_sc_denorm.scd_attribute_category(1)

1377: ,as_sc_denorm.scd_opp_creation_date(1)
1378: ,as_sc_denorm.scd_opp_created_by(1)
1379: ,as_sc_denorm.scd_close_reason(1)
1380: ,as_sc_denorm.scd_close_reason_men(1)
1381: ,as_sc_denorm.scd_attribute_category(1)
1382: ,as_sc_denorm.scd_attribute1(1)
1383: ,as_sc_denorm.scd_attribute2(1)
1384: ,as_sc_denorm.scd_attribute3(1)
1385: ,as_sc_denorm.scd_attribute4(1)

Line 1382: ,as_sc_denorm.scd_attribute1(1)

1378: ,as_sc_denorm.scd_opp_created_by(1)
1379: ,as_sc_denorm.scd_close_reason(1)
1380: ,as_sc_denorm.scd_close_reason_men(1)
1381: ,as_sc_denorm.scd_attribute_category(1)
1382: ,as_sc_denorm.scd_attribute1(1)
1383: ,as_sc_denorm.scd_attribute2(1)
1384: ,as_sc_denorm.scd_attribute3(1)
1385: ,as_sc_denorm.scd_attribute4(1)
1386: ,as_sc_denorm.scd_attribute5(1)

Line 1383: ,as_sc_denorm.scd_attribute2(1)

1379: ,as_sc_denorm.scd_close_reason(1)
1380: ,as_sc_denorm.scd_close_reason_men(1)
1381: ,as_sc_denorm.scd_attribute_category(1)
1382: ,as_sc_denorm.scd_attribute1(1)
1383: ,as_sc_denorm.scd_attribute2(1)
1384: ,as_sc_denorm.scd_attribute3(1)
1385: ,as_sc_denorm.scd_attribute4(1)
1386: ,as_sc_denorm.scd_attribute5(1)
1387: ,as_sc_denorm.scd_attribute6(1)

Line 1384: ,as_sc_denorm.scd_attribute3(1)

1380: ,as_sc_denorm.scd_close_reason_men(1)
1381: ,as_sc_denorm.scd_attribute_category(1)
1382: ,as_sc_denorm.scd_attribute1(1)
1383: ,as_sc_denorm.scd_attribute2(1)
1384: ,as_sc_denorm.scd_attribute3(1)
1385: ,as_sc_denorm.scd_attribute4(1)
1386: ,as_sc_denorm.scd_attribute5(1)
1387: ,as_sc_denorm.scd_attribute6(1)
1388: ,as_sc_denorm.scd_attribute7(1)

Line 1385: ,as_sc_denorm.scd_attribute4(1)

1381: ,as_sc_denorm.scd_attribute_category(1)
1382: ,as_sc_denorm.scd_attribute1(1)
1383: ,as_sc_denorm.scd_attribute2(1)
1384: ,as_sc_denorm.scd_attribute3(1)
1385: ,as_sc_denorm.scd_attribute4(1)
1386: ,as_sc_denorm.scd_attribute5(1)
1387: ,as_sc_denorm.scd_attribute6(1)
1388: ,as_sc_denorm.scd_attribute7(1)
1389: ,as_sc_denorm.scd_attribute8(1)

Line 1386: ,as_sc_denorm.scd_attribute5(1)

1382: ,as_sc_denorm.scd_attribute1(1)
1383: ,as_sc_denorm.scd_attribute2(1)
1384: ,as_sc_denorm.scd_attribute3(1)
1385: ,as_sc_denorm.scd_attribute4(1)
1386: ,as_sc_denorm.scd_attribute5(1)
1387: ,as_sc_denorm.scd_attribute6(1)
1388: ,as_sc_denorm.scd_attribute7(1)
1389: ,as_sc_denorm.scd_attribute8(1)
1390: ,as_sc_denorm.scd_attribute9(1)

Line 1387: ,as_sc_denorm.scd_attribute6(1)

1383: ,as_sc_denorm.scd_attribute2(1)
1384: ,as_sc_denorm.scd_attribute3(1)
1385: ,as_sc_denorm.scd_attribute4(1)
1386: ,as_sc_denorm.scd_attribute5(1)
1387: ,as_sc_denorm.scd_attribute6(1)
1388: ,as_sc_denorm.scd_attribute7(1)
1389: ,as_sc_denorm.scd_attribute8(1)
1390: ,as_sc_denorm.scd_attribute9(1)
1391: ,as_sc_denorm.scd_attribute10(1)

Line 1388: ,as_sc_denorm.scd_attribute7(1)

1384: ,as_sc_denorm.scd_attribute3(1)
1385: ,as_sc_denorm.scd_attribute4(1)
1386: ,as_sc_denorm.scd_attribute5(1)
1387: ,as_sc_denorm.scd_attribute6(1)
1388: ,as_sc_denorm.scd_attribute7(1)
1389: ,as_sc_denorm.scd_attribute8(1)
1390: ,as_sc_denorm.scd_attribute9(1)
1391: ,as_sc_denorm.scd_attribute10(1)
1392: ,as_sc_denorm.scd_attribute11(1)

Line 1389: ,as_sc_denorm.scd_attribute8(1)

1385: ,as_sc_denorm.scd_attribute4(1)
1386: ,as_sc_denorm.scd_attribute5(1)
1387: ,as_sc_denorm.scd_attribute6(1)
1388: ,as_sc_denorm.scd_attribute7(1)
1389: ,as_sc_denorm.scd_attribute8(1)
1390: ,as_sc_denorm.scd_attribute9(1)
1391: ,as_sc_denorm.scd_attribute10(1)
1392: ,as_sc_denorm.scd_attribute11(1)
1393: ,as_sc_denorm.scd_attribute12(1)

Line 1390: ,as_sc_denorm.scd_attribute9(1)

1386: ,as_sc_denorm.scd_attribute5(1)
1387: ,as_sc_denorm.scd_attribute6(1)
1388: ,as_sc_denorm.scd_attribute7(1)
1389: ,as_sc_denorm.scd_attribute8(1)
1390: ,as_sc_denorm.scd_attribute9(1)
1391: ,as_sc_denorm.scd_attribute10(1)
1392: ,as_sc_denorm.scd_attribute11(1)
1393: ,as_sc_denorm.scd_attribute12(1)
1394: ,as_sc_denorm.scd_attribute13(1)

Line 1391: ,as_sc_denorm.scd_attribute10(1)

1387: ,as_sc_denorm.scd_attribute6(1)
1388: ,as_sc_denorm.scd_attribute7(1)
1389: ,as_sc_denorm.scd_attribute8(1)
1390: ,as_sc_denorm.scd_attribute9(1)
1391: ,as_sc_denorm.scd_attribute10(1)
1392: ,as_sc_denorm.scd_attribute11(1)
1393: ,as_sc_denorm.scd_attribute12(1)
1394: ,as_sc_denorm.scd_attribute13(1)
1395: ,as_sc_denorm.scd_attribute14(1)

Line 1392: ,as_sc_denorm.scd_attribute11(1)

1388: ,as_sc_denorm.scd_attribute7(1)
1389: ,as_sc_denorm.scd_attribute8(1)
1390: ,as_sc_denorm.scd_attribute9(1)
1391: ,as_sc_denorm.scd_attribute10(1)
1392: ,as_sc_denorm.scd_attribute11(1)
1393: ,as_sc_denorm.scd_attribute12(1)
1394: ,as_sc_denorm.scd_attribute13(1)
1395: ,as_sc_denorm.scd_attribute14(1)
1396: ,as_sc_denorm.scd_attribute15(1)

Line 1393: ,as_sc_denorm.scd_attribute12(1)

1389: ,as_sc_denorm.scd_attribute8(1)
1390: ,as_sc_denorm.scd_attribute9(1)
1391: ,as_sc_denorm.scd_attribute10(1)
1392: ,as_sc_denorm.scd_attribute11(1)
1393: ,as_sc_denorm.scd_attribute12(1)
1394: ,as_sc_denorm.scd_attribute13(1)
1395: ,as_sc_denorm.scd_attribute14(1)
1396: ,as_sc_denorm.scd_attribute15(1)
1397: ,as_sc_denorm.scd_frcst_date(1)

Line 1394: ,as_sc_denorm.scd_attribute13(1)

1390: ,as_sc_denorm.scd_attribute9(1)
1391: ,as_sc_denorm.scd_attribute10(1)
1392: ,as_sc_denorm.scd_attribute11(1)
1393: ,as_sc_denorm.scd_attribute12(1)
1394: ,as_sc_denorm.scd_attribute13(1)
1395: ,as_sc_denorm.scd_attribute14(1)
1396: ,as_sc_denorm.scd_attribute15(1)
1397: ,as_sc_denorm.scd_frcst_date(1)
1398: ,as_sc_denorm.scd_rolling_frcst_flg(1)

Line 1395: ,as_sc_denorm.scd_attribute14(1)

1391: ,as_sc_denorm.scd_attribute10(1)
1392: ,as_sc_denorm.scd_attribute11(1)
1393: ,as_sc_denorm.scd_attribute12(1)
1394: ,as_sc_denorm.scd_attribute13(1)
1395: ,as_sc_denorm.scd_attribute14(1)
1396: ,as_sc_denorm.scd_attribute15(1)
1397: ,as_sc_denorm.scd_frcst_date(1)
1398: ,as_sc_denorm.scd_rolling_frcst_flg(1)
1399: ,l_sales_methodology_id

Line 1396: ,as_sc_denorm.scd_attribute15(1)

1392: ,as_sc_denorm.scd_attribute11(1)
1393: ,as_sc_denorm.scd_attribute12(1)
1394: ,as_sc_denorm.scd_attribute13(1)
1395: ,as_sc_denorm.scd_attribute14(1)
1396: ,as_sc_denorm.scd_attribute15(1)
1397: ,as_sc_denorm.scd_frcst_date(1)
1398: ,as_sc_denorm.scd_rolling_frcst_flg(1)
1399: ,l_sales_methodology_id
1400: ,p_opp_worst_forecast_amount

Line 1397: ,as_sc_denorm.scd_frcst_date(1)

1393: ,as_sc_denorm.scd_attribute12(1)
1394: ,as_sc_denorm.scd_attribute13(1)
1395: ,as_sc_denorm.scd_attribute14(1)
1396: ,as_sc_denorm.scd_attribute15(1)
1397: ,as_sc_denorm.scd_frcst_date(1)
1398: ,as_sc_denorm.scd_rolling_frcst_flg(1)
1399: ,l_sales_methodology_id
1400: ,p_opp_worst_forecast_amount
1401: ,p_opp_forecast_amount

Line 1398: ,as_sc_denorm.scd_rolling_frcst_flg(1)

1394: ,as_sc_denorm.scd_attribute13(1)
1395: ,as_sc_denorm.scd_attribute14(1)
1396: ,as_sc_denorm.scd_attribute15(1)
1397: ,as_sc_denorm.scd_frcst_date(1)
1398: ,as_sc_denorm.scd_rolling_frcst_flg(1)
1399: ,l_sales_methodology_id
1400: ,p_opp_worst_forecast_amount
1401: ,p_opp_forecast_amount
1402: ,p_opp_best_forecast_amount);

Line 1411: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

1407: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1408: 'Error in Sales Credits Trigger:' || sqlerrm);
1409: END IF;
1410:
1411: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');
1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1413: End;
1414:
1415: Exception

Line 1422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

1418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1419: 'Error in Sales Credits Trigger:' || sqlerrm);
1420: END IF;
1421:
1422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: When Others then
1425: IF l_debug THEN
1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 1430: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1427: 'Error in Sales Credits Trigger:' || sqlerrm);
1428: END IF;
1429:
1430: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');
1431: End Sales_Credit_Trg_Handler;
1432:
1433: End AS_SC_DENORM_TRG;

Line 1433: End AS_SC_DENORM_TRG;

1429:
1430: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');
1431: End Sales_Credit_Trg_Handler;
1432:
1433: End AS_SC_DENORM_TRG;