eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PRGM_BENEFITS_PKG dependencies on FND_API

Line 74: -- DECODE( px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)

70: ,created_by
71: ,creation_date
72: ,object_version_number
73: ) VALUES (
74: -- DECODE( px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
75: -- ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)
76: -- ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)

Line 75: -- ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)

71: ,creation_date
72: ,object_version_number
73: ) VALUES (
74: -- DECODE( px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
75: -- ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)
76: -- ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)

Line 76: -- ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)

72: ,object_version_number
73: ) VALUES (
74: -- DECODE( px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
75: -- ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)
76: -- ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)

Line 77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)

73: ) VALUES (
74: -- DECODE( px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
75: -- ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)
76: -- ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)

Line 78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)

74: -- DECODE( px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
75: -- ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)
76: -- ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

Line 79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)

75: -- ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)
76: -- ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
83:

Line 80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)

76: -- ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
83:
84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)

Line 81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)

77: -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
83:
84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)

Line 82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

78: -- ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
79: -- ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
83:
84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)
86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)

Line 84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)

80: -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
83:
84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)
86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)

Line 85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)

81: -- ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
83:
84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)
86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)

Line 86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)

82: -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
83:
84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)
86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)

Line 87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)

83:
84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)
86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)

Line 88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)

84: DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)
86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)

Line 89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)

85: ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)
86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
93: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)

Line 90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)

86: ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
93: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
94: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)

Line 91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)

87: ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
93: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
94: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
95: ,DECODE( p_object_version_number, NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

Line 92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)

88: ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
93: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
94: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
95: ,DECODE( p_object_version_number, NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
96:

Line 93: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)

89: ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
93: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
94: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
95: ,DECODE( p_object_version_number, NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
96:
97: );

Line 94: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)

90: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
93: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
94: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
95: ,DECODE( p_object_version_number, NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
96:
97: );
98: END Insert_Row;

Line 95: ,DECODE( p_object_version_number, NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

91: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
92: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
93: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
94: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
95: ,DECODE( p_object_version_number, NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
96:
97: );
98: END Insert_Row;
99:

Line 130: -- program_benefits_id = DECODE( p_program_benefits_id, FND_API.g_miss_num, program_benefits_id, p_program_benefits_id)

126: IS
127: BEGIN
128: Update PV_PROGRAM_BENEFITS
129: SET
130: -- program_benefits_id = DECODE( p_program_benefits_id, FND_API.g_miss_num, program_benefits_id, p_program_benefits_id)
131: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)
133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)

Line 131: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)

127: BEGIN
128: Update PV_PROGRAM_BENEFITS
129: SET
130: -- program_benefits_id = DECODE( p_program_benefits_id, FND_API.g_miss_num, program_benefits_id, p_program_benefits_id)
131: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)
133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)

Line 132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)

128: Update PV_PROGRAM_BENEFITS
129: SET
130: -- program_benefits_id = DECODE( p_program_benefits_id, FND_API.g_miss_num, program_benefits_id, p_program_benefits_id)
131: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)
133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)

Line 133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)

129: SET
130: -- program_benefits_id = DECODE( p_program_benefits_id, FND_API.g_miss_num, program_benefits_id, p_program_benefits_id)
131: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)
133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)

Line 134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)

130: -- program_benefits_id = DECODE( p_program_benefits_id, FND_API.g_miss_num, program_benefits_id, p_program_benefits_id)
131: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)
133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)

Line 135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)

131: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)
133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)

Line 136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)

132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)
133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)

Line 137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)

133: -- ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)

Line 138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)

134: -- ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)

Line 139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)

135: -- ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)

Line 140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)

136: -- ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
144: ,object_version_number = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)

Line 141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)

137: program_benefits_id = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
144: ,object_version_number = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)
145: ,last_update_date = DECODE( p_last_update_date, NULL, last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)

Line 142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)

138: ,program_id = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
144: ,object_version_number = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)
145: ,last_update_date = DECODE( p_last_update_date, NULL, last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
146: ,last_updated_by = DECODE( p_last_updated_by, NULL, last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)

Line 143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)

139: ,benefit_code = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
144: ,object_version_number = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)
145: ,last_update_date = DECODE( p_last_update_date, NULL, last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
146: ,last_updated_by = DECODE( p_last_updated_by, NULL, last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
147:

Line 144: ,object_version_number = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)

140: ,benefit_id = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
144: ,object_version_number = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)
145: ,last_update_date = DECODE( p_last_update_date, NULL, last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
146: ,last_updated_by = DECODE( p_last_updated_by, NULL, last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
147:
148: WHERE PROGRAM_BENEFITS_ID = p_program_benefits_id

Line 145: ,last_update_date = DECODE( p_last_update_date, NULL, last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)

141: ,benefit_type_code = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
144: ,object_version_number = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)
145: ,last_update_date = DECODE( p_last_update_date, NULL, last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
146: ,last_updated_by = DECODE( p_last_updated_by, NULL, last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
147:
148: WHERE PROGRAM_BENEFITS_ID = p_program_benefits_id
149: AND object_version_number = p_object_version_number;

Line 146: ,last_updated_by = DECODE( p_last_updated_by, NULL, last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)

142: ,delete_flag = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
143: ,last_update_login = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
144: ,object_version_number = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)
145: ,last_update_date = DECODE( p_last_update_date, NULL, last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
146: ,last_updated_by = DECODE( p_last_updated_by, NULL, last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
147:
148: WHERE PROGRAM_BENEFITS_ID = p_program_benefits_id
149: AND object_version_number = p_object_version_number;
150:

Line 156: RAISE FND_API.g_exc_error;

152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
153: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
154: FND_MSG_PUB.add;
155: END IF;
156: RAISE FND_API.g_exc_error;
157: END IF;
158:
159: END Update_Row;
160:

Line 182: --program_benefits_id = DECODE( p_program_benefits_id, NULL ,program_benefits_id, FND_API.g_miss_num, NULL , p_program_benefits_id)

178: IS
179: BEGIN
180: UPDATE PV_PROGRAM_BENEFITS
181: SET
182: --program_benefits_id = DECODE( p_program_benefits_id, NULL ,program_benefits_id, FND_API.g_miss_num, NULL , p_program_benefits_id)
183: delete_flag ='Y'
184: ,last_update_date = SYSDATE
185: ,last_updated_by = FND_GLOBAL.user_id
186: ,last_update_login = FND_GLOBAL.conc_login_id

Line 187: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)

183: delete_flag ='Y'
184: ,last_update_date = SYSDATE
185: ,last_updated_by = FND_GLOBAL.user_id
186: ,last_update_login = FND_GLOBAL.conc_login_id
187: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)
188:
189: WHERE program_benefits_id = p_program_benefits_id
190: AND object_version_number = p_object_version_number;
191:

Line 197: RAISE FND_API.g_exc_error;

193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;
198: END IF;
199:
200: END Delete_Row ;
201: