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 263: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;

259: from iby_fndcpt_payer_assgn_instr_v
260: where instr_assignment_id = p_assignment_id;
261:
262: Cursor c_get_payment_id is
263: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;
264:
265: Cursor c_get_db_hdr_payment (p_qte_hdr_id NUMBER) is
266: select payment_id
267: from aso_payments

Line 267: from aso_payments

263: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;
264:
265: Cursor c_get_db_hdr_payment (p_qte_hdr_id NUMBER) is
266: select payment_id
267: from aso_payments
268: where quote_header_id = p_qte_hdr_id
269: and quote_line_id is null;
270:
271: Cursor c_get_db_line_payment (p_qte_hdr_id NUMBER, p_qte_line_id NUMBER) is

Line 273: from aso_payments

269: and quote_line_id is null;
270:
271: Cursor c_get_db_line_payment (p_qte_hdr_id NUMBER, p_qte_line_id NUMBER) is
272: select payment_id
273: from aso_payments
274: where quote_header_id = p_qte_hdr_id
275: and quote_line_id = p_qte_line_id;
276:
277: l_existing_payment_id number;

Line 558: ASO_PAYMENTS_PKG.Insert_Row(

554: aso_debug_pub.add('Before calling the table handler to insert the data ', 1, 'Y');
555: END IF;
556:
557:
558: ASO_PAYMENTS_PKG.Insert_Row(
559: px_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
560: p_CREATION_DATE => SYSDATE,
561: p_CREATED_BY => fnd_global.USER_ID,
562: p_LAST_UPDATE_DATE => SYSDATE,

Line 1379: ASO_PAYMENTS_PKG.Update_Row(

1375: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1376: aso_debug_pub.add('before calling the table handler to update the data ', 1, 'Y');
1377: END IF;
1378:
1379: ASO_PAYMENTS_PKG.Update_Row(
1380: p_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
1381: p_CREATION_DATE => l_payment_rec.creation_date,
1382: p_CREATED_BY => fnd_global.USER_ID,
1383: p_LAST_UPDATE_DATE => sysdate,

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

1585: END IF;
1586: end if;
1587: end if;
1588:
1589: ASO_PAYMENTS_PKG.Delete_Row(p_PAYMENT_ID => p_payment_rec.PAYMENT_ID);
1590:
1591: -- Standard check for p_commit
1592: /*IF FND_API.to_Boolean( p_commit )
1593: THEN