APPS.OE_AGREEMENT_UTIL dependencies on OE_PRICING_CONT_PUB

Line 12: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
13: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
15: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
16: )

Line 13: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
13: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
15: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
16: )
17: IS

Line 14: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
13: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
15: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
16: )
17: IS
18: BEGIN

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

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
13: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
15: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
16: )
17: IS
18: BEGIN
19:

Line 381: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

377:
378: -- Procedure Apply_Attribute_Changes
379:
380: PROCEDURE Apply_Attribute_Changes
381: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
382: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
383: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
384: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
385: )

Line 382: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

378: -- Procedure Apply_Attribute_Changes
379:
380: PROCEDURE Apply_Attribute_Changes
381: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
382: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
383: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
384: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
385: )
386: IS

Line 383: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

379:
380: PROCEDURE Apply_Attribute_Changes
381: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
382: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
383: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
384: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
385: )
386: IS
387: BEGIN

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

380: PROCEDURE Apply_Attribute_Changes
381: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
382: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
383: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
384: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
385: )
386: IS
387: BEGIN
388:

Line 650: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

646:
647: -- Function Complete_Record
648:
649: FUNCTION Complete_Record
650: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
651: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
652: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
653: IS
654: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;

Line 651: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

647: -- Function Complete_Record
648:
649: FUNCTION Complete_Record
650: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
651: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
652: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
653: IS
654: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
655: BEGIN

Line 652: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type

648:
649: FUNCTION Complete_Record
650: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
651: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
652: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
653: IS
654: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
655: BEGIN
656:

Line 654: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;

650: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
651: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
652: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
653: IS
654: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
655: BEGIN
656:
657: oe_debug_pub.add('Entering OE_Agreement_Util.Complete_Record');
658:

Line 863: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

859:
860: -- Function Convert_Miss_To_Null
861:
862: FUNCTION Convert_Miss_To_Null
863: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
864: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
865: IS
866: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
867: BEGIN

Line 864: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type

860: -- Function Convert_Miss_To_Null
861:
862: FUNCTION Convert_Miss_To_Null
863: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
864: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
865: IS
866: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
867: BEGIN
868:

Line 866: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;

862: FUNCTION Convert_Miss_To_Null
863: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
864: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
865: IS
866: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
867: BEGIN
868:
869: oe_debug_pub.add('Entering OE_Agreement_Util.Convert_Miss_To_Null');
870:

Line 1075: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

1071:
1072: -- Procedure Update_Row
1073:
1074: PROCEDURE Update_Row
1075: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1076: )
1077: IS
1078: BEGIN
1079:

Line 1232: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

1228:
1229: -- Procedure Insert_Row
1230:
1231: PROCEDURE Insert_Row
1232: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1233: )
1234: IS
1235: x_row_id VARCHAR2(240);
1236: x_result VARCHAR2(1);

Line 1568: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type

1564: -- Function Query_Row
1565:
1566: FUNCTION Query_Row
1567: ( p_agreement_id IN NUMBER
1568: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1569: IS
1570: BEGIN
1571:
1572: oe_debug_pub.add('Entering OE_Agreement_Util.Query_Row');

Line 1591: ) RETURN OE_Pricing_Cont_PUB.Agreement_Tbl_Type

1587: ( p_agreement_id IN NUMBER :=
1588: FND_API.G_MISS_NUM
1589: , p_pricing_contract_id IN NUMBER :=
1590: FND_API.G_MISS_NUM
1591: ) RETURN OE_Pricing_Cont_PUB.Agreement_Tbl_Type
1592: IS
1593: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1594: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
1595:

Line 1593: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1589: , p_pricing_contract_id IN NUMBER :=
1590: FND_API.G_MISS_NUM
1591: ) RETURN OE_Pricing_Cont_PUB.Agreement_Tbl_Type
1592: IS
1593: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1594: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
1595:
1596: CURSOR l_Agreement_csr IS
1597: SELECT ACCOUNTING_RULE_ID

Line 1594: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;

1590: FND_API.G_MISS_NUM
1591: ) RETURN OE_Pricing_Cont_PUB.Agreement_Tbl_Type
1592: IS
1593: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1594: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
1595:
1596: CURSOR l_Agreement_csr IS
1597: SELECT ACCOUNTING_RULE_ID
1598: , AGREEMENT_CONTACT_ID

Line 1779: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

1775: --
1776:
1777: PROCEDURE Lock_Row
1778: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1779: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1780: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1781: )
1782: IS
1783: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

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

1776:
1777: PROCEDURE Lock_Row
1778: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1779: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1780: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1781: )
1782: IS
1783: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1784: BEGIN

Line 1783: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1779: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1780: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1781: )
1782: IS
1783: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1784: BEGIN
1785:
1786: oe_debug_pub.add('Entering OE_Agreement_Util.Lock_Row');
1787:

Line 2269: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

2265:
2266: -- Function Get_Values
2267:
2268: FUNCTION Get_Values
2269: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2270: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2271: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2272: ) RETURN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2273: IS

Line 2270: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

2266: -- Function Get_Values
2267:
2268: FUNCTION Get_Values
2269: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2270: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2271: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2272: ) RETURN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2273: IS
2274: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;

Line 2271: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

2267:
2268: FUNCTION Get_Values
2269: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2270: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2271: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2272: ) RETURN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2273: IS
2274: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
2275: BEGIN

Line 2272: ) RETURN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type

2268: FUNCTION Get_Values
2269: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2270: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2271: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2272: ) RETURN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2273: IS
2274: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
2275: BEGIN
2276:

Line 2274: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;

2270: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2271: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2272: ) RETURN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2273: IS
2274: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
2275: BEGIN
2276:
2277: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Values');
2278:

Line 2463: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

2459:
2460: -- Function Get_Ids
2461:
2462: FUNCTION Get_Ids
2463: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2464: , p_Agreement_val_rec IN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2465: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2466: IS
2467: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 2464: , p_Agreement_val_rec IN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type

2460: -- Function Get_Ids
2461:
2462: FUNCTION Get_Ids
2463: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2464: , p_Agreement_val_rec IN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2465: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2466: IS
2467: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2468: BEGIN

Line 2465: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type

2461:
2462: FUNCTION Get_Ids
2463: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2464: , p_Agreement_val_rec IN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2465: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2466: IS
2467: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2468: BEGIN
2469:

Line 2467: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

2463: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2464: , p_Agreement_val_rec IN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
2465: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
2466: IS
2467: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2468: BEGIN
2469:
2470: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Ids');
2471: