DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on OE_SYS_PARAMETERS

Line 943: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG

939:
940: IS
941:
942: l_temp_date DATE;
943: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
944: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
945: l_org_id NUMBER := Qp_Util.get_org_id;
946: l_cust_relation_flag VARCHAR2(30);
947: --OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', l_org_id);

Line 947: --OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', l_org_id);

943: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
944: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
945: l_org_id NUMBER := Qp_Util.get_org_id;
946: l_cust_relation_flag VARCHAR2(30);
947: --OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', l_org_id);
948:
949: CURSOR c_price_list_multi
950: IS
951:

Line 1286: l_cust_relation_flag := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_org_id);

1282:
1283: BEGIN
1284: --added for moac to call oe_sys_params with a valid org_id
1285: IF l_org_id IS NOT NULL THEN
1286: l_cust_relation_flag := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_org_id);
1287: ELSE
1288: l_cust_relation_flag := '';
1289: END IF;
1290: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

Line 1524: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG

1520: )
1521: IS
1522:
1523: l_temp_date DATE;
1524: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
1525: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
1526: l_cust_relation_flag VARCHAR2(30) := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', NULL);
1527:
1528: -- 4865226, SQL repositroy performance fix for shareable memory

Line 1526: l_cust_relation_flag VARCHAR2(30) := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', NULL);

1522:
1523: l_temp_date DATE;
1524: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
1525: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
1526: l_cust_relation_flag VARCHAR2(30) := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', NULL);
1527:
1528: -- 4865226, SQL repositroy performance fix for shareable memory
1529: CURSOR c_agreement
1530: IS