APPS.OE_CONTRACT_UTIL dependencies on OE_PRICING_CONT_PUB

Line 12: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_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_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
13: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
15: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
16: )

Line 13: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
13: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
15: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
16: )
17: IS

Line 14: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
13: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
15: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
16: )
17: IS
18: BEGIN

Line 15: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
13: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
15: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
16: )
17: IS
18: BEGIN
19:

Line 211: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

207:
208: -- Procedure Apply_Attribute_Changes
209:
210: PROCEDURE Apply_Attribute_Changes
211: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
212: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
213: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
214: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
215: )

Line 212: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

208: -- Procedure Apply_Attribute_Changes
209:
210: PROCEDURE Apply_Attribute_Changes
211: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
212: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
213: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
214: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
215: )
216: IS

Line 213: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

209:
210: PROCEDURE Apply_Attribute_Changes
211: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
212: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
213: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
214: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
215: )
216: IS
217: BEGIN

Line 214: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type

210: PROCEDURE Apply_Attribute_Changes
211: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
212: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
213: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
214: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
215: )
216: IS
217: BEGIN
218:

Line 353: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

349:
350: -- Function Complete_Record
351:
352: FUNCTION Complete_Record
353: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
354: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
355: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
356: IS
357: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;

Line 354: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

350: -- Function Complete_Record
351:
352: FUNCTION Complete_Record
353: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
354: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
355: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
356: IS
357: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
358: BEGIN

Line 355: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type

351:
352: FUNCTION Complete_Record
353: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
354: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
355: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
356: IS
357: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
358: BEGIN
359:

Line 357: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;

353: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
354: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
355: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
356: IS
357: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
358: BEGIN
359:
360: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN
361: l_Contract_rec.agreement_id := p_old_Contract_rec.agreement_id;

Line 467: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

463:
464: -- Function Convert_Miss_To_Null
465:
466: FUNCTION Convert_Miss_To_Null
467: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
468: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
469: IS
470: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
471: BEGIN

Line 468: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type

464: -- Function Convert_Miss_To_Null
465:
466: FUNCTION Convert_Miss_To_Null
467: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
468: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
469: IS
470: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
471: BEGIN
472:

Line 470: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;

466: FUNCTION Convert_Miss_To_Null
467: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
468: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
469: IS
470: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
471: BEGIN
472:
473: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN
474: l_Contract_rec.agreement_id := NULL;

Line 580: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

576:
577: -- Procedure Update_Row
578:
579: PROCEDURE Update_Row
580: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
581: )
582: IS
583: BEGIN
584:

Line 633: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

629:
630: -- Procedure Insert_Row
631:
632: PROCEDURE Insert_Row
633: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
634: )
635: IS
636: BEGIN
637:

Line 745: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type

741: -- Function Query_Row
742:
743: FUNCTION Query_Row
744: ( p_pricing_contract_id IN NUMBER
745: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
746: IS
747: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
748: BEGIN
749:

Line 747: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

743: FUNCTION Query_Row
744: ( p_pricing_contract_id IN NUMBER
745: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
746: IS
747: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
748: BEGIN
749:
750: SELECT AGREEMENT_ID
751: , ATTRIBUTE1

Line 827: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

823: --
824:
825: PROCEDURE Lock_Row
826: ( x_return_status OUT VARCHAR2
827: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
828: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
829: )
830: IS
831: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 828: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type

824:
825: PROCEDURE Lock_Row
826: ( x_return_status OUT VARCHAR2
827: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
828: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
829: )
830: IS
831: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
832: BEGIN

Line 831: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

827: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
828: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
829: )
830: IS
831: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
832: BEGIN
833:
834: SELECT AGREEMENT_ID
835: , ATTRIBUTE1

Line 1087: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

1083:
1084: -- Function Get_Values
1085:
1086: FUNCTION Get_Values
1087: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1088: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1089: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1090: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1091: IS

Line 1088: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

1084: -- Function Get_Values
1085:
1086: FUNCTION Get_Values
1087: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1088: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1089: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1090: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1091: IS
1092: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;

Line 1089: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

1085:
1086: FUNCTION Get_Values
1087: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1088: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1089: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1090: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1091: IS
1092: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
1093: BEGIN

Line 1090: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type

1086: FUNCTION Get_Values
1087: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1088: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1089: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1090: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1091: IS
1092: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
1093: BEGIN
1094:

Line 1092: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;

1088: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
1089: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
1090: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1091: IS
1092: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
1093: BEGIN
1094:
1095: IF p_Contract_rec.agreement_id IS NOT NULL AND
1096: p_Contract_rec.agreement_id <> FND_API.G_MISS_NUM AND

Line 1132: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

1128:
1129: -- Function Get_Ids
1130:
1131: FUNCTION Get_Ids
1132: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1133: , p_Contract_val_rec IN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1134: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
1135: IS
1136: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 1133: , p_Contract_val_rec IN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type

1129: -- Function Get_Ids
1130:
1131: FUNCTION Get_Ids
1132: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1133: , p_Contract_val_rec IN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1134: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
1135: IS
1136: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1137: BEGIN

Line 1134: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type

1130:
1131: FUNCTION Get_Ids
1132: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1133: , p_Contract_val_rec IN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1134: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
1135: IS
1136: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1137: BEGIN
1138:

Line 1136: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1132: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1133: , p_Contract_val_rec IN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
1134: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
1135: IS
1136: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1137: BEGIN
1138:
1139: -- initialize return_status.
1140: