149:
150: l_cnt NUMBER;
151:
152: BEGIN
153: --Initialized inside BEGIN because of GSCC Standard - File.Sql.35
154:
155: l_hold_lookup_code := NULL;
156: l_reverse_flag_cnt := 0;
157: l_count := 0;
281:
282: l_hold_lookup_code AP_HOLDS.hold_lookup_code%TYPE;
283:
284: BEGIN
285: --Intialized variable inside BEGIN because of GSCC Standard - File.Sql.35
286: l_hold_lookup_code := NULL;
287:
288: IF FND_PROFILE.VALUE('IGI_SIA_PAYMENT_APP') = 'Y' THEN
289: OPEN c1;
306: IS
307: l_Var NUMBER(15);
308: p_invoice_Id NUMBER;
309: BEGIN
310: --Intialized variable inside BEGIN because of GSCC Standard - File.Sql.35
311: l_var := 0;
312: p_invoice_id := 0;
313:
314: FOR i in 1..l_TableRow
332: IS
333: l_Var NUMBER(15);
334: p_invoice_Id NUMBER;
335: BEGIN
336: --Intialized variable inside BEGIN because of GSCC Standard - File.Sql.35
337: l_var := 0;
338: p_invoice_id := 0;
339:
340: FOR i in 1..l_TableRow