APPS.PV_PRGM_CONTRACTS_PKG dependencies on PV_PROGRAM_CONTRACTS

Line 63: INSERT INTO PV_PROGRAM_CONTRACTS(

59: IS
60:
61: BEGIN
62:
63: INSERT INTO PV_PROGRAM_CONTRACTS(
64: program_contracts_id
65: ,program_id
66: ,geo_hierarchy_id
67: ,contract_id

Line 119: Update PV_PROGRAM_CONTRACTS

115: )
116:
117: IS
118: BEGIN
119: Update PV_PROGRAM_CONTRACTS
120: SET
121: program_contracts_id = DECODE( p_program_contracts_id, NULL, program_contracts_id, FND_API.g_miss_num, NULL, p_program_contracts_id)
122: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
123: ,geo_hierarchy_id = DECODE( p_geo_hierarchy_id, NULL, geo_hierarchy_id, FND_API.g_miss_num, NULL, p_geo_hierarchy_id)

Line 165: DELETE FROM PV_PROGRAM_CONTRACTS

161: IS
162:
163: BEGIN
164:
165: DELETE FROM PV_PROGRAM_CONTRACTS
166: WHERE program_contracts_id = p_program_contracts_id
167: AND object_version_number = p_object_version_number;
168:
169: IF (SQL%NOTFOUND) THEN

Line 211: FROM PV_PROGRAM_CONTRACTS

207:
208: IS
209: CURSOR C IS
210: SELECT *
211: FROM PV_PROGRAM_CONTRACTS
212: WHERE program_contracts_id = px_program_contracts_id
213: FOR UPDATE of program_contracts_id NOWAIT;
214: Recinfo C%ROWTYPE;
215: