eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_PRICE_PUB dependencies on OKC_PRICE_PUB

Line 1: PACKAGE BODY OKC_PRICE_PUB AS

1: PACKAGE BODY OKC_PRICE_PUB AS
2: /* $Header: OKCPPREB.pls 120.0 2005/05/26 09:41:21 appldev noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: G_NO_PRICING_RULE Varchar2(1) := 'N'; -- No Pricing Rule attached

Line 698: x_contract_line_rec OUT NOCOPY OKC_PRICE_PUB.G_LINE_REC_TYPE,

694: --
695: Procedure BUILD_OKC_KLINE_REC
696: (
697: p_contract_line_id IN NUMBER,
698: x_contract_line_rec OUT NOCOPY OKC_PRICE_PUB.G_LINE_REC_TYPE,
699: x_return_status OUT NOCOPY VARCHAR2
700: )
701: Is
702: Cursor Get_Line_det_Csr Is

Line 1087: Procedure Load_Lines(p_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,

1083: Also Req_Line_Attr_Tbl gets two similar records
1084: Req_Qual_Tbl gets two price list record and one modifier record
1085: Might want to check this out nocopy ***/
1086:
1087: Procedure Load_Lines(p_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1088: p_cp_Line_tbl IN OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1089: p_get_pb_tbl_flag IN Varchar2,
1090: p_price_list_id IN Number,
1091: p_modifier_list_id IN Number,

Line 1088: p_cp_Line_tbl IN OKC_PRICE_PUB.G_SLINE_TBL_TYPE,

1084: Req_Qual_Tbl gets two price list record and one modifier record
1085: Might want to check this out nocopy ***/
1086:
1087: Procedure Load_Lines(p_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1088: p_cp_Line_tbl IN OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1089: p_get_pb_tbl_flag IN Varchar2,
1090: p_price_list_id IN Number,
1091: p_modifier_list_id IN Number,
1092: p_pricing_contexts_tbl IN QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE,

Line 1107: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE := OKC_PRICE_PUB.G_REQUEST_TYPE_CODE;

1103: --- Get only price break information. Used only for Service Contracts
1104: l_line_index := l_line_index+1;
1105: px_req_line_tbl(l_line_index).LINE_INDEX := l_line_index;
1106: px_req_line_tbl(l_line_index).LINE_TYPE_CODE := 'LINE';
1107: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE := OKC_PRICE_PUB.G_REQUEST_TYPE_CODE;
1108: px_req_line_tbl(l_line_index).CURRENCY_CODE := p_Line_rec.currency_code;
1109: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := sysdate;
1110: px_req_line_tbl(l_line_index).ACTIVE_DATE_FIRST :=
1111: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE;

Line 1119: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,

1115: px_req_line_tbl(l_line_index).PRICE_FLAG := 'Y';
1116:
1117: --- Load the pricing attribute For this item
1118: Load_Pattr_Tbl(p_line_index => l_line_index,
1119: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,
1120: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,
1121: p_pricing_attr_value => p_line_rec.inventory_item_id,
1122: x_pattr_tbl => px_Req_line_attr_tbl);
1123:

Line 1120: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,

1116:
1117: --- Load the pricing attribute For this item
1118: Load_Pattr_Tbl(p_line_index => l_line_index,
1119: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,
1120: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,
1121: p_pricing_attr_value => p_line_rec.inventory_item_id,
1122: x_pattr_tbl => px_Req_line_attr_tbl);
1123:
1124: Load_Pattr_Tbl(p_line_index => l_line_index,

Line 1125: p_pricing_context => OKC_PRICE_PUB.G_VOLUME_CONTEXT,

1121: p_pricing_attr_value => p_line_rec.inventory_item_id,
1122: x_pattr_tbl => px_Req_line_attr_tbl);
1123:
1124: Load_Pattr_Tbl(p_line_index => l_line_index,
1125: p_pricing_context => OKC_PRICE_PUB.G_VOLUME_CONTEXT,
1126: p_pricing_attribute => OKC_PRICE_PUB.G_VOLUME_ATTR,
1127: p_pricing_attr_value => p_line_rec.item_qty,
1128: x_pattr_tbl => px_Req_line_attr_tbl);
1129:

Line 1126: p_pricing_attribute => OKC_PRICE_PUB.G_VOLUME_ATTR,

1122: x_pattr_tbl => px_Req_line_attr_tbl);
1123:
1124: Load_Pattr_Tbl(p_line_index => l_line_index,
1125: p_pricing_context => OKC_PRICE_PUB.G_VOLUME_CONTEXT,
1126: p_pricing_attribute => OKC_PRICE_PUB.G_VOLUME_ATTR,
1127: p_pricing_attr_value => p_line_rec.item_qty,
1128: x_pattr_tbl => px_Req_line_attr_tbl);
1129:
1130: --- Load the Price list as qualifier For serviceable item since we know which price list to use

Line 1133: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,

1129:
1130: --- Load the Price list as qualifier For serviceable item since we know which price list to use
1131: --- We do not use modifier list For serviceable items
1132: Load_Qual_Tbl(p_line_index => l_line_index,
1133: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,
1134: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,
1135: p_qualifier_attr_value => p_price_list_id,
1136: x_qual_tbl => px_Req_qual_tbl);
1137: Else

Line 1134: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,

1130: --- Load the Price list as qualifier For serviceable item since we know which price list to use
1131: --- We do not use modifier list For serviceable items
1132: Load_Qual_Tbl(p_line_index => l_line_index,
1133: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,
1134: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,
1135: p_qualifier_attr_value => p_price_list_id,
1136: x_qual_tbl => px_Req_qual_tbl);
1137: Else
1138: --- Calculate price

Line 1146: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE := OKC_PRICE_PUB.G_REQUEST_TYPE_CODE;

1142: --- Load the serviceable item first
1143: l_line_index := l_line_index+1;
1144: px_req_line_tbl(l_line_index).LINE_INDEX := l_line_index;
1145: px_req_line_tbl(l_line_index).LINE_TYPE_CODE := 'LINE';
1146: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE := OKC_PRICE_PUB.G_REQUEST_TYPE_CODE;
1147: px_req_line_tbl(l_line_index).CURRENCY_CODE := p_line_rec.currency_code;
1148: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := sysdate;
1149: px_req_line_tbl(l_line_index).ACTIVE_DATE_FIRST :=
1150: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE;

Line 1160: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,

1156: --- Load the pricing attribute For this item
1157:
1158: If nvl(p_line_rec.usage_item_flag, 'N') = 'N' Then
1159: Load_Pattr_Tbl(p_line_index => l_line_index,
1160: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,
1161: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,
1162: p_pricing_attr_value => p_cp_line_tbl(i).inventory_item_id,
1163: x_pattr_tbl => px_Req_line_attr_tbl);
1164: Else

Line 1161: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,

1157:
1158: If nvl(p_line_rec.usage_item_flag, 'N') = 'N' Then
1159: Load_Pattr_Tbl(p_line_index => l_line_index,
1160: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,
1161: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,
1162: p_pricing_attr_value => p_cp_line_tbl(i).inventory_item_id,
1163: x_pattr_tbl => px_Req_line_attr_tbl);
1164: Else
1165: Load_Pattr_Tbl(p_line_index => l_line_index,

Line 1166: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,

1162: p_pricing_attr_value => p_cp_line_tbl(i).inventory_item_id,
1163: x_pattr_tbl => px_Req_line_attr_tbl);
1164: Else
1165: Load_Pattr_Tbl(p_line_index => l_line_index,
1166: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,
1167: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,
1168: p_pricing_attr_value => p_line_rec.inventory_item_id,
1169: x_pattr_tbl => px_Req_line_attr_tbl);
1170:

Line 1167: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,

1163: x_pattr_tbl => px_Req_line_attr_tbl);
1164: Else
1165: Load_Pattr_Tbl(p_line_index => l_line_index,
1166: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,
1167: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,
1168: p_pricing_attr_value => p_line_rec.inventory_item_id,
1169: x_pattr_tbl => px_Req_line_attr_tbl);
1170:
1171: --- For usage items, QP requires quantity as pricing attr rather than item qty

