DBA Data[Home] [Help]

APPS.CE_ZBA_DEAL_INF_PKG dependencies on CE_ZBA_DEAL_MESSAGES

Line 27: INSERT INTO CE_ZBA_DEAL_MESSAGES(

23: X_cashflows_created_flag VARCHAR2,
24: X_offset_deal_num NUMBER,
25: X_offset_transaction_num NUMBER) IS
26: BEGIN
27: INSERT INTO CE_ZBA_DEAL_MESSAGES(
28: application_short_name,
29: statement_header_id,
30: statement_line_id,
31: creation_date,

Line 61: INSERT INTO CE_ZBA_DEAL_MESSAGES(

57: PROCEDURE Insert_Row(X_statement_header_id NUMBER,
58: X_statement_line_id NUMBER,
59: X_message_name VARCHAR2) IS
60: BEGIN
61: INSERT INTO CE_ZBA_DEAL_MESSAGES(
62: application_short_name,
63: statement_header_id,
64: statement_line_id,
65: message_name,

Line 84: INSERT INTO CE_ZBA_DEAL_MESSAGES(

80: X_statement_line_id NUMBER,
81: X_message_name VARCHAR2,
82: X_application_short_name VARCHAR2) IS
83: BEGIN
84: INSERT INTO CE_ZBA_DEAL_MESSAGES(
85: application_short_name,
86: statement_header_id,
87: statement_line_id,
88: message_name,

Line 106: DELETE FROM CE_ZBA_DEAL_MESSAGES

102: PROCEDURE Delete_Row(X_statement_header_id NUMBER,
103: X_statement_line_id NUMBER) IS
104: BEGIN
105: IF X_statement_line_id IS NULL THEN
106: DELETE FROM CE_ZBA_DEAL_MESSAGES
107: WHERE statement_header_id = X_statement_header_id;
108: ELSE
109: DELETE FROM CE_ZBA_DEAL_MESSAGES
110: WHERE statement_line_id = X_statement_line_id;

Line 109: DELETE FROM CE_ZBA_DEAL_MESSAGES

105: IF X_statement_line_id IS NULL THEN
106: DELETE FROM CE_ZBA_DEAL_MESSAGES
107: WHERE statement_header_id = X_statement_header_id;
108: ELSE
109: DELETE FROM CE_ZBA_DEAL_MESSAGES
110: WHERE statement_line_id = X_statement_line_id;
111: END IF;
112: END Delete_Row;
113: