APPS.IGI_SIA dependencies on AP_HOLDS

Line 25: INSERT INTO AP_HOLDS

21: null;
22: end;
23: /* bug # 5905278 end */
24:
25: INSERT INTO AP_HOLDS
26: ( INVOICE_ID
27: , HOLD_LOOKUP_CODE
28: , LAST_UPDATE_DATE
29: , LAST_UPDATED_BY

Line 48: , AP_HOLDS_S.nextval /* added for bug # 5905278 R12 Uptake of SIA */

44: , sysdate
45: , p_return_message
46: , sysdate
47: , p_LastUpdatedBy
48: , AP_HOLDS_S.nextval /* added for bug # 5905278 R12 Uptake of SIA */
49: , v_org_id /* added for bug # 5905278 R12 Uptake of SIA */
50: FROM sys.dual
51: WHERE NOT EXISTS ( SELECT 1
52: FROM ap_holds_all

Line 52: FROM ap_holds_all

48: , AP_HOLDS_S.nextval /* added for bug # 5905278 R12 Uptake of SIA */
49: , v_org_id /* added for bug # 5905278 R12 Uptake of SIA */
50: FROM sys.dual
51: WHERE NOT EXISTS ( SELECT 1
52: FROM ap_holds_all
53: WHERE invoice_id = p_InvoiceId
54: AND hold_lookup_code in ( 'AWAIT_SEC_APP',
55: 'AWAIT_PAY_APP')
56: AND release_lookup_code is NULL

Line 70: UPDATE AP_HOLDS

66: ) IS
67: --
68: BEGIN
69:
70: UPDATE AP_HOLDS
71: SET RELEASE_LOOKUP_CODE = 'MOD_RELEASE'
72: , RELEASE_REASON = 'Invoice Modified'
73: , LAST_UPDATE_DATE = sysdate
74: , LAST_UPDATED_BY = p_LastUpdatedBy

Line 116: From AP_HOLDS

112: AND NVL(match_status_flag,'N') <> 'A';
113:
114: CURSOR c1(p_hold VARCHAR2) IS
115: Select hold_lookup_code
116: From AP_HOLDS
117: Where invoice_id = p_inv_id
118: And hold_lookup_code = p_hold
119: And release_lookup_code is null;
120:

Line 128: From AP_HOLDS

124: Where Invoice_id = p_inv_id;
125:
126: CURSOR c3 IS
127: Select hold_lookup_code
128: From AP_HOLDS
129: Where invoice_id = p_inv_id
130: And hold_lookup_code = 'AWAIT_PAY_APP';
131:
132: CURSOR c4 IS

Line 138: l_hold_lookup_code AP_HOLDS.hold_lookup_code%TYPE;

134: From AP_INVOICE_DISTRIBUTIONS_ALL
135: Where Invoice_id = p_inv_id
136: and reversal_flag = 'Y';
137:
138: l_hold_lookup_code AP_HOLDS.hold_lookup_code%TYPE;
139: l_count NUMBER;
140: l_sum NUMBER;
141: l_reverse_flag_cnt NUMBER;
142:

Line 145: From AP_HOLDS

141: l_reverse_flag_cnt NUMBER;
142:
143: CURSOR cur_get_core_hold_count IS
144: Select COUNT(1)
145: From AP_HOLDS
146: Where invoice_id = p_inv_id
147: And hold_lookup_code <> 'AWAIT_SEC_APP'
148: And Release_Lookup_code is Null;
149:

Line 271: From AP_HOLDS

267: -- as cancellation adds more distribution lines i.e. same functionaliy as
268: -- amendment.
269: CURSOR c1 IS
270: Select hold_lookup_code
271: From AP_HOLDS
272: Where invoice_id = p_inv_id
273: And hold_lookup_code = 'AWAIT_PAY_APP';
274:
275: CURSOR c2 IS

Line 277: From AP_HOLDS

273: And hold_lookup_code = 'AWAIT_PAY_APP';
274:
275: CURSOR c2 IS
276: Select hold_lookup_code
277: From AP_HOLDS
278: Where invoice_id = p_inv_id
279: And hold_lookup_code = 'AWAIT_SEC_APP'
280: AND release_lookup_code = 'SEC_APP';
281:

Line 282: l_hold_lookup_code AP_HOLDS.hold_lookup_code%TYPE;

278: Where invoice_id = p_inv_id
279: And hold_lookup_code = 'AWAIT_SEC_APP'
280: AND release_lookup_code = 'SEC_APP';
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;