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.OKC_TERMS_UTIL_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 4386: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;

4382: IS
4383:
4384: l_api_name VARCHAR2(30);
4385: l_api_version NUMBER;
4386: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;
4387: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;
4388: l_quote_org_id aso_quote_headers_all.org_id%TYPE;
4389: l_quote_number aso_quote_headers_all.quote_number%TYPE;
4390:

Line 4387: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;

4383:
4384: l_api_name VARCHAR2(30);
4385: l_api_version NUMBER;
4386: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;
4387: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;
4388: l_quote_org_id aso_quote_headers_all.org_id%TYPE;
4389: l_quote_number aso_quote_headers_all.quote_number%TYPE;
4390:
4391: CURSOR quote_details_csr IS

Line 4388: l_quote_org_id aso_quote_headers_all.org_id%TYPE;

4384: l_api_name VARCHAR2(30);
4385: l_api_version NUMBER;
4386: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;
4387: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;
4388: l_quote_org_id aso_quote_headers_all.org_id%TYPE;
4389: l_quote_number aso_quote_headers_all.quote_number%TYPE;
4390:
4391: CURSOR quote_details_csr IS
4392: SELECT resource_id,

Line 4389: l_quote_number aso_quote_headers_all.quote_number%TYPE;

4385: l_api_version NUMBER;
4386: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;
4387: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;
4388: l_quote_org_id aso_quote_headers_all.org_id%TYPE;
4389: l_quote_number aso_quote_headers_all.quote_number%TYPE;
4390:
4391: CURSOR quote_details_csr IS
4392: SELECT resource_id,
4393: resource_grp_id,

Line 4395: FROM aso_quote_headers_all

4391: CURSOR quote_details_csr IS
4392: SELECT resource_id,
4393: resource_grp_id,
4394: quote_number
4395: FROM aso_quote_headers_all
4396: WHERE quote_header_id = p_doc_id;
4397:
4398: CURSOR quote_sales_team_csr(p_quote_number IN aso_quote_headers_all.quote_number%TYPE) IS
4399: SELECT sre.user_id

Line 4398: CURSOR quote_sales_team_csr(p_quote_number IN aso_quote_headers_all.quote_number%TYPE) IS

4394: quote_number
4395: FROM aso_quote_headers_all
4396: WHERE quote_header_id = p_doc_id;
4397:
4398: CURSOR quote_sales_team_csr(p_quote_number IN aso_quote_headers_all.quote_number%TYPE) IS
4399: SELECT sre.user_id
4400: FROM aso_quote_accesses sales_team,
4401: jtf_rs_role_relations rr,
4402: jtf_rs_roles_b rl,

Line 4420: CURSOR con_admin_role_member_csr(p_sales_group_id IN aso_quote_headers_all.resource_grp_id%TYPE) IS

4416: )
4417: AND rr.role_resource_id = sales_team.resource_id
4418: AND sre.resource_id = sales_team.resource_id;
4419:
4420: CURSOR con_admin_role_member_csr(p_sales_group_id IN aso_quote_headers_all.resource_grp_id%TYPE) IS
4421: SELECT sre.user_id
4422: FROM jtf_rs_group_members srg,
4423: jtf_rs_resource_extns sre,
4424: jtf_rs_role_relations rr,

Line 4440: CURSOR parent_group_csr(p_sales_group_id IN aso_quote_headers_all.resource_grp_id%TYPE) IS

4436: AND rl.role_code = 'CONTRACTS_ADMIN'
4437: -- For Bug# 6343627 AND rr.role_resource_id = sre.resource_id;
4438: AND rr.role_resource_id = srg.GROUP_MEMBER_ID;
4439:
4440: CURSOR parent_group_csr(p_sales_group_id IN aso_quote_headers_all.resource_grp_id%TYPE) IS
4441: SELECT related_group_id
4442: FROM jtf_rs_grp_relations
4443: WHERE group_id = p_sales_group_id
4444: AND relation_type = 'PARENT_GROUP';