APPS.CSC_CUSTOMIZED_PLANS_PKG dependencies on FND_API

Line 24: -- 11-25-2002 bhroy FND_API default changes made, added check file comments and WHENEVER OSERROR EXIT FAILURE ROLLBACK

20: -- 08-29-2001 dejoseph Removed parameter party_status from procedure insert_row. This
21: -- column does not exist in the database. The merge status will
22: -- be determined from PLAN_STATUS_CODE.
23: -- 11-12-2002 bhroy NOCOPY changes made
24: -- 11-25-2002 bhroy FND_API default changes made, added check file comments and WHENEVER OSERROR EXIT FAILURE ROLLBACK
25: -- NOTE :
26: -- End of Comments
27:
28:

Line 81: if ( P_ID IS NOT NULL OR P_ID <> FND_API.G_MISS_NUM ) THEN

77: P_PLAN_ID IN NUMBER,
78: P_PARTY_ID IN NUMBER)
79: IS
80: BEGIN
81: if ( P_ID IS NOT NULL OR P_ID <> FND_API.G_MISS_NUM ) THEN
82: DELETE FROM CSC_CUSTOMIZED_PLANS
83: WHERE ID = p_ID;
84: elsif ( P_PLAN_ID IS NOT NULL OR P_PLAN_ID <> FND_API.G_MISS_NUM ) THEN
85: IF ( P_PARTY_ID IS NOT NULL OR P_PARTY_ID <> FND_API.G_MISS_NUM ) THEN

Line 84: elsif ( P_PLAN_ID IS NOT NULL OR P_PLAN_ID <> FND_API.G_MISS_NUM ) THEN

80: BEGIN
81: if ( P_ID IS NOT NULL OR P_ID <> FND_API.G_MISS_NUM ) THEN
82: DELETE FROM CSC_CUSTOMIZED_PLANS
83: WHERE ID = p_ID;
84: elsif ( P_PLAN_ID IS NOT NULL OR P_PLAN_ID <> FND_API.G_MISS_NUM ) THEN
85: IF ( P_PARTY_ID IS NOT NULL OR P_PARTY_ID <> FND_API.G_MISS_NUM ) THEN
86: DELETE FROM CSC_CUSTOMIZED_PLANS
87: WHERE PLAN_ID = P_PLAN_ID
88: AND PARTY_ID = P_PARTY_ID;

Line 85: IF ( P_PARTY_ID IS NOT NULL OR P_PARTY_ID <> FND_API.G_MISS_NUM ) THEN

81: if ( P_ID IS NOT NULL OR P_ID <> FND_API.G_MISS_NUM ) THEN
82: DELETE FROM CSC_CUSTOMIZED_PLANS
83: WHERE ID = p_ID;
84: elsif ( P_PLAN_ID IS NOT NULL OR P_PLAN_ID <> FND_API.G_MISS_NUM ) THEN
85: IF ( P_PARTY_ID IS NOT NULL OR P_PARTY_ID <> FND_API.G_MISS_NUM ) THEN
86: DELETE FROM CSC_CUSTOMIZED_PLANS
87: WHERE PLAN_ID = P_PLAN_ID
88: AND PARTY_ID = P_PARTY_ID;
89: ELSE