DBA Data[Home] [Help]

APPS.OE_VALIDATE_AGREEMENT dependencies on OE_PRICING_CONT_PUB

Line 9: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Agreement';
7:
8: FUNCTION Handle_Revision (
9: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
10: )
11: RETURN BOOLEAN ;
12:
13: FUNCTION Allow_Revision (

Line 14: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

10: )
11: RETURN BOOLEAN ;
12:
13: FUNCTION Allow_Revision (
14: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
15: )
16: RETURN BOOLEAN ;
17:
18: FUNCTION Check_EndDates (

Line 19: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

15: )
16: RETURN BOOLEAN ;
17:
18: FUNCTION Check_EndDates (
19: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
20: )
21: RETURN BOOLEAN ;
22:
23: --Begin code added by rchellam for OKC

Line 25: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

21: RETURN BOOLEAN ;
22:
23: --Begin code added by rchellam for OKC
24: FUNCTION Valid_Agreement_Source (
25: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
26: )
27: RETURN BOOLEAN;
28: --Begin code added by rchellam for OKC
29:

Line 31: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

27: RETURN BOOLEAN;
28: --Begin code added by rchellam for OKC
29:
30: FUNCTION Check_Dates (
31: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
32: )
33: RETURN BOOLEAN ;
34:
35: -- Procedure Entity

Line 39: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

35: -- Procedure Entity
36:
37: PROCEDURE Entity
38: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
40: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
41: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
42: )
43: IS

Line 40: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

36:
37: PROCEDURE Entity
38: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
40: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
41: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
42: )
43: IS
44: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 41: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

37: PROCEDURE Entity
38: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
40: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
41: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
42: )
43: IS
44: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
45: BEGIN

Line 285: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

281: -- Procedure Attributes
282:
283: PROCEDURE Attributes
284: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
285: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
286: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
287: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
288: )
289: IS

Line 286: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

282:
283: PROCEDURE Attributes
284: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
285: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
286: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
287: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
288: )
289: IS
290: BEGIN

Line 287: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

283: PROCEDURE Attributes
284: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
285: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
286: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
287: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
288: )
289: IS
290: BEGIN
291:

Line 807: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

803: -- Procedure Entity_Delete
804:
805: PROCEDURE Entity_Delete
806: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
807: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
808: )
809: IS
810: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
811: BEGIN

Line 848: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

844:
845:
846:
847: FUNCTION Check_EndDates (
848: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
849: )
850: RETURN BOOLEAN
851: IS
852: l_count NUMBER;

Line 898: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

894:
895: --
896:
897: FUNCTION Check_Dates (
898: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
899: )
900: RETURN BOOLEAN
901: IS
902: l_count NUMBER;

Line 941: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

937:
938: --
939:
940: FUNCTION Allow_Revision (
941: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
942: )
943: RETURN BOOLEAN
944: IS
945: l_count NUMBER;

Line 975: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

971:
972: --Begin code added by rchellam for OKC
973:
974: FUNCTION Valid_Agreement_Source (
975: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
976: )
977: RETURN BOOLEAN
978: IS
979: l_dummy VARCHAR2(10);

Line 1005: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

1001: --End code added by rchellam for OKC
1002:
1003:
1004: FUNCTION Handle_Revision (
1005: p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1006: )
1007: RETURN BOOLEAN
1008: IS
1009: l_dummy VARCHAR2(100);