APPS.OE_RELATED_ITEMS_PVT dependencies on OE_SYS_PARAMETERS

Line 146: l_org_id number := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

142: out_inv_desc out nocopy varchar2,
143: out_inv_item_type out nocopy varchar2
144: )
145: IS
146: l_org_id number := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
147: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
148: BEGIN
149: SELECT concatenated_segments,description,item_type
150: INTO out_inv_item_name,out_inv_desc,out_inv_item_type

Line 1040: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

1036: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1037: )IS
1038:
1039: qp_attr_mapping_error exception;
1040: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1041: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1042: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1043:
1044: --

Line 1201: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

1197: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1198: )IS
1199:
1200: qp_attr_mapping_error exception;
1201: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1202: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1203: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1204:
1205: --

Line 3036: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');

3032: l_msg_data out NOCOPY /* file.sql.39 change */ varchar2
3033: ) IS
3034:
3035: l_price_list varchar2(200);
3036: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
3037: l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
3038: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3039:
3040:

Line 3038: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

3034:
3035: l_price_list varchar2(200);
3036: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
3037: l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
3038: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3039:
3040:
3041: Cursor get_gsa_list_lines is
3042: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)