APPS.OE_RELATED_ITEMS_PVT dependencies on OE_SYS_PARAMETERS

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

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

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

1069: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1070: )IS
1071:
1072: qp_attr_mapping_error exception;
1073: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1074: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1075: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1076:
1077: --

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

1231: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1232: )IS
1233:
1234: qp_attr_mapping_error exception;
1235: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1236: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1237: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1238:
1239: --

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

3066: l_msg_data out NOCOPY /* file.sql.39 change */ varchar2
3067: ) IS
3068:
3069: l_price_list varchar2(200);
3070: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
3071: l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
3072: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3073:
3074:

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

3068:
3069: l_price_list varchar2(200);
3070: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
3071: l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
3072: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3073:
3074:
3075: Cursor get_gsa_list_lines is
3076: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)