eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_COUNTER_READING_LOCK_PKG dependencies on FND_API

Line 31: IF (px_READING_LOCK_ID IS NULL) OR (px_READING_LOCK_ID = FND_API.G_MISS_NUM) THEN

27: CURSOR C1 IS
28: SELECT CSI_CTR_READING_LOCKS_S.nextval
29: FROM dual;
30: BEGIN
31: IF (px_READING_LOCK_ID IS NULL) OR (px_READING_LOCK_ID = FND_API.G_MISS_NUM) THEN
32: OPEN C1;
33: FETCH C1 INTO px_READING_LOCK_ID;
34: CLOSE C1;
35: END IF;

Line 58: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)

54: ,SOURCE_DIST_REF_ID2
55: )
56: VALUES(
57: px_READING_LOCK_ID
58: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
59: ,decode(p_READING_LOCK_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_READING_LOCK_DATE)
60: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 59: ,decode(p_READING_LOCK_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_READING_LOCK_DATE)

55: )
56: VALUES(
57: px_READING_LOCK_ID
58: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
59: ,decode(p_READING_LOCK_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_READING_LOCK_DATE)
60: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

Line 60: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

56: VALUES(
57: px_READING_LOCK_ID
58: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
59: ,decode(p_READING_LOCK_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_READING_LOCK_DATE)
60: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

57: px_READING_LOCK_ID
58: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
59: ,decode(p_READING_LOCK_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_READING_LOCK_DATE)
60: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

Line 62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

58: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
59: ,decode(p_READING_LOCK_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_READING_LOCK_DATE)
60: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)

Line 63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

59: ,decode(p_READING_LOCK_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_READING_LOCK_DATE)
60: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)

Line 64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

60: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)

Line 65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

61: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)

Line 66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)

62: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)

Line 67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)

63: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
71: ,decode(p_SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)

Line 68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)

64: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
71: ,decode(p_SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
72: ,decode(p_SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)

Line 69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)

65: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
71: ,decode(p_SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
72: ,decode(p_SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
73: ,decode(p_SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)

Line 70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)

66: ,decode(p_SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
71: ,decode(p_SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
72: ,decode(p_SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
73: ,decode(p_SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)
74: );

Line 71: ,decode(p_SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)

67: ,decode(p_SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
71: ,decode(p_SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
72: ,decode(p_SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
73: ,decode(p_SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)
74: );
75: END Insert_Row;

Line 72: ,decode(p_SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)

68: ,decode(p_SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
71: ,decode(p_SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
72: ,decode(p_SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
73: ,decode(p_SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)
74: );
75: END Insert_Row;
76:

Line 73: ,decode(p_SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)

69: ,decode(p_SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
70: ,decode(p_SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
71: ,decode(p_SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
72: ,decode(p_SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
73: ,decode(p_SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)
74: );
75: END Insert_Row;
76:
77: PROCEDURE Update_Row(

Line 99: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)

95: ) IS
96: BEGIN
97: UPDATE CSI_COUNTER_READING_LOCKS
98: SET
99: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
100: ,READING_LOCK_DATE = decode(p_READING_LOCK_DATE, NULL, READING_LOCK_DATE, FND_API.G_MISS_DATE, NULL, p_READING_LOCK_DATE)
101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 100: ,READING_LOCK_DATE = decode(p_READING_LOCK_DATE, NULL, READING_LOCK_DATE, FND_API.G_MISS_DATE, NULL, p_READING_LOCK_DATE)

96: BEGIN
97: UPDATE CSI_COUNTER_READING_LOCKS
98: SET
99: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
100: ,READING_LOCK_DATE = decode(p_READING_LOCK_DATE, NULL, READING_LOCK_DATE, FND_API.G_MISS_DATE, NULL, p_READING_LOCK_DATE)
101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)

Line 101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

97: UPDATE CSI_COUNTER_READING_LOCKS
98: SET
99: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
100: ,READING_LOCK_DATE = decode(p_READING_LOCK_DATE, NULL, READING_LOCK_DATE, FND_API.G_MISS_DATE, NULL, p_READING_LOCK_DATE)
101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)

98: SET
99: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
100: ,READING_LOCK_DATE = decode(p_READING_LOCK_DATE, NULL, READING_LOCK_DATE, FND_API.G_MISS_DATE, NULL, p_READING_LOCK_DATE)
101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

Line 103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

99: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
100: ,READING_LOCK_DATE = decode(p_READING_LOCK_DATE, NULL, READING_LOCK_DATE, FND_API.G_MISS_DATE, NULL, p_READING_LOCK_DATE)
101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)

Line 104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)

100: ,READING_LOCK_DATE = decode(p_READING_LOCK_DATE, NULL, READING_LOCK_DATE, FND_API.G_MISS_DATE, NULL, p_READING_LOCK_DATE)
101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)

Line 105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)

Line 106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

102: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)

Line 107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)

103: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)

Line 108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)

104: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
112: ,SOURCE_LINE_REF = decode(p_SOURCE_LINE_REF, NULL, SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)

Line 109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)

105: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
112: ,SOURCE_LINE_REF = decode(p_SOURCE_LINE_REF, NULL, SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
113: ,SOURCE_DIST_REF_ID1 = decode(p_SOURCE_DIST_REF_ID1, NULL, SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)

Line 110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)

106: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
112: ,SOURCE_LINE_REF = decode(p_SOURCE_LINE_REF, NULL, SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
113: ,SOURCE_DIST_REF_ID1 = decode(p_SOURCE_DIST_REF_ID1, NULL, SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
114: ,SOURCE_DIST_REF_ID2 = decode(p_SOURCE_DIST_REF_ID2, NULL, SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)

Line 111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)

107: ,SOURCE_GROUP_REF_ID = decode(p_SOURCE_GROUP_REF_ID, NULL, SOURCE_GROUP_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_GROUP_REF_ID)
108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
112: ,SOURCE_LINE_REF = decode(p_SOURCE_LINE_REF, NULL, SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
113: ,SOURCE_DIST_REF_ID1 = decode(p_SOURCE_DIST_REF_ID1, NULL, SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
114: ,SOURCE_DIST_REF_ID2 = decode(p_SOURCE_DIST_REF_ID2, NULL, SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)
115: WHERE READING_LOCK_ID = p_READING_LOCK_ID;

Line 112: ,SOURCE_LINE_REF = decode(p_SOURCE_LINE_REF, NULL, SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)

108: ,SOURCE_GROUP_REF = decode(p_SOURCE_GROUP_REF, NULL, SOURCE_GROUP_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_GROUP_REF)
109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
112: ,SOURCE_LINE_REF = decode(p_SOURCE_LINE_REF, NULL, SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
113: ,SOURCE_DIST_REF_ID1 = decode(p_SOURCE_DIST_REF_ID1, NULL, SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
114: ,SOURCE_DIST_REF_ID2 = decode(p_SOURCE_DIST_REF_ID2, NULL, SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)
115: WHERE READING_LOCK_ID = p_READING_LOCK_ID;
116:

Line 113: ,SOURCE_DIST_REF_ID1 = decode(p_SOURCE_DIST_REF_ID1, NULL, SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)

109: ,SOURCE_HEADER_REF_ID = decode(p_SOURCE_HEADER_REF_ID, NULL, SOURCE_HEADER_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_HEADER_REF_ID)
110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
112: ,SOURCE_LINE_REF = decode(p_SOURCE_LINE_REF, NULL, SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
113: ,SOURCE_DIST_REF_ID1 = decode(p_SOURCE_DIST_REF_ID1, NULL, SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
114: ,SOURCE_DIST_REF_ID2 = decode(p_SOURCE_DIST_REF_ID2, NULL, SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)
115: WHERE READING_LOCK_ID = p_READING_LOCK_ID;
116:
117: If (SQL%NOTFOUND) then

Line 114: ,SOURCE_DIST_REF_ID2 = decode(p_SOURCE_DIST_REF_ID2, NULL, SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)

110: ,SOURCE_HEADER_REF = decode(p_SOURCE_HEADER_REF, NULL, SOURCE_HEADER_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_HEADER_REF)
111: ,SOURCE_LINE_REF_ID = decode(p_SOURCE_LINE_REF_ID, NULL, SOURCE_LINE_REF_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_REF_ID)
112: ,SOURCE_LINE_REF = decode(p_SOURCE_LINE_REF, NULL, SOURCE_LINE_REF, FND_API.G_MISS_CHAR, NULL, p_SOURCE_LINE_REF)
113: ,SOURCE_DIST_REF_ID1 = decode(p_SOURCE_DIST_REF_ID1, NULL, SOURCE_DIST_REF_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID1)
114: ,SOURCE_DIST_REF_ID2 = decode(p_SOURCE_DIST_REF_ID2, NULL, SOURCE_DIST_REF_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_DIST_REF_ID2)
115: WHERE READING_LOCK_ID = p_READING_LOCK_ID;
116:
117: If (SQL%NOTFOUND) then
118: RAISE NO_DATA_FOUND;