Line 1173: p_pricing_context => OKC_PRICE_PUB.G_VOLUME_CONTEXT,

1169: x_pattr_tbl => px_Req_line_attr_tbl);
1170:
1171: --- For usage items, QP requires quantity as pricing attr rather than item qty
1172: Load_Pattr_Tbl(p_line_index => l_line_index,
1173: p_pricing_context => OKC_PRICE_PUB.G_VOLUME_CONTEXT,
1174: p_pricing_attribute => OKC_PRICE_PUB.G_VOLUME_ATTR,
1175: p_pricing_attr_value => p_cp_line_tbl(i).item_qty,
1176: x_pattr_tbl => px_Req_line_attr_tbl);
1177: End If;

Line 1174: p_pricing_attribute => OKC_PRICE_PUB.G_VOLUME_ATTR,

1170:
1171: --- For usage items, QP requires quantity as pricing attr rather than item qty
1172: Load_Pattr_Tbl(p_line_index => l_line_index,
1173: p_pricing_context => OKC_PRICE_PUB.G_VOLUME_CONTEXT,
1174: p_pricing_attribute => OKC_PRICE_PUB.G_VOLUME_ATTR,
1175: p_pricing_attr_value => p_cp_line_tbl(i).item_qty,
1176: x_pattr_tbl => px_Req_line_attr_tbl);
1177: End If;
1178:

Line 1183: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,

1179: --- Load the Price list as qualifier For serviceable item since we know which price list to use
1180: --- We do not use modifier list For serviceable items
1181:
1182: Load_Qual_Tbl(p_line_index => l_line_index,
1183: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,
1184: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,
1185: p_qualifier_attr_value => p_price_list_id,
1186: x_qual_tbl => px_Req_qual_tbl);
1187: -- Commented out the following since core contracts will be passing exactly one

Line 1184: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,

1180: --- We do not use modifier list For serviceable items
1181:
1182: Load_Qual_Tbl(p_line_index => l_line_index,
1183: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,
1184: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,
1185: p_qualifier_attr_value => p_price_list_id,
1186: x_qual_tbl => px_Req_qual_tbl);
1187: -- Commented out the following since core contracts will be passing exactly one
1188: -- item and not multiple like the service contracts

Line 1194: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE := OKC_PRICE_PUB.G_REQUEST_TYPE_CODE;

1190: --- Load the service item
1191: l_line_index := l_line_index+1;
1192: px_req_line_tbl(l_line_index).LINE_INDEX := l_line_index;
1193: px_req_line_tbl(l_line_index).LINE_TYPE_CODE := 'LINE';
1194: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE := OKC_PRICE_PUB.G_REQUEST_TYPE_CODE;
1195: px_req_line_tbl(l_line_index).CURRENCY_CODE := p_Line_rec.currency_code;
1196: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := sysdate;
1197: px_req_line_tbl(l_line_index).ACTIVE_DATE_FIRST :=
1198: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE;

Line 1206: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,

1202: px_req_line_tbl(l_line_index).PRICE_FLAG := 'Y';
1203:
1204: --- Load the pricing attribute For service/usage item
1205: LOAD_PATTR_TBL(p_line_index => l_line_index,
1206: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,
1207: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,
1208: p_pricing_attr_value => p_line_rec.inventory_item_id,
1209: x_pattr_tbl => px_Req_line_attr_tbl);
1210:

Line 1207: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,

1203:
1204: --- Load the pricing attribute For service/usage item
1205: LOAD_PATTR_TBL(p_line_index => l_line_index,
1206: p_pricing_context => OKC_PRICE_PUB.G_ITEM_CONTEXT,
1207: p_pricing_attribute => OKC_PRICE_PUB.G_ITEM_ATTR,
1208: p_pricing_attr_value => p_line_rec.inventory_item_id,
1209: x_pattr_tbl => px_Req_line_attr_tbl);
1210:
1211: --- Load the Price list list as qualifier For service/usage item

Line 1213: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,

1209: x_pattr_tbl => px_Req_line_attr_tbl);
1210:
1211: --- Load the Price list list as qualifier For service/usage item
1212: Load_Qual_Tbl(p_line_index => l_line_index,
1213: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,
1214: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,
1215: p_qualifier_attr_value => p_price_list_id,
1216: x_qual_tbl => px_Req_qual_tbl);
1217:

Line 1214: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,

1210:
1211: --- Load the Price list list as qualifier For service/usage item
1212: Load_Qual_Tbl(p_line_index => l_line_index,
1213: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,
1214: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_PRICE_ATTR,
1215: p_qualifier_attr_value => p_price_list_id,
1216: x_qual_tbl => px_Req_qual_tbl);
1217:
1218: --- Load the Modifier list list as qualifier For service item

Line 1221: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,

1217:
1218: --- Load the Modifier list list as qualifier For service item
1219: If p_modifier_list_id IS NOT NULL Then
1220: Load_Qual_Tbl(p_line_index => l_line_index,
1221: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,
1222: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_MODIFIER_ATTR,
1223: p_qualifier_attr_value => p_modifier_list_id,
1224: x_qual_tbl => px_Req_qual_tbl);
1225: End If;

Line 1222: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_MODIFIER_ATTR,

1218: --- Load the Modifier list list as qualifier For service item
1219: If p_modifier_list_id IS NOT NULL Then
1220: Load_Qual_Tbl(p_line_index => l_line_index,
1221: p_qualifier_context => OKC_PRICE_PUB.G_LIST_CONTEXT,
1222: p_qualifier_attribute => OKC_PRICE_PUB.G_LIST_MODIFIER_ATTR,
1223: p_qualifier_attr_value => p_modifier_list_id,
1224: x_qual_tbl => px_Req_qual_tbl);
1225: End If;
1226:

Line 1245: Procedure Call_QP(p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,

1241: End Loop;
1242: End If;
1243: END Load_LineS;
1244:
1245: Procedure Call_QP(p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1246: p_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1247: p_get_pb_tbl_flag IN VARCHAR2,
1248: x_req_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 1246: p_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,

1242: End If;
1243: END Load_LineS;
1244:
1245: Procedure Call_QP(p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1246: p_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1247: p_get_pb_tbl_flag IN VARCHAR2,
1248: x_req_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

Line 1272: G_CONTROL_REC.pricing_event := OKC_PRICE_PUB.G_PRICING_EVENT;

1268: i Number;
1269:
1270: Begin
1271: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1272: G_CONTROL_REC.pricing_event := OKC_PRICE_PUB.G_PRICING_EVENT;
1273: G_CONTROL_REC.calculate_flag := 'Y';
1274: G_CONTROL_REC.simulation_flag := 'N';
1275:
1276: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => OKC_PRICE_PUB.G_REQUEST_TYPE_CODE,

Line 1276: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => OKC_PRICE_PUB.G_REQUEST_TYPE_CODE,

1272: G_CONTROL_REC.pricing_event := OKC_PRICE_PUB.G_PRICING_EVENT;
1273: G_CONTROL_REC.calculate_flag := 'Y';
1274: G_CONTROL_REC.simulation_flag := 'N';
1275:
1276: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => OKC_PRICE_PUB.G_REQUEST_TYPE_CODE,
1277: p_pricing_type => 'L',
1278: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
1279: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl);
1280:

Line 1575: 'OKC_PRICE_PUB.CALL_PRICE_ENGINE',

1571: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1572: -- Dbms_Output.Put_Line('Error is '|| sqlerrm);
1573: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
1574: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,
1575: 'OKC_PRICE_PUB.CALL_PRICE_ENGINE',
1576: sqlerrm);
1577: End If;
1578: END Call_QP;
1579: --

Line 1585: Procedure Calculate_Price(p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,

1581: Do we need the contract_cp_tbl?? It should have the same info as the line_rec ??
1582: === This api is called from ANOTHER calculat_Prcie API which sets the reqd info
1583: properly =====***/
1584:
1585: Procedure Calculate_Price(p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1586: px_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1587: px_message OUT NOCOPY VARCHAR2,
1588: x_return_status OUT NOCOPY VARCHAR2,
1589: x_msg_count OUT NOCOPY NUMBER,

Line 1586: px_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,

1582: === This api is called from ANOTHER calculat_Prcie API which sets the reqd info
1583: properly =====***/
1584:
1585: Procedure Calculate_Price(p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1586: px_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1587: px_message OUT NOCOPY VARCHAR2,
1588: x_return_status OUT NOCOPY VARCHAR2,
1589: x_msg_count OUT NOCOPY NUMBER,
1590: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1601: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE := p_contract_line_rec;

1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1598: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1599: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1600: l_idx NUMBER := 0;
1601: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE := p_contract_line_rec;
1602: Begin
1603: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1604: If nvl(p_contract_line_rec.record_built_flag, 'Y') = 'N' Then
1605: --- Build the contract line record so that it can be used in sourcing pricing attributes

Line 1747: px_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,

1743:
1744: Procedure Calculate_Price(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,
1745: p_cimv_tbl OKC_CONTRACT_ITEM_PUB.cimv_tbl_type,
1746: px_message OUT NOCOPY VARCHAR2,
1747: px_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1748: x_return_status OUT NOCOPY VARCHAR2,
1749: x_msg_count OUT NOCOPY NUMBER,
1750: x_msg_data OUT NOCOPY VARCHAR2) IS
1751: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;

Line 1751: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;

1747: px_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1748: x_return_status OUT NOCOPY VARCHAR2,
1749: x_msg_count OUT NOCOPY NUMBER,
1750: x_msg_data OUT NOCOPY VARCHAR2) IS
1751: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;
1752: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1753: l_price_list_id Number;
1754: l_inventory_item_id Number;
1755: l_uom_code Varchar2(3);

Line 1894: l_contract_cp_tbl OKC_PRICE_PUB.G_SLINE_TBL_TYPE;

1890: p_uom_code Varchar2,
1891: p_cur_code Varchar2,
1892: p_qty NUMBER := 1
1893: ) RETURN NUMBER IS
1894: l_contract_cp_tbl OKC_PRICE_PUB.G_SLINE_TBL_TYPE;
1895: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;
1896: x_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1897: x_message VARCHAR2(1000);
1898: x_msg_count NUMBER;

Line 1895: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;

1891: p_cur_code Varchar2,
1892: p_qty NUMBER := 1
1893: ) RETURN NUMBER IS
1894: l_contract_cp_tbl OKC_PRICE_PUB.G_SLINE_TBL_TYPE;
1895: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;
1896: x_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1897: x_message VARCHAR2(1000);
1898: x_msg_count NUMBER;
1899: x_msg_data VARCHAR2(2000);

Line 1933: p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,

1929: return NULL;
1930: END;
1931: --
1932: Procedure GET_PRICE_BREAK(
1933: p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1934: x_price_break_tbl OUT NOCOPY OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE,
1935: x_return_status OUT NOCOPY VARCHAR2,
1936: x_msg_count OUT NOCOPY NUMBER,
1937: x_msg_data OUT NOCOPY VARCHAR2)

Line 1934: x_price_break_tbl OUT NOCOPY OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE,

1930: END;
1931: --
1932: Procedure GET_PRICE_BREAK(
1933: p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1934: x_price_break_tbl OUT NOCOPY OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE,
1935: x_return_status OUT NOCOPY VARCHAR2,
1936: x_msg_count OUT NOCOPY NUMBER,
1937: x_msg_data OUT NOCOPY VARCHAR2)
1938: IS

Line 1940: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;

1936: x_msg_count OUT NOCOPY NUMBER,
1937: x_msg_data OUT NOCOPY VARCHAR2)
1938: IS
1939:
1940: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;
1941:
1942: ---- dummy table
1943: l_contract_cp_tbl OKC_PRICE_PUB.G_SLINE_TBL_TYPE;
1944: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1943: l_contract_cp_tbl OKC_PRICE_PUB.G_SLINE_TBL_TYPE;

1939:
1940: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE;
1941:
1942: ---- dummy table
1943: l_contract_cp_tbl OKC_PRICE_PUB.G_SLINE_TBL_TYPE;
1944: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1945: l_return_status_text varchar2(240) := NULL;
1946:
1947: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 1954: l_price_break_tbl OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE;

1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1952: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1953: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1954: l_price_break_tbl OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE;
1955: l_rel_index NUMBER;
1956:
1957: CURSOR puom_cur(p_inv_id NUMBER) IS
1958: select primary_uom_code from OKX_SYSTEM_ITEMS_V

Line 2497: END OKC_PRICE_PUB;

2493: END GET_INVOICE_TO_PARTY_SITE_ID;
2494:
2495: ---end added by smhanda----------------------------
2496:
2497: END OKC_PRICE_PUB;