DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on OE_PAYMENTS

Line 181: -- OE_Payments_Util.delete_row(p_line_id => p_line_id);

177: END IF;
178: OE_Holds_PUB.Delete_Holds(p_line_id => p_line_id );
179:
180: -- 1829201, commitment related changes.
181: -- OE_Payments_Util.delete_row(p_line_id => p_line_id);
182:
183: begin
184: select header_id
185: into l_header_id

Line 1004: l_delete_payment_count from oe_payments

1000:
1001: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1002: --R12 CC Encryption
1003: select count(payment_type_code) into
1004: l_delete_payment_count from oe_payments
1005: where header_id = p_x_line_rec.header_id
1006: and line_id = p_x_line_rec.line_id and
1007: payment_type_code in ('ACH','DIRECT_DEBIT','CREDIT_CARD');
1008:

Line 16139: FROM oe_payments

16135:
16136: BEGIN
16137: SELECT payment_type_code
16138: INTO l_line_payment_type_code
16139: FROM oe_payments
16140: WHERE header_id = p_x_line_rec.header_id
16141: AND line_id = p_x_line_rec.split_from_line_id
16142: AND payment_type_code IS NOT NULL
16143: AND rownum = 1;