APPS.QP_SECURITY dependencies on QP_LIST_HEADERS_B

Line 108: | Input: p_instance_pk1_value -> list_header_id in qp_list_headers_b

104: | 'PRL' for standard pricelist
105: | 'MOD' for modifier
106: | 'AGR' for agreement pricelist
107: | 'FOR' for formula -- not used yet
108: | Input: p_instance_pk1_value -> list_header_id in qp_list_headers_b
109: | other primary key for formulas, qualifiers...
110: | p_instance_pk2_value -> optional, not used currently
111: | p_instance_pk3_vaue -> optional, not used currently
112: | Input: p_user_name -> optional, default is current user

Line 181: -- the global_flag in qp_list_headers_b table is for run-time engine use

177: BEGIN
178: --added for moac
179: l_mo_access_mode := MO_GLOBAL.get_access_mode;
180:
181: -- the global_flag in qp_list_headers_b table is for run-time engine use
182: -- only. For setup time, we use 'GLOBAL' as a grantee, and if a pricing
183: -- entity is granted to 'GLOBAL' with a specific function, it becomes
184: -- globally accessed with such function.
185:

Line 355: FROM qp_list_headers_b

351: error_message varchar2(1000);
352:
353: CURSOR l_pricelist_id_cur IS
354: SELECT list_header_id
355: FROM qp_list_headers_b
356: WHERE list_type_code = G_PRICELIST_TYPE;
357:
358: CURSOR l_modifier_id_cur IS
359: SELECT list_header_id

Line 360: FROM qp_list_headers_b

356: WHERE list_type_code = G_PRICELIST_TYPE;
357:
358: CURSOR l_modifier_id_cur IS
359: SELECT list_header_id
360: FROM qp_list_headers_b
361: WHERE list_type_code in (G_MODIFIER_SUR,G_MODIFIER_PRO,
362: G_MODIFIER_DLT,G_MODIFIER_DEL,G_MODIFIER_CHARGES);
363:
364: CURSOR l_agreement_id_cur IS

Line 366: FROM qp_list_headers_b

362: G_MODIFIER_DLT,G_MODIFIER_DEL,G_MODIFIER_CHARGES);
363:
364: CURSOR l_agreement_id_cur IS
365: SELECT list_header_id
366: FROM qp_list_headers_b
367: WHERE list_type_code = G_AGREEMENT_TYPE;
368:
369: CURSOR l_list_headers_id_cur IS
370: SELECT list_header_id

Line 371: FROM qp_list_headers_b;

367: WHERE list_type_code = G_AGREEMENT_TYPE;
368:
369: CURSOR l_list_headers_id_cur IS
370: SELECT list_header_id
371: FROM qp_list_headers_b;
372:
373: CURSOR l_grants_list_headers_id_cur(cp_user_id NUMBER,
374: cp_resp_id NUMBER,
375: cp_org_id NUMBER,

Line 689: | 'E'-> error, possible reason is: p_instance_pk1 is already existing in qp_list_headers_b

685: | p_org_id -> optional, default is current logged in
686: | operating unit
687: | Output: x_return_status ->
688: | 'S'-> successfully done
689: | 'E'-> error, possible reason is: p_instance_pk1 is already existing in qp_list_headers_b
690: | as one list_header_id. Make sure you didn't call commit()
691: | before you call this API when creating a new pricing entity.
692: +----------------------------------------------------------------------
693: */

Line 721: FROM qp_list_headers_b

717: l_last_update_login number;
718: l_list_type_code varchar2(30);
719: CURSOR list_header_id_exist_cur(cp_instance_id number) IS
720: SELECT list_type_code
721: FROM qp_list_headers_b
722: WHERE list_header_id = cp_instance_id;
723: l_dummy varchar2(1);
724: CURSOR grant_exist_cur(cp_grantee_type varchar2,
725: cp_grantee_id number,

Line 1190: --this will be the VPD policy for the secured synonym qp_list_headers_b

1186:
1187:
1188: -------------moac vpd --------------
1189: --added for MOAC
1190: --this will be the VPD policy for the secured synonym qp_list_headers_b
1191: --
1192: -- Name
1193: -- qp_org_security
1194: --

Line 1197: -- Access Control mechanism for QP_LIST_HEADERS_B.

1193: -- qp_org_security
1194: --
1195: -- Purpose
1196: -- This function implements the security policy for the Multi-Org
1197: -- Access Control mechanism for QP_LIST_HEADERS_B.
1198: -- It is automatically called by the oracle
1199: -- server whenever a secured table or view is referenced by a SQL
1200: -- statement. Products should not call this function directly.
1201: --