APPS.OKC_TERMS_UTIL_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 4337: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;

4333: IS
4334:
4335: l_api_name VARCHAR2(30);
4336: l_api_version NUMBER;
4337: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;
4338: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;
4339: l_quote_org_id aso_quote_headers_all.org_id%TYPE;
4340: l_quote_number aso_quote_headers_all.quote_number%TYPE;
4341:

Line 4338: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;

4334:
4335: l_api_name VARCHAR2(30);
4336: l_api_version NUMBER;
4337: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;
4338: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;
4339: l_quote_org_id aso_quote_headers_all.org_id%TYPE;
4340: l_quote_number aso_quote_headers_all.quote_number%TYPE;
4341:
4342: CURSOR quote_details_csr IS

Line 4339: l_quote_org_id aso_quote_headers_all.org_id%TYPE;

4335: l_api_name VARCHAR2(30);
4336: l_api_version NUMBER;
4337: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;
4338: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;
4339: l_quote_org_id aso_quote_headers_all.org_id%TYPE;
4340: l_quote_number aso_quote_headers_all.quote_number%TYPE;
4341:
4342: CURSOR quote_details_csr IS
4343: SELECT resource_id,

Line 4340: l_quote_number aso_quote_headers_all.quote_number%TYPE;

4336: l_api_version NUMBER;
4337: l_primary_salesperson_id aso_quote_headers_all.resource_id%TYPE;
4338: l_sales_group_id aso_quote_headers_all.resource_grp_id%TYPE;
4339: l_quote_org_id aso_quote_headers_all.org_id%TYPE;
4340: l_quote_number aso_quote_headers_all.quote_number%TYPE;
4341:
4342: CURSOR quote_details_csr IS
4343: SELECT resource_id,
4344: resource_grp_id,

Line 4346: FROM aso_quote_headers_all

4342: CURSOR quote_details_csr IS
4343: SELECT resource_id,
4344: resource_grp_id,
4345: quote_number
4346: FROM aso_quote_headers_all
4347: WHERE quote_header_id = p_doc_id;
4348:
4349: CURSOR quote_sales_team_csr(p_quote_number IN aso_quote_headers_all.quote_number%TYPE) IS
4350: SELECT sre.user_id

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

4345: quote_number
4346: FROM aso_quote_headers_all
4347: WHERE quote_header_id = p_doc_id;
4348:
4349: CURSOR quote_sales_team_csr(p_quote_number IN aso_quote_headers_all.quote_number%TYPE) IS
4350: SELECT sre.user_id
4351: FROM aso_quote_accesses sales_team,
4352: jtf_rs_role_relations rr,
4353: jtf_rs_roles_b rl,

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

4367: )
4368: AND rr.role_resource_id = sales_team.resource_id
4369: AND sre.resource_id = sales_team.resource_id;
4370:
4371: CURSOR con_admin_role_member_csr(p_sales_group_id IN aso_quote_headers_all.resource_grp_id%TYPE) IS
4372: SELECT sre.user_id
4373: FROM jtf_rs_group_members srg,
4374: jtf_rs_resource_extns sre,
4375: jtf_rs_role_relations rr,

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

4387: AND rl.role_code = 'CONTRACTS_ADMIN'
4388: -- For Bug# 6343627 AND rr.role_resource_id = sre.resource_id;
4389: AND rr.role_resource_id = srg.GROUP_MEMBER_ID;
4390:
4391: CURSOR parent_group_csr(p_sales_group_id IN aso_quote_headers_all.resource_grp_id%TYPE) IS
4392: SELECT related_group_id
4393: FROM jtf_rs_grp_relations
4394: WHERE group_id = p_sales_group_id
4395: AND relation_type = 'PARENT_GROUP';