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_ACCOUNT_ALLOCATIONS_PKG dependencies on FND_API

Line 72: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

68:
69:
70: BEGIN
71:
72: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
73: SELECT NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99)
74: INTO px_org_id
75: FROM DUAL;
76: END IF;

Line 122: DECODE( px_account_allocation_id, FND_API.G_MISS_NUM, NULL, px_account_allocation_id),

118: org_id
119: )
120: VALUES
121: (
122: DECODE( px_account_allocation_id, FND_API.G_MISS_NUM, NULL, px_account_allocation_id),
123: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
124: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),

Line 123: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),

119: )
120: VALUES
121: (
122: DECODE( px_account_allocation_id, FND_API.G_MISS_NUM, NULL, px_account_allocation_id),
123: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
124: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),

Line 124: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),

120: VALUES
121: (
122: DECODE( px_account_allocation_id, FND_API.G_MISS_NUM, NULL, px_account_allocation_id),
123: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
124: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),

Line 125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),

121: (
122: DECODE( px_account_allocation_id, FND_API.G_MISS_NUM, NULL, px_account_allocation_id),
123: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
124: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),

Line 126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),

122: DECODE( px_account_allocation_id, FND_API.G_MISS_NUM, NULL, px_account_allocation_id),
123: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
124: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),

Line 127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),

123: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
124: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),

Line 128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),

124: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),

Line 129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),

125: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),
133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),

Line 130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),

126: DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),
133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),

Line 131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),

127: DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),
133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),

Line 132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),

128: DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),
133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),

Line 133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),

129: DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),
133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),
137: px_object_version_number,

Line 134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),

130: DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),
133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),
137: px_object_version_number,
138: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),

131: DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),
133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),
137: px_object_version_number,
138: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
139: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),

132: DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_id),
133: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),
137: px_object_version_number,
138: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
139: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
140: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

134: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),
137: px_object_version_number,
138: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
139: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
140: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
141: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

135: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),
137: px_object_version_number,
138: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
139: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
140: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
141: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

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

136: DECODE( p_parent_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_allocation_id),
137: px_object_version_number,
138: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
139: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
140: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
141: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

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

137: px_object_version_number,
138: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
139: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
140: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
141: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

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

138: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
139: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
140: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
141: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

139: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
140: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
141: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

140: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
141: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

141: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

142: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

143: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

144: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

145: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

146: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

147: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

148: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
156: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

149: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
156: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
157: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

150: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
156: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
157: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
158: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

Line 155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

151: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
156: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
157: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
158: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
159: px_org_id

Line 156: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

152: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
156: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
157: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
158: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
159: px_org_id
160: );

Line 157: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

153: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
156: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
157: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
158: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
159: px_org_id
160: );
161:

Line 158: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

154: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
155: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
156: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
157: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
158: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
159: px_org_id
160: );
161:
162: END Insert_Row;

Line 220: account_allocation_id = DECODE( p_account_allocation_id, null, account_allocation_id, FND_API.G_MISS_NUM, null, p_account_allocation_id),

216: IS
217: BEGIN
218: Update ozf_account_allocations
219: SET
220: account_allocation_id = DECODE( p_account_allocation_id, null, account_allocation_id, FND_API.G_MISS_NUM, null, p_account_allocation_id),
221: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),

Line 221: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),

217: BEGIN
218: Update ozf_account_allocations
219: SET
220: account_allocation_id = DECODE( p_account_allocation_id, null, account_allocation_id, FND_API.G_MISS_NUM, null, p_account_allocation_id),
221: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),

Line 222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),

218: Update ozf_account_allocations
219: SET
220: account_allocation_id = DECODE( p_account_allocation_id, null, account_allocation_id, FND_API.G_MISS_NUM, null, p_account_allocation_id),
221: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),

Line 223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),

219: SET
220: account_allocation_id = DECODE( p_account_allocation_id, null, account_allocation_id, FND_API.G_MISS_NUM, null, p_account_allocation_id),
221: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),

Line 224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),

220: account_allocation_id = DECODE( p_account_allocation_id, null, account_allocation_id, FND_API.G_MISS_NUM, null, p_account_allocation_id),
221: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),

Line 225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),

221: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),

Line 226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),

222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),

Line 227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),

223: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),
231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),

Line 228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),

224: site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),
231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),

Line 229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),

225: site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),
231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),

Line 230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),

226: location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),
231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),

Line 231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),

227: bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),
231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),
235: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,

Line 232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),

228: bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),
231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),
235: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
236: 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 233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),

229: parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),
231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),
235: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
236: 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),
237: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),

230: rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_id),
231: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),
235: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
236: 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),
237: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
238: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 236: 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),

232: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),
235: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
236: 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),
237: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
238: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

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

233: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),
235: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
236: 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),
237: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
238: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

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

234: parent_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_allocation_id),
235: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
236: 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),
237: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
238: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

Line 239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

235: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
236: 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),
237: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
238: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

Line 240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

236: 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),
237: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
238: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

Line 241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

237: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
238: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

Line 242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

238: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

Line 243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

239: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

Line 244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

240: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

Line 245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

241: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

Line 246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

242: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

Line 247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

243: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

Line 248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

244: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
252: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

Line 249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

245: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
252: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
253: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

Line 250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

246: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
252: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
253: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
254: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

Line 251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

247: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
252: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
253: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
254: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
255: WHERE account_allocation_id = p_account_allocation_id;

Line 252: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

248: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
252: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
253: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
254: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
255: WHERE account_allocation_id = p_account_allocation_id;
256: -- AND object_version_number = p_object_version_number;

Line 253: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

249: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
252: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
253: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
254: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
255: WHERE account_allocation_id = p_account_allocation_id;
256: -- AND object_version_number = p_object_version_number;
257:

Line 254: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

250: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
251: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
252: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
253: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
254: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
255: WHERE account_allocation_id = p_account_allocation_id;
256: -- AND object_version_number = p_object_version_number;
257:
258:

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256: -- AND object_version_number = p_object_version_number;
257:
258:
259: IF (SQL%NOTFOUND) THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262:
263:
264: END Update_Row;

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

286: DELETE FROM ozf_account_allocations
287: WHERE account_allocation_id = p_account_allocation_id
288: AND object_version_number = p_object_version_number;
289: If (SQL%NOTFOUND) then
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: End If;
292: END Delete_Row ;
293:
294:

Line 328: RAISE FND_API.g_exc_error;

324: FETCH c INTO Recinfo;
325: IF (c%NOTFOUND) THEN
326: CLOSE c;
327: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
328: RAISE FND_API.g_exc_error;
329: END IF;
330: CLOSE c;
331: END Lock_Row;
332: