DBA Data[Home] [Help]

APPS.PV_PARTNER_PROGRAM_PKG dependencies on PV_PARTNER_PROGRAM_B

Line 123: INSERT INTO PV_PARTNER_PROGRAM_B(

119: IS
120:
121: BEGIN
122:
123: INSERT INTO PV_PARTNER_PROGRAM_B(
124: program_id
125: ,PROGRAM_TYPE_ID
126: ,custom_setup_id
127: ,program_level_code

Line 362: UPDATE PV_PARTNER_PROGRAM_B

358: PVX_Utility_PVT.debug_message('Within PV_PARTNER_PROGRAM_PKG.UPDATE_ROW API : object_version_number ' ||p_object_version_number );
359: END IF;
360:
361:
362: UPDATE PV_PARTNER_PROGRAM_B
363: SET
364:
365: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
366: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num, NULL , p_PROGRAM_TYPE_ID)

Line 474: UPDATE PV_PARTNER_PROGRAM_B

470: IS
471:
472: BEGIN
473:
474: UPDATE PV_PARTNER_PROGRAM_B
475: SET
476:
477: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
478: ,enabled_flag ='N'

Line 591: FROM PV_PARTNER_PROGRAM_B

587:
588: IS
589: CURSOR C IS
590: SELECT *
591: FROM PV_PARTNER_PROGRAM_B
592: WHERE PROGRAM_ID = px_program_id
593: FOR UPDATE of PROGRAM_ID NOWAIT;
594: Recinfo C%ROWTYPE;
595: