[Home] [Help]
118: v_cnt := 1;
119: IF (credit_rec.ic_flag = 'N' and NVL(credit_rec.ip_flag,'N') = 'N' ) THEN /* Modified for bug 6603869*/
120: FOR int_rec IN GetILine_Normal(credit_rec.proj_num) LOOP
121: IF (int_rec.allow_sales_credit_flag = 'Y') THEN
122: INSERT INTO ra_interface_salescredits
123: (interface_line_context,
124: interface_line_attribute1,
125: interface_line_attribute2,
126: interface_line_attribute3,
149: END LOOP;
150: ELSE
151: FOR int_rec IN GetILine_IC(credit_rec.proj_num) LOOP
152: IF (int_rec.allow_sales_credit_flag = 'Y') THEN
153: INSERT INTO ra_interface_salescredits
154: (interface_line_context,
155: interface_line_attribute1,
156: interface_line_attribute2,
157: interface_line_attribute3,
181: /* Added for bug 6958686 */
182: IF (NVL(credit_rec.ip_flag,'N') = 'Y' ) THEN
183: FOR int_rec IN GetILine_Normal(credit_rec.proj_num) LOOP
184: IF (int_rec.allow_sales_credit_flag = 'Y') THEN
185: INSERT INTO ra_interface_salescredits
186: (interface_line_context,
187: interface_line_attribute1,
188: interface_line_attribute2,
189: interface_line_attribute3,
220: FOR credit_def_rec IN GetDefaultCredits LOOP
221: IF (credit_def_rec.ic_flag = 'N' and NVL(credit_rec.ip_flag,'N') = 'N') THEN /* Modified for bug 6603869*/
222: FOR int_rec IN GetILine_Normal(credit_def_rec.proj_num) LOOP
223: IF (int_rec.allow_sales_credit_flag = 'Y') THEN
224: INSERT INTO ra_interface_salescredits
225: (interface_line_context,
226: interface_line_attribute1,
227: interface_line_attribute2,
228: interface_line_attribute3,
251: END LOOP;
252: ELSE
253: FOR int_rec IN GetILine_IC(credit_def_rec.proj_num) LOOP
254: IF (int_rec.allow_sales_credit_flag = 'Y') THEN
255: INSERT INTO ra_interface_salescredits
256: (interface_line_context,
257: interface_line_attribute1,
258: interface_line_attribute2,
259: interface_line_attribute3,
283: /* Added for bug 6958686 */
284: IF (NVL(credit_rec.ip_flag,'N') = 'Y' ) THEN
285: FOR int_rec IN GetILine_Normal(credit_rec.proj_num) LOOP
286: IF (int_rec.allow_sales_credit_flag = 'Y') THEN
287: INSERT INTO ra_interface_salescredits
288: (interface_line_context,
289: interface_line_attribute1,
290: interface_line_attribute2,
291: interface_line_attribute3,