APPS.ASO_SECURITY_INT dependencies on ASO_QUOTE_ACCESSES

Line 24: FROM ASO_QUOTE_ACCESSES

20: IS
21:
22: CURSOR C_direct_access (l_quote_number NUMBER, l_resource_id NUMBER) IS
23: SELECT update_access_flag
24: FROM ASO_QUOTE_ACCESSES
25: WHERE quote_number = l_quote_number
26: AND resource_id = l_resource_id;
27:
28: CURSOR C_manager_access (l_resource_id NUMBER, l_quote_number NUMBER) IS

Line 33: ASO_QUOTE_ACCESSES ACC

29: SELECT ACC.ACCESS_ID,
30: ACC.UPDATE_ACCESS_FLAG
31: FROM JTF_RS_REP_MANAGERS MGR,
32: JTF_RS_GROUP_USAGES UGS,
33: ASO_QUOTE_ACCESSES ACC
34: WHERE UGS.USAGE = 'SALES'
35: AND UGS.GROUP_ID = MGR.GROUP_ID
36: AND MGR.HIERARCHY_TYPE IN ('MGR_TO_MGR', 'MGR_TO_REP')
37: AND SYSDATE BETWEEN MGR.START_DATE_ACTIVE AND NVL(MGR.END_DATE_ACTIVE, SYSDATE)

Line 129: FROM ASO_QUOTE_ACCESSES

125: L_API_NAME VARCHAR2(50) := 'Add_Resource';
126:
127: CURSOR C_existing_resource (l_quote_number NUMBER, l_resource_id NUMBER) IS
128: SELECT access_id
129: FROM ASO_QUOTE_ACCESSES
130: WHERE quote_number = l_quote_number
131: AND resource_id = l_resource_id;
132:
133: CURSOR C_resource (l_access_id NUMBER) IS

Line 138: FROM ASO_QUOTE_ACCESSES

134: SELECT quote_number,
135: resource_id,
136: resource_grp_id,
137: update_access_flag
138: FROM ASO_QUOTE_ACCESSES
139: WHERE access_id = l_access_id;
140:
141: CURSOR C_primary_resource (l_quote_number NUMBER) IS
142: SELECT resource_id,quote_header_id,

Line 150: from aso_quote_accesses

146: AND max_version_flag = 'Y';
147:
148: cursor c_access_id_exist( p_access_id number) is
149: select access_id
150: from aso_quote_accesses
151: where access_id = p_access_id;
152:
153: CURSOR Lock_check(p_qte_number Number)
154: IS SELECT price_request_id FROM

Line 327: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

323: IF aso_debug_pub.g_debug_flag = 'Y' THEN
324: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before Insert_Row: counter: ' || i, 1, 'Y');
325: END IF;
326:
327: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
328: px_ACCESS_ID => l_qte_access_tbl(i).access_id,
329: p_QUOTE_NUMBER => l_qte_access_tbl(i).QUOTE_NUMBER,
330: p_RESOURCE_ID => l_qte_access_tbl(i).RESOURCE_ID,
331: p_RESOURCE_GRP_ID => l_qte_access_tbl(i).RESOURCE_GRP_ID,

Line 383: ASO_QUOTE_ACCESSES_PKG.Update_Row(

379: IF aso_debug_pub.g_debug_flag = 'Y' THEN
380: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before Update_Row: counter: ' || i, 1, 'Y');
381: END IF;
382:
383: ASO_QUOTE_ACCESSES_PKG.Update_Row(
384: p_ACCESS_ID => l_qte_access_tbl(i).access_id,
385: p_QUOTE_NUMBER => l_qte_access_tbl(i).QUOTE_NUMBER,
386: p_RESOURCE_ID => l_qte_access_tbl(i).RESOURCE_ID,
387: p_RESOURCE_GRP_ID => l_qte_access_tbl(i).RESOURCE_GRP_ID,

Line 663: FROM ASO_QUOTE_ACCESSES

659: L_API_NAME VARCHAR2(50) := 'Delete_Resource';
660:
661: CURSOR C_existing_resource (l_quote_number NUMBER, l_resource_id NUMBER) IS
662: SELECT access_id
663: FROM ASO_QUOTE_ACCESSES
664: WHERE quote_number = l_quote_number
665: AND resource_id = l_resource_id;
666:
667: CURSOR C_resource (l_access_id NUMBER) IS

Line 670: FROM ASO_QUOTE_ACCESSES

666:
667: CURSOR C_resource (l_access_id NUMBER) IS
668: SELECT quote_number,
669: resource_id
670: FROM ASO_QUOTE_ACCESSES
671: WHERE access_id = l_access_id;
672:
673: CURSOR C_primary_resource (l_quote_number NUMBER) IS
674: SELECT resource_id

Line 686: ASO_QUOTE_ACCESSES WHERE

682: AND max_version_flag = 'Y';
683:
684: CURSOR C_Quote_num(p_access_id Number) IS
685: SELECT quote_number FROM
686: ASO_QUOTE_ACCESSES WHERE
687: access_id = p_access_id;
688:
689: l_primary_resource_id NUMBER;
690: l_resource_id NUMBER;

Line 835: ASO_QUOTE_ACCESSES_PKG.Delete_Row(

831: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: before Delete_Row: l_access_id: ' || l_access_id, 1, 'Y');
832:
833: END IF;
834:
835: ASO_QUOTE_ACCESSES_PKG.Delete_Row(
836: p_ACCESS_ID => l_access_id
837: );
838:
839: IF aso_debug_pub.g_debug_flag = 'Y' THEN