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.OE_PRICING_CONT_PVT dependencies on OE_PRICING_CONT_PUB

Line 22: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

18: /*
19: PROCEDURE Contract
20: ( p_validation_level IN NUMBER
21: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
22: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
23: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
24: , x_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
25: , x_old_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
26: )

Line 23: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

19: PROCEDURE Contract
20: ( p_validation_level IN NUMBER
21: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
22: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
23: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
24: , x_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
25: , x_old_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
26: )
27: IS

Line 24: , x_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change

20: ( p_validation_level IN NUMBER
21: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
22: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
23: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
24: , x_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
25: , x_old_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
26: )
27: IS
28: l_return_status VARCHAR2(1);

Line 25: , x_old_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change

21: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
22: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
23: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
24: , x_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
25: , x_old_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
26: )
27: IS
28: l_return_status VARCHAR2(1);
29: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 30: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;

26: )
27: IS
28: l_return_status VARCHAR2(1);
29: l_control_rec OE_GLOBALS.Control_Rec_Type;
30: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
31: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
32: l_p_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type; --[prarasto]
33: BEGIN
34:

Line 31: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;

27: IS
28: l_return_status VARCHAR2(1);
29: l_control_rec OE_GLOBALS.Control_Rec_Type;
30: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
31: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
32: l_p_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type; --[prarasto]
33: BEGIN
34:
35: oe_debug_pub.add('------------------------------------------------');

Line 32: l_p_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type; --[prarasto]

28: l_return_status VARCHAR2(1);
29: l_control_rec OE_GLOBALS.Control_Rec_Type;
30: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
31: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
32: l_p_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type; --[prarasto]
33: BEGIN
34:
35: oe_debug_pub.add('------------------------------------------------');
36: oe_debug_pub.add('Entering Contract');

Line 291: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

287:
288: PROCEDURE Agreement
289: ( p_validation_level IN NUMBER
290: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
291: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
292: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
293: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
294: , x_old_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
295: )

Line 292: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

288: PROCEDURE Agreement
289: ( p_validation_level IN NUMBER
290: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
291: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
292: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
293: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
294: , x_old_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
295: )
296: IS

Line 293: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

289: ( p_validation_level IN NUMBER
290: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
291: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
292: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
293: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
294: , x_old_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
295: )
296: IS
297: l_return_status VARCHAR2(1);

Line 294: , x_old_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

290: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
291: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
292: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
293: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
294: , x_old_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
295: )
296: IS
297: l_return_status VARCHAR2(1);
298: l_Agreement_Delete_Flag BOOLEAN;

Line 303: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;

299: l_Agreement_Lines_Delete_Flag BOOLEAN;
300: l_Price_List_Exists_Flag BOOLEAN;
301: l_control_rec OE_GLOBALS.Control_Rec_Type;
302: --l_control_rec QP_GLOBALS.Control_Rec_Type;
303: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
304: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
305: l_old_price_list_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;
306: l_count_agr_qual NUMBER;
307:

Line 304: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;

300: l_Price_List_Exists_Flag BOOLEAN;
301: l_control_rec OE_GLOBALS.Control_Rec_Type;
302: --l_control_rec QP_GLOBALS.Control_Rec_Type;
303: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
304: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
305: l_old_price_list_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;
306: l_count_agr_qual NUMBER;
307:
308: /* For creating qualifiers */

Line 326: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]

322: l_commit VARCHAR2(1) := FND_API.G_FALSE;
323: l_msg_count NUMBER;
324: l_msg_data VARCHAR2(250);
325:
326: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
327: BEGIN
328:
329: oe_debug_pub.add('------------------------------------------------');
330: oe_debug_pub.add('Entering Agreement');

Line 1341: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

1337:
1338: PROCEDURE Price_Breaks
1339: ( p_validation_level IN NUMBER
1340: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1341: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1342: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1343: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1344: , x_old_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1345: )

Line 1342: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

1338: PROCEDURE Price_Breaks
1339: ( p_validation_level IN NUMBER
1340: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1341: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1342: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1343: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1344: , x_old_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1345: )
1346: IS

Line 1343: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

1339: ( p_validation_level IN NUMBER
1340: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1341: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1342: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1343: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1344: , x_old_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1345: )
1346: IS
1347: l_return_status VARCHAR2(1);

Line 1344: , x_old_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

1340: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1341: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1342: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1343: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1344: , x_old_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1345: )
1346: IS
1347: l_return_status VARCHAR2(1);
1348: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1349: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1345: )
1346: IS
1347: l_return_status VARCHAR2(1);
1348: l_control_rec OE_GLOBALS.Control_Rec_Type;
1349: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1350: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1351: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1352: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1353:

Line 1350: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1346: IS
1347: l_return_status VARCHAR2(1);
1348: l_control_rec OE_GLOBALS.Control_Rec_Type;
1349: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1350: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1351: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1352: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1353:
1354: l_p_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type; --[prarasto]

Line 1351: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1347: l_return_status VARCHAR2(1);
1348: l_control_rec OE_GLOBALS.Control_Rec_Type;
1349: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1350: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1351: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1352: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1353:
1354: l_p_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type; --[prarasto]
1355:

Line 1352: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1348: l_control_rec OE_GLOBALS.Control_Rec_Type;
1349: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1350: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1351: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1352: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1353:
1354: l_p_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type; --[prarasto]
1355:
1356: BEGIN

Line 1354: l_p_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type; --[prarasto]

1350: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1351: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1352: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1353:
1354: l_p_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type; --[prarasto]
1355:
1356: BEGIN
1357:
1358: oe_debug_pub.add('------------------------------------------------');

Line 1376: l_old_Price_Break_rec := OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC;

1372:
1373: IF l_old_Price_Break_tbl.EXISTS(I) THEN
1374: l_old_Price_Break_rec := l_old_Price_Break_tbl(I);
1375: ELSE
1376: l_old_Price_Break_rec := OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC;
1377: END IF;
1378:
1379: -- Load API control record
1380:

Line 1695: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

1691: OE_GLOBALS.G_MISS_CONTROL_REC
1692: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1693: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1694: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1695: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1696: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1697: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

Line 1696: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

1692: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1693: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1694: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1695: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1696: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1697: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

Line 1697: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

1693: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1694: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1695: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1696: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1697: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

Line 1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

1694: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1695: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1696: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1697: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

Line 1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

1695: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1696: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1697: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

Line 1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

1696: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1697: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC

Line 1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

1697: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

Line 1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

1698: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC

Line 1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

Line 1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

Line 1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

Line 1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

Line 1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

Line 1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

Line 1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

Line 1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

Line 1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

Line 1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

Line 1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

1719: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type

Line 1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

1720: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

Line 1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

1721: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

Line 1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

1722: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type

Line 1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type

1723: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

Line 1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

1724: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1732: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type

Line 1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type

1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1732: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
1733: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
1734: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

Line 1732: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type

1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1732: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
1733: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
1734: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1735: )
1736: IS

Line 1733: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1732: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
1733: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
1734: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1735: )
1736: IS
1737: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1734: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1732: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
1733: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
1734: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1735: )
1736: IS
1737: l_api_version_number CONSTANT NUMBER := 1.0;
1738: l_api_name CONSTANT VARCHAR2(30):= 'Process_Pricing_Cont';

Line 1741: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;

1737: l_api_version_number CONSTANT NUMBER := 1.0;
1738: l_api_name CONSTANT VARCHAR2(30):= 'Process_Pricing_Cont';
1739: l_return_status VARCHAR2(1);
1740: l_control_rec OE_GLOBALS.Control_Rec_Type;
1741: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
1742: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;

Line 1742: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;

1738: l_api_name CONSTANT VARCHAR2(30):= 'Process_Pricing_Cont';
1739: l_return_status VARCHAR2(1);
1740: l_control_rec OE_GLOBALS.Control_Rec_Type;
1741: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
1742: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;

Line 1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;

1739: l_return_status VARCHAR2(1);
1740: l_control_rec OE_GLOBALS.Control_Rec_Type;
1741: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
1742: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;

Line 1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;

1740: l_control_rec OE_GLOBALS.Control_Rec_Type;
1741: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
1742: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;
1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;

Line 1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;

1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;
1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;
1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;

1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;
1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;
1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1762: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1762: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1763: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1762: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1763: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1764: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1757: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1762: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1763: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1764: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1765: l_msg_data VARCHAR2(250);

Line 1762: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1758: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1762: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1763: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1764: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1765: l_msg_data VARCHAR2(250);
1766:

Line 1763: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1759: l_old_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1762: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1763: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1764: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1765: l_msg_data VARCHAR2(250);
1766:
1767: l_msg_count NUMBER;

Line 1764: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1760: l_old_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1761: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1762: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1763: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1764: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1765: l_msg_data VARCHAR2(250);
1766:
1767: l_msg_count NUMBER;
1768:

Line 1786: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]

1782: l_return_values VARCHAR2(1) := FND_API.G_FALSE;
1783: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1784: NO_UPDATE_PRIVILEGE EXCEPTION;
1785:
1786: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1787: l_p_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1788: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]

Line 1787: l_p_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]

1783: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1784: NO_UPDATE_PRIVILEGE EXCEPTION;
1785:
1786: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1787: l_p_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1788: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1791: l_p_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]

Line 1792: l_p_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]

1788: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1791: l_p_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1792: l_p_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1793: l_p_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1794:
1795: BEGIN
1796:

Line 1793: l_p_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]

1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1791: l_p_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1792: l_p_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1793: l_p_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1794:
1795: BEGIN
1796:
1797:

Line 2385: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

2381: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2382: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2383: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2384: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2385: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
2386: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
2387: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

Line 2386: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

2382: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2383: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2384: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2385: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
2386: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
2387: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC

Line 2387: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

2383: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2384: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2385: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
2386: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
2387: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC
2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

Line 2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

2384: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2385: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
2386: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
2387: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC
2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

Line 2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

2387: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC
2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

Line 2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC
2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

Line 2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

Line 2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

Line 2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type

Line 2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

Line 2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

Line 2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type

Line 2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type

2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

Line 2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2406: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type

Line 2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type

2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2406: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2407: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2408: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

Line 2406: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type

2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2406: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2407: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2408: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
2409: )
2410: IS

Line 2407: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2406: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2407: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2408: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
2409: )
2410: IS
2411: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2408: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2406: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2407: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2408: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
2409: )
2410: IS
2411: l_api_version_number CONSTANT NUMBER := 1.0;
2412: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Pricing_Cont';

Line 2415: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

2411: l_api_version_number CONSTANT NUMBER := 1.0;
2412: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Pricing_Cont';
2413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2414: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2415: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
2416: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
2417: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
2418: BEGIN
2419:

Line 2416: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

2412: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Pricing_Cont';
2413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2414: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2415: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
2416: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
2417: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
2418: BEGIN
2419:
2420: -- Standard call to check for call compatibility

Line 2417: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

2413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2414: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2415: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
2416: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
2417: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
2418: BEGIN
2419:
2420: -- Standard call to check for call compatibility
2421:

Line 2709: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type

2705: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2706: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2707: , p_pricing_contract_id IN NUMBER
2708: , p_name IN VARCHAR2
2709: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2710: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2711: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

Line 2710: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

2706: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2707: , p_pricing_contract_id IN NUMBER
2708: , p_name IN VARCHAR2
2709: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2710: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2711: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2714: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type

Line 2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type

2708: , p_name IN VARCHAR2
2709: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2710: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2711: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2714: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2715: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2716: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

Line 2714: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type

2710: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2711: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2714: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2715: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2716: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
2717: )
2718: IS

Line 2715: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

2711: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2714: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2715: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2716: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
2717: )
2718: IS
2719: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2716: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2714: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2715: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2716: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
2717: )
2718: IS
2719: l_api_version_number CONSTANT NUMBER := 1.0;
2720: l_api_name CONSTANT VARCHAR2(30):= 'Get_Pricing_Cont';

Line 2721: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

2717: )
2718: IS
2719: l_api_version_number CONSTANT NUMBER := 1.0;
2720: l_api_name CONSTANT VARCHAR2(30):= 'Get_Pricing_Cont';
2721: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
2722: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
2723: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;
2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 2722: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;

2718: IS
2719: l_api_version_number CONSTANT NUMBER := 1.0;
2720: l_api_name CONSTANT VARCHAR2(30):= 'Get_Pricing_Cont';
2721: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
2722: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
2723: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;
2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;

Line 2723: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

2719: l_api_version_number CONSTANT NUMBER := 1.0;
2720: l_api_name CONSTANT VARCHAR2(30):= 'Get_Pricing_Cont';
2721: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
2722: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
2723: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;
2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;
2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

Line 2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;

2722: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
2723: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;
2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;
2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

2723: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;
2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;
2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
2731: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;
2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
2731: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
2732: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2733: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2734: BEGIN

Line 2731: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
2731: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
2732: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2733: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2734: BEGIN
2735:

Line 2732: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
2731: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
2732: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2733: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2734: BEGIN
2735:
2736: -- Standard call to check for call compatibility

Line 2733: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
2731: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
2732: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2733: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2734: BEGIN
2735:
2736: -- Standard call to check for call compatibility
2737: