APPS.IBY_IMPORT_PMT_ACK_DATA_PUB dependencies on IBY_PAYMENTS_ALL

Line 21: (p_payment_ref IN iby_payments_all.payment_reference_number%TYPE)

17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_IMPORT_PMT_ACK_DATA_PUB';
18:
19:
20: FUNCTION Payment_Reference_Exists
21: (p_payment_ref IN iby_payments_all.payment_reference_number%TYPE)
22: RETURN BOOLEAN
23: IS
24: l_count NUMBER;
25: l_dbg_mod VARCHAR2(100) := G_PKG_NAME || '.Payment_Reference_Exists';

Line 28: (ci_payment_ref IN iby_payments_all.payment_reference_number%TYPE)

24: l_count NUMBER;
25: l_dbg_mod VARCHAR2(100) := G_PKG_NAME || '.Payment_Reference_Exists';
26:
27: CURSOR c_pmt_reference
28: (ci_payment_ref IN iby_payments_all.payment_reference_number%TYPE)
29: IS
30: SELECT count(1)
31: FROM iby_payments_all
32: WHERE (payment_reference_number = ci_payment_ref);

Line 31: FROM iby_payments_all

27: CURSOR c_pmt_reference
28: (ci_payment_ref IN iby_payments_all.payment_reference_number%TYPE)
29: IS
30: SELECT count(1)
31: FROM iby_payments_all
32: WHERE (payment_reference_number = ci_payment_ref);
33:
34: BEGIN
35: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 131: (p_payment_ref IN iby_payments_all.payment_reference_number%TYPE)

127: END Get_Payment_Ack_ASatus;
128:
129:
130: FUNCTION Get_Payment_Id
131: (p_payment_ref IN iby_payments_all.payment_reference_number%TYPE)
132: RETURN NUMBER
133: IS
134: l_pmt_id NUMBER;
135: l_dbg_mod VARCHAR2(100) := G_PKG_NAME || '.Get_Payment_Id';

Line 138: (ci_payment_ref IN iby_payments_all.payment_reference_number%TYPE)

134: l_pmt_id NUMBER;
135: l_dbg_mod VARCHAR2(100) := G_PKG_NAME || '.Get_Payment_Id';
136:
137: CURSOR c_pmt_id
138: (ci_payment_ref IN iby_payments_all.payment_reference_number%TYPE)
139: IS
140: SELECT payment_id
141: FROM iby_payments_all
142: WHERE payment_reference_number = ci_payment_ref;

Line 141: FROM iby_payments_all

137: CURSOR c_pmt_id
138: (ci_payment_ref IN iby_payments_all.payment_reference_number%TYPE)
139: IS
140: SELECT payment_id
141: FROM iby_payments_all
142: WHERE payment_reference_number = ci_payment_ref;
143:
144: BEGIN
145: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 267: FROM iby_payments_all

263: INTO l_access
264: FROM dual
265: WHERE EXISTS
266: (SELECT NULL
267: FROM iby_payments_all
268: WHERE payment_reference_number = P_PAYMENT_REF_NUMBER
269: AND org_id <> -1
270: AND MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');
271:

Line 356: -- Update IBY_PAYMENTS_ALL set ACKNOWLEDGED_FLAG to Y

352: END IF;
353: END IF;
354:
355:
356: -- Update IBY_PAYMENTS_ALL set ACKNOWLEDGED_FLAG to Y
357:
358: UPDATE iby_payments_all
359: SET acknowledged_flag = 'Y'
360: WHERE (payment_reference_number = P_PAYMENT_REF_NUMBER);

Line 358: UPDATE iby_payments_all

354:
355:
356: -- Update IBY_PAYMENTS_ALL set ACKNOWLEDGED_FLAG to Y
357:
358: UPDATE iby_payments_all
359: SET acknowledged_flag = 'Y'
360: WHERE (payment_reference_number = P_PAYMENT_REF_NUMBER);
361:
362: