APPS.CE_LINE_INTERFACE_ERRORS_PKG dependencies on CE_LINE_INTERFACE_ERRORS

Line 1: PACKAGE BODY CE_LINE_INTERFACE_ERRORS_PKG as

1: PACKAGE BODY CE_LINE_INTERFACE_ERRORS_PKG as
2: /* $Header: celinteb.pls 120.1 2002/11/12 21:19:49 bhchung ship $ */
3: FUNCTION body_revision RETURN VARCHAR2 IS
4: BEGIN
5:

Line 23: INSERT INTO CE_LINE_INTERFACE_ERRORS(

19: X_bank_account_num VARCHAR2,
20: X_line_number NUMBER,
21: X_message_name VARCHAR2) IS
22: BEGIN
23: INSERT INTO CE_LINE_INTERFACE_ERRORS(
24: application_short_name,
25: statement_number,
26: bank_account_num,
27: line_number,

Line 48: INSERT INTO CE_LINE_INTERFACE_ERRORS(

44: X_line_number NUMBER,
45: X_message_name VARCHAR2,
46: X_application_short_name VARCHAR2) IS
47: BEGIN
48: INSERT INTO CE_LINE_INTERFACE_ERRORS(
49: application_short_name,
50: statement_number,
51: bank_account_num,
52: line_number,

Line 71: DELETE FROM CE_LINE_INTERFACE_ERRORS

67: X_bank_account_num VARCHAR2,
68: X_line_number NUMBER) IS
69: BEGIN
70: IF (X_line_number IS NOT NULL) THEN
71: DELETE FROM CE_LINE_INTERFACE_ERRORS
72: WHERE statement_number = X_statement_number AND
73: bank_account_num = X_bank_account_num AND
74: line_number = X_line_number;
75: ELSE

Line 76: DELETE FROM CE_LINE_INTERFACE_ERRORS

72: WHERE statement_number = X_statement_number AND
73: bank_account_num = X_bank_account_num AND
74: line_number = X_line_number;
75: ELSE
76: DELETE FROM CE_LINE_INTERFACE_ERRORS
77: WHERE statement_number = X_statement_number AND
78: bank_account_num = X_bank_account_num;
79: END IF;
80: END Delete_Row;

Line 82: END CE_LINE_INTERFACE_ERRORS_PKG;

78: bank_account_num = X_bank_account_num;
79: END IF;
80: END Delete_Row;
81:
82: END CE_LINE_INTERFACE_ERRORS_PKG;