DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on OE_SYS_PARAMETERS

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

1269:
1270: IS
1271:
1272: l_temp_date DATE;
1273: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
1274: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
1275: l_org_id NUMBER := Qp_Util.get_org_id;
1276: l_cust_relation_flag VARCHAR2(30);
1277: --OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', l_org_id);

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

1273: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
1274: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
1275: l_org_id NUMBER := Qp_Util.get_org_id;
1276: l_cust_relation_flag VARCHAR2(30);
1277: --OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', l_org_id);
1278:
1279: CURSOR c_price_list_multi
1280: IS
1281:

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

1612:
1613: BEGIN
1614: --added for moac to call oe_sys_params with a valid org_id
1615: IF l_org_id IS NOT NULL THEN
1616: l_cust_relation_flag := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_org_id);
1617: ELSE
1618: l_cust_relation_flag := '';
1619: END IF;
1620: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

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

1850: )
1851: IS
1852:
1853: l_temp_date DATE;
1854: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
1855: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
1856: l_cust_relation_flag VARCHAR2(30) := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', NULL);
1857:
1858: -- 4865226, SQL repositroy performance fix for shareable memory

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

1852:
1853: l_temp_date DATE;
1854: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
1855: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
1856: l_cust_relation_flag VARCHAR2(30) := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', NULL);
1857:
1858: -- 4865226, SQL repositroy performance fix for shareable memory
1859: CURSOR c_agreement
1860: IS