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 JTF_RS_RESOURCE_EXTNS

Line 168: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;

164: l_converted_won_amount NUMBER;
165: l_converted_weighted_amount NUMBER;
166: l_conversion_status_flag NUMBER;
167: l_competitor_name hz_parties.party_name%TYPE;
168: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
169: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
170: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
171: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
172: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 169: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;

165: l_converted_weighted_amount NUMBER;
166: l_conversion_status_flag NUMBER;
167: l_competitor_name hz_parties.party_name%TYPE;
168: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
169: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
170: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
171: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
172: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
173: Begin

Line 170: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;

166: l_conversion_status_flag NUMBER;
167: l_competitor_name hz_parties.party_name%TYPE;
168: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
169: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
170: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
171: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
172: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
173: Begin
174: IF l_debug THEN

Line 219: From jtf_rs_resource_extns

215:
216: Begin
217: Select source_name, source_first_name, source_last_name
218: Into l_owner_person_name, l_owner_first_name, l_owner_last_name
219: From jtf_rs_resource_extns
220: Where resource_id = p_new_owner_salesforce_id
221: and category IN ('EMPLOYEE','PARTY');
222: Exception When Others then
223: l_owner_person_name := Null;

Line 252: From jtf_rs_resource_extns

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
256: as_sc_denorm.scd_opp_created_name(1) := Null;

Line 262: From jtf_rs_resource_extns

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
266: as_sc_denorm.scd_opp_last_upd_name(1) := Null;

Line 659: l_sales_rep_name jtf_rs_resource_extns.source_name%TYPE;

655: p_opp_best_forecast_amount IN NUMBER,
656: p_trigger_mode IN OUT NOCOPY VARCHAR2) IS
657:
658: l_sales_group_name varchar2(100);
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;

Line 660: l_first_name jtf_rs_resource_extns.source_first_name%TYPE;

656: p_trigger_mode IN OUT NOCOPY VARCHAR2) IS
657:
658: l_sales_group_name varchar2(100);
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;

Line 661: l_last_name jtf_rs_resource_extns.source_last_name%TYPE;

657:
658: l_sales_group_name varchar2(100);
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;

Line 662: l_employee_number jtf_rs_resource_extns.source_number%TYPE;

658: l_sales_group_name varchar2(100);
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;

Line 680: l_owner_person_name jtf_rs_resource_extns.source_name%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;
683: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
684: l_sales_stage as_sales_stages.name%TYPE;

Line 681: l_owner_first_name jtf_rs_resource_extns.source_first_name%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;
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;

Line 682: l_owner_last_name jtf_rs_resource_extns.source_last_name%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;
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;

Line 860: From jtf_rs_resource_extns

856:
857: Begin
858: Select source_name, source_first_name, source_last_name, source_number
859: Into l_sales_rep_name, l_first_name, l_last_name, l_employee_number
860: From jtf_rs_resource_extns
861: Where resource_id = p_new_salesforce_id
862: and category IN ('EMPLOYEE','PARTY');
863: Exception When Others then
864: l_sales_rep_name := Null;

Line 906: From jtf_rs_resource_extns

902:
903: Begin
904: Select source_name, source_first_name, source_last_name
905: Into l_owner_person_name, l_owner_first_name, l_owner_last_name
906: From jtf_rs_resource_extns
907: Where resource_id = l_owner_salesforce_id
908: and category IN ('EMPLOYEE','PARTY');
909: Exception When Others then
910: l_owner_person_name := Null;

Line 940: From jtf_rs_resource_extns

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
944: as_sc_denorm.scd_opp_created_name(1) := Null;

Line 950: From jtf_rs_resource_extns

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
954: as_sc_denorm.scd_opp_last_upd_name(1) := Null;