APPS.LNS_DISB_HISTORIES_H_PKG dependencies on LNS_DISB_HISTORIES_H

Line 1: PACKAGE BODY LNS_DISB_HISTORIES_H_PKG AS

1: PACKAGE BODY LNS_DISB_HISTORIES_H_PKG AS
2: /* $Header: LNS_DSBHY_TBLH_B.pls 120.1 2005/07/01 08:31:41 scherkas noship $ */
3:
4: /* Insert_Row procedure */
5: PROCEDURE Insert_Row(

Line 23: INSERT INTO LNS_DISB_HISTORIES_H

19: ,P_LAST_UPDATED_BY IN NUMBER
20: ,P_LAST_UPDATE_LOGIN IN NUMBER
21: ) IS
22: BEGIN
23: INSERT INTO LNS_DISB_HISTORIES_H
24: (
25: DISB_HISTORY_ID
26: ,DISB_LINE_ID
27: ,ATTEMPT_NUMBER

Line 79: UPDATE LNS_DISB_HISTORIES_H SET

75: ,P_LAST_UPDATED_BY IN NUMBER
76: ,P_LAST_UPDATE_LOGIN IN NUMBER
77: ) IS
78: BEGIN
79: UPDATE LNS_DISB_HISTORIES_H SET
80: DISB_LINE_ID = DECODE(P_DISB_LINE_ID, NULL, DISB_LINE_ID, FND_API.G_MISS_NUM, NULL, P_DISB_LINE_ID)
81: ,ATTEMPT_NUMBER = DECODE(P_ATTEMPT_NUMBER, NULL, ATTEMPT_NUMBER, FND_API.G_MISS_NUM, NULL, P_ATTEMPT_NUMBER)
82: ,BANK_ACCOUNT_ID = DECODE(P_BANK_ACCOUNT_ID, NULL, BANK_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, P_BANK_ACCOUNT_ID)
83: ,PAYMENT_METHOD_CODE = DECODE(P_PAYMENT_METHOD_CODE, NULL, PAYMENT_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, P_PAYMENT_METHOD_CODE)

Line 102: DELETE FROM LNS_DISB_HISTORIES_H

98:
99: /* Delete_Row procedure */
100: PROCEDURE Delete_Row(P_DISB_HISTORY_ID IN NUMBER) IS
101: BEGIN
102: DELETE FROM LNS_DISB_HISTORIES_H
103: WHERE DISB_HISTORY_ID = P_DISB_HISTORY_ID;
104:
105: if (sql%notfound) then
106: raise no_data_found;

Line 128: CURSOR C IS SELECT * FROM LNS_DISB_HISTORIES_H

124: ,P_LAST_UPDATE_DATE IN DATE
125: ,P_LAST_UPDATED_BY IN NUMBER
126: ,P_LAST_UPDATE_LOGIN IN NUMBER
127: ) IS
128: CURSOR C IS SELECT * FROM LNS_DISB_HISTORIES_H
129: WHERE DISB_HISTORY_ID = P_DISB_HISTORY_ID
130: FOR UPDATE of DISB_HISTORY_ID NOWAIT;
131: Recinfo C%ROWTYPE;
132: BEGIN