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.OZF_OFFR_MARKET_OPTION_PKG dependencies on FND_API

Line 86: DECODE( px_offer_market_option_id, FND_API.G_MISS_NUM, NULL, px_offer_market_option_id)

82: , last_update_login
83: )
84: VALUES
85: (
86: DECODE( px_offer_market_option_id, FND_API.G_MISS_NUM, NULL, px_offer_market_option_id)
87: , DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id)
88: , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)
89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)

Line 87: , DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id)

83: )
84: VALUES
85: (
86: DECODE( px_offer_market_option_id, FND_API.G_MISS_NUM, NULL, px_offer_market_option_id)
87: , DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id)
88: , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)
89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)

Line 88: , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)

84: VALUES
85: (
86: DECODE( px_offer_market_option_id, FND_API.G_MISS_NUM, NULL, px_offer_market_option_id)
87: , DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id)
88: , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)
89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)

Line 89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)

85: (
86: DECODE( px_offer_market_option_id, FND_API.G_MISS_NUM, NULL, px_offer_market_option_id)
87: , DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id)
88: , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)
89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)

Line 90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)

86: DECODE( px_offer_market_option_id, FND_API.G_MISS_NUM, NULL, px_offer_market_option_id)
87: , DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id)
88: , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)
89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)

Line 91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)

87: , DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id)
88: , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)
89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)

Line 92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)

88: , DECODE( p_qp_list_header_id, FND_API.G_MISS_NUM, NULL, p_qp_list_header_id)
89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)

Line 93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)

89: , DECODE( p_group_number, FND_API.G_MISS_NUM, NULL, p_group_number)
90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)

Line 94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)

90: , DECODE( p_retroactive_flag, FND_API.g_miss_char, NULL, p_retroactive_flag)
91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)

Line 95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)

91: , DECODE( p_beneficiary_party_id, FND_API.G_MISS_NUM, NULL, p_beneficiary_party_id)
92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
99: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)

Line 96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)

92: , DECODE( p_combine_schedule_flag, FND_API.g_miss_char, NULL, p_combine_schedule_flag)
93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
99: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
100: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)

Line 97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)

93: , DECODE( p_volume_tracking_level_code, FND_API.g_miss_char, NULL, p_volume_tracking_level_code)
94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
99: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
100: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
101: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

Line 98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)

94: , DECODE( p_accrue_to_code, FND_API.g_miss_char, NULL, p_accrue_to_code)
95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
99: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
100: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
101: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
102: );

Line 99: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)

95: , DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence)
96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
99: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
100: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
101: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
102: );
103:

Line 100: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)

96: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
99: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
100: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
101: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
102: );
103:
104: END Insert_Row;

Line 101: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

97: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
98: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
99: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
100: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
101: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
102: );
103:
104: END Insert_Row;
105:

Line 142: offer_market_option_id = DECODE( p_offer_market_option_id, null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id),

138: IS
139: BEGIN
140: Update ozf_offr_market_options
141: SET
142: offer_market_option_id = DECODE( p_offer_market_option_id, null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id),
143: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),

Line 143: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),

139: BEGIN
140: Update ozf_offr_market_options
141: SET
142: offer_market_option_id = DECODE( p_offer_market_option_id, null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id),
143: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),

Line 144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),

140: Update ozf_offr_market_options
141: SET
142: offer_market_option_id = DECODE( p_offer_market_option_id, null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id),
143: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),

Line 145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),

141: SET
142: offer_market_option_id = DECODE( p_offer_market_option_id, null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id),
143: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),

Line 146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),

142: offer_market_option_id = DECODE( p_offer_market_option_id, null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id),
143: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),

Line 147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),

143: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),

Line 148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),

144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
152: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),

Line 149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),

145: group_number = DECODE( p_group_number, null, group_number, FND_API.G_MISS_NUM, null, p_group_number),
146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
152: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
153: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),

146: retroactive_flag = DECODE( p_retroactive_flag, null, retroactive_flag, FND_API.g_miss_char, null, p_retroactive_flag),
147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
152: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
153: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
154: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),

147: beneficiary_party_id = DECODE( p_beneficiary_party_id, null, beneficiary_party_id, FND_API.g_miss_num, null, p_beneficiary_party_id),
148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
152: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
153: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
154: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
155: object_version_number = nvl(p_object_version_number,0) + 1

Line 152: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),

148: combine_schedule_flag = DECODE( p_combine_schedule_flag, null, combine_schedule_flag, FND_API.g_miss_char, null, p_combine_schedule_flag),
149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
152: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
153: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
154: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
155: object_version_number = nvl(p_object_version_number,0) + 1
156: WHERE offer_market_option_id = p_offer_market_option_id

Line 153: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

149: volume_tracking_level_code = DECODE( p_volume_tracking_level_code, null, volume_tracking_level_code, FND_API.G_MISS_CHAR, null, p_volume_tracking_level_code),
150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
152: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
153: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
154: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
155: object_version_number = nvl(p_object_version_number,0) + 1
156: WHERE offer_market_option_id = p_offer_market_option_id
157: AND object_version_number = p_object_version_number;

Line 154: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

150: accrue_to_code = DECODE( p_accrue_to_code, null, accrue_to_code, FND_API.g_miss_char, null, p_accrue_to_code),
151: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
152: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
153: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
154: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
155: object_version_number = nvl(p_object_version_number,0) + 1
156: WHERE offer_market_option_id = p_offer_market_option_id
157: AND object_version_number = p_object_version_number;
158:

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: AND object_version_number = p_object_version_number;
158:
159:
160: IF (SQL%NOTFOUND) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163:
164:
165: END Update_Row;

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: DELETE FROM ozf_offr_market_options
185: WHERE offer_market_option_id = p_offer_market_option_id
186: AND object_version_number = p_object_version_number;
187: If (SQL%NOTFOUND) then
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: End If;
190: END Delete_Row ;
191:
192:

Line 223: RAISE FND_API.g_exc_error;

219: FETCH c INTO Recinfo;
220: IF (c%NOTFOUND) THEN
221: CLOSE c;
222: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
223: RAISE FND_API.g_exc_error;
224: END IF;
225: CLOSE c;
226: END Lock_Row;
227: