APPS.IGI_SIA dependencies on IGI_SIA

Line 1: PACKAGE BODY IGI_SIA AS

1: PACKAGE BODY IGI_SIA AS
2: -- $Header: igisiaab.pls 120.7.12000000.1 2007/09/12 11:47:09 mbremkum ship $
3: p_return_message VARCHAR2(240);
4:
5: PROCEDURE insert_sec_hold

Line 11: p_return_message := IGI_GEN.GET_LOOKUP_MEANING('IGI_SIA_AWAITING');

7: , p_LastUpdatedBy NUMBER
8: ) IS
9: v_org_id number(15,0);
10: BEGIN
11: p_return_message := IGI_GEN.GET_LOOKUP_MEANING('IGI_SIA_AWAITING');
12:
13: /* bug # 5905278 start R12 uptake of SIA - query to fetch the org_id */
14: begin
15: select org_id

Line 288: IF FND_PROFILE.VALUE('IGI_SIA_PAYMENT_APP') = 'Y' THEN

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;
290: FETCH c1 INTO l_hold_lookup_code;
291: IF c1%FOUND THEN
292: insert_sec_hold(p_inv_id,p_upd_by);

Line 319: IGI_SIA.PROCESS_INVOICE_HOLDS

315: LOOP
316: l_Var := l_Var + 1;
317: IF l_StatusTable(l_var) = 0 THEN
318: IF p_invoice_id <> l_InvoiceIdTable(l_var) THEN
319: IGI_SIA.PROCESS_INVOICE_HOLDS
320: ( l_InvoiceIdTable(l_Var)
321: , l_UpdatedByTable(l_Var)
322: );
323: p_invoice_id := l_InvoiceIdTable(l_Var);

Line 345: IGI_SIA.release_holds

341: LOOP
342: l_Var := l_Var + 1;
343: IF l_StatusTable(l_var) = 0 THEN
344: IF p_invoice_id <> l_InvoiceIdTable(l_var) THEN
345: IGI_SIA.release_holds
346: ( l_InvoiceIdTable(l_Var)
347: , l_UpdatedByTable(l_Var)
348: );
349: p_invoice_id := l_InvoiceIdTable(l_Var);