APPS.LNS_LOAN_HISTORIES_H_PKG dependencies on LNS_LOAN_HISTORIES_H

Line 1: PACKAGE BODY LNS_LOAN_HISTORIES_H_PKG AS

1: PACKAGE BODY LNS_LOAN_HISTORIES_H_PKG AS
2: /* $Header: LNS_LNHIS_TBLH_B.pls 120.1 2005/10/03 12:33:59 gbellary noship $ */
3:
4: /* Insert_Row procedure */
5: PROCEDURE Insert_Row(

Line 30: INSERT INTO LNS_LOAN_HISTORIES_H

26: ,P_COLUMN_NAME => P_COLUMN_NAME
27: ,P_FROM_STATUS => P_OLD_VALUE
28: ,P_TO_STATUS => P_NEW_VALUE);
29: END IF;
30: INSERT INTO LNS_LOAN_HISTORIES_H
31: (
32: LOAN_HISTORY_ID
33: ,LOAN_ID
34: ,TABLE_NAME

Line 83: UPDATE LNS_LOAN_HISTORIES_H SET

79: ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
80: ,P_PRIMARY_KEY_ID IN NUMBER
81: ) IS
82: BEGIN
83: UPDATE LNS_LOAN_HISTORIES_H SET
84: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
85: ,TABLE_NAME = DECODE(P_TABLE_NAME, NULL, TABLE_NAME, FND_API.G_MISS_CHAR, NULL, P_TABLE_NAME)
86: ,COLUMN_NAME = DECODE(P_COLUMN_NAME, NULL, COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, P_COLUMN_NAME)
87: ,OLD_VALUE = DECODE(P_OLD_VALUE, NULL, OLD_VALUE, FND_API.G_MISS_CHAR, NULL, P_OLD_VALUE)

Line 105: DELETE FROM LNS_LOAN_HISTORIES_H

101:
102: /* Delete_Row procedure */
103: PROCEDURE Delete_Row(P_LOAN_HISTORY_ID IN NUMBER) IS
104: BEGIN
105: DELETE FROM LNS_LOAN_HISTORIES_H
106: WHERE LOAN_HISTORY_ID = P_LOAN_HISTORY_ID;
107:
108: if (sql%notfound) then
109: raise no_data_found;

Line 130: CURSOR C IS SELECT * FROM LNS_LOAN_HISTORIES_H

126: ,P_DATA_TYPE IN VARCHAR2 DEFAULT NULL
127: ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
128: ,P_PRIMARY_KEY_ID IN NUMBER
129: ) IS
130: CURSOR C IS SELECT * FROM LNS_LOAN_HISTORIES_H
131: WHERE LOAN_HISTORY_ID = P_LOAN_HISTORY_ID
132: FOR UPDATE of LOAN_HISTORY_ID NOWAIT;
133: Recinfo C%ROWTYPE;
134: BEGIN