APPS.ASO_PAYMENT_INT dependencies on ASO_PAYMENTS

Line 24: select payment_term_id from aso_payments

20: ) RETURN NUMBER
21: IS
22:
23: cursor c_pay_term1 is
24: select payment_term_id from aso_payments
25: where quote_line_id = p_qte_line_id
26: and quote_header_id = p_qte_header_id;
27:
28: cursor c_pay_term2 is

Line 29: select payment_term_id from aso_payments

25: where quote_line_id = p_qte_line_id
26: and quote_header_id = p_qte_header_id;
27:
28: cursor c_pay_term2 is
29: select payment_term_id from aso_payments
30: where quote_header_id = p_qte_header_id;
31:
32: l_payment_term_id NUMBER;
33:

Line 271: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;

267: from iby_fndcpt_payer_assgn_instr_v
268: where instr_assignment_id = p_assignment_id;
269:
270: Cursor c_get_payment_id is
271: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;
272:
273: Cursor c_get_db_hdr_payment (p_qte_hdr_id NUMBER) is
274: select payment_id
275: from aso_payments

Line 275: from aso_payments

271: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;
272:
273: Cursor c_get_db_hdr_payment (p_qte_hdr_id NUMBER) is
274: select payment_id
275: from aso_payments
276: where quote_header_id = p_qte_hdr_id
277: and quote_line_id is null;
278:
279: Cursor c_get_db_line_payment (p_qte_hdr_id NUMBER, p_qte_line_id NUMBER) is

Line 281: from aso_payments

277: and quote_line_id is null;
278:
279: Cursor c_get_db_line_payment (p_qte_hdr_id NUMBER, p_qte_line_id NUMBER) is
280: select payment_id
281: from aso_payments
282: where quote_header_id = p_qte_hdr_id
283: and quote_line_id = p_qte_line_id;
284:
285: l_existing_payment_id number;

Line 566: ASO_PAYMENTS_PKG.Insert_Row(

562: aso_debug_pub.add('Before calling the table handler to insert the data ', 1, 'Y');
563: END IF;
564:
565:
566: ASO_PAYMENTS_PKG.Insert_Row(
567: px_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
568: p_CREATION_DATE => SYSDATE,
569: p_CREATED_BY => fnd_global.USER_ID,
570: p_LAST_UPDATE_DATE => SYSDATE,

Line 1477: ASO_PAYMENTS_PKG.Update_Row(

1473: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1474: aso_debug_pub.add('before calling the table handler to update the data ', 1, 'Y');
1475: END IF;
1476:
1477: ASO_PAYMENTS_PKG.Update_Row(
1478: p_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
1479: p_CREATION_DATE => l_payment_rec.creation_date,
1480: p_CREATED_BY => fnd_global.USER_ID,
1481: p_LAST_UPDATE_DATE => sysdate,

Line 1687: ASO_PAYMENTS_PKG.Delete_Row(p_PAYMENT_ID => p_payment_rec.PAYMENT_ID);

1683: END IF;
1684: end if;
1685: end if;
1686:
1687: ASO_PAYMENTS_PKG.Delete_Row(p_PAYMENT_ID => p_payment_rec.PAYMENT_ID);
1688:
1689: -- Standard check for p_commit
1690: /*IF FND_API.to_Boolean( p_commit )
1691: THEN

Line 1738: PROCEDURE PURGE_ASO_PAYMENTS_DATA IS

1734: ,X_RETURN_STATUS => X_RETURN_STATUS);
1735: End delete_payment_row;
1736:
1737: /* Code change for Bug 9746746 Start */
1738: PROCEDURE PURGE_ASO_PAYMENTS_DATA IS
1739:
1740: Begin
1741:
1742: UPDATE ASO_PAYMENTS

Line 1742: UPDATE ASO_PAYMENTS

1738: PROCEDURE PURGE_ASO_PAYMENTS_DATA IS
1739:
1740: Begin
1741:
1742: UPDATE ASO_PAYMENTS
1743: SET CREDIT_CARD_EXPIRATION_DATE = NULL,
1744: CREDIT_CARD_HOLDER_NAME = NULL,
1745: PAYMENT_REF_NUMBER = NULL
1746: WHERE PAYMENT_TYPE_CODE = 'CREDIT_CARD';

Line 1752: aso_debug_pub.ADD('Exception in PURGE_ASO_PAYMENTS_DATA, Sqlerrm :' || SQLERRM,1,'N');

1748: COMMIT;
1749:
1750: EXCEPTION
1751: WHEN OTHERS THEN
1752: aso_debug_pub.ADD('Exception in PURGE_ASO_PAYMENTS_DATA, Sqlerrm :' || SQLERRM,1,'N');
1753: aso_debug_pub.ADD('Exception in PURGE_ASO_PAYMENTS_DATA, SqlCode :' || SQLCODE,1,'N');
1754:
1755: End PURGE_ASO_PAYMENTS_DATA;
1756: /* Code change for Bug 9746746 End */

Line 1753: aso_debug_pub.ADD('Exception in PURGE_ASO_PAYMENTS_DATA, SqlCode :' || SQLCODE,1,'N');

1749:
1750: EXCEPTION
1751: WHEN OTHERS THEN
1752: aso_debug_pub.ADD('Exception in PURGE_ASO_PAYMENTS_DATA, Sqlerrm :' || SQLERRM,1,'N');
1753: aso_debug_pub.ADD('Exception in PURGE_ASO_PAYMENTS_DATA, SqlCode :' || SQLCODE,1,'N');
1754:
1755: End PURGE_ASO_PAYMENTS_DATA;
1756: /* Code change for Bug 9746746 End */
1757:

Line 1755: End PURGE_ASO_PAYMENTS_DATA;

1751: WHEN OTHERS THEN
1752: aso_debug_pub.ADD('Exception in PURGE_ASO_PAYMENTS_DATA, Sqlerrm :' || SQLERRM,1,'N');
1753: aso_debug_pub.ADD('Exception in PURGE_ASO_PAYMENTS_DATA, SqlCode :' || SQLCODE,1,'N');
1754:
1755: End PURGE_ASO_PAYMENTS_DATA;
1756: /* Code change for Bug 9746746 End */
1757:
1758: End ASO_PAYMENT_INT;