APPS.CSI_I_ASSETS_H_PKG dependencies on FND_API

Line 45: If (px_INSTANCE_ASSET_HISTORY_ID IS NULL) OR (px_INSTANCE_ASSET_HISTORY_ID = FND_API.G_MISS_NUM) then

41:
42: IS
43: CURSOR C2 IS SELECT CSI_I_ASSETS_H_S.nextval FROM sys.dual;
44: BEGIN
45: If (px_INSTANCE_ASSET_HISTORY_ID IS NULL) OR (px_INSTANCE_ASSET_HISTORY_ID = FND_API.G_MISS_NUM) then
46: OPEN C2;
47: FETCH C2 INTO px_INSTANCE_ASSET_HISTORY_ID;
48: CLOSE C2;
49: End If;

Line 85: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ASSET_ID),

81: OLD_ACTIVE_END_DATE,
82: NEW_ACTIVE_END_DATE
83: ) VALUES (
84: px_INSTANCE_ASSET_HISTORY_ID,
85: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ASSET_ID),
86: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
87: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),
88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),

Line 86: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),

82: NEW_ACTIVE_END_DATE
83: ) VALUES (
84: px_INSTANCE_ASSET_HISTORY_ID,
85: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ASSET_ID),
86: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
87: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),
88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),

Line 87: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),

83: ) VALUES (
84: px_INSTANCE_ASSET_HISTORY_ID,
85: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ASSET_ID),
86: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
87: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),
88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),

Line 88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),

84: px_INSTANCE_ASSET_HISTORY_ID,
85: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ASSET_ID),
86: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
87: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),
88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),

Line 89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),

85: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ASSET_ID),
86: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
87: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),
88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),

Line 90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),

86: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
87: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),
88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),

Line 91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),

87: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),
88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),

Line 92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),

88: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),

Line 93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),

89: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),

Line 94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),

90: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),

Line 95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),

91: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),

Line 96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),

92: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),

Line 97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),

93: decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),

Line 98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),

94: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),

Line 99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),

95: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),

Line 100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),

96: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),

Line 101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),

97: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),

Line 102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),

98: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),

99: decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

Line 104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),

100: decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),

101: decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

102: decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

103: decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),

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

104: decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),

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

105: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
113: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),

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

106: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
113: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
114: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),

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

107: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
113: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
114: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
115: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE));

Line 112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),

108: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
113: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
114: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
115: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE));
116: End Insert_Row;

Line 113: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),

109: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
113: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
114: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
115: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE));
116: End Insert_Row;
117:

Line 114: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),

110: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
113: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
114: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
115: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE));
116: End Insert_Row;
117:
118: PROCEDURE Update_Row(

Line 115: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE));

111: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
113: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
114: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
115: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE));
116: End Insert_Row;
117:
118: PROCEDURE Update_Row(
119: p_INSTANCE_ASSET_HISTORY_ID NUMBER,

Line 156: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, INSTANCE_ASSET_ID, p_INSTANCE_ASSET_ID),

152: IS
153: BEGIN
154: Update CSI_I_ASSETS_H
155: SET INSTANCE_ASSET_ID =
156: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, INSTANCE_ASSET_ID, p_INSTANCE_ASSET_ID),
157: TRANSACTION_ID =
158: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
159: OLD_INSTANCE_ID =
160: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_ID, p_OLD_INSTANCE_ID),

Line 158: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),

154: Update CSI_I_ASSETS_H
155: SET INSTANCE_ASSET_ID =
156: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, INSTANCE_ASSET_ID, p_INSTANCE_ASSET_ID),
157: TRANSACTION_ID =
158: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
159: OLD_INSTANCE_ID =
160: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_ID, p_OLD_INSTANCE_ID),
161: NEW_INSTANCE_ID =
162: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_ID, p_NEW_INSTANCE_ID),

Line 160: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_ID, p_OLD_INSTANCE_ID),

156: decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, INSTANCE_ASSET_ID, p_INSTANCE_ASSET_ID),
157: TRANSACTION_ID =
158: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
159: OLD_INSTANCE_ID =
160: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_ID, p_OLD_INSTANCE_ID),
161: NEW_INSTANCE_ID =
162: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_ID, p_NEW_INSTANCE_ID),
163: OLD_FA_ASSET_ID =
164: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, OLD_FA_ASSET_ID, p_OLD_FA_ASSET_ID),

Line 162: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_ID, p_NEW_INSTANCE_ID),

158: decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
159: OLD_INSTANCE_ID =
160: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_ID, p_OLD_INSTANCE_ID),
161: NEW_INSTANCE_ID =
162: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_ID, p_NEW_INSTANCE_ID),
163: OLD_FA_ASSET_ID =
164: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, OLD_FA_ASSET_ID, p_OLD_FA_ASSET_ID),
165: NEW_FA_ASSET_ID =
166: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NEW_FA_ASSET_ID, p_NEW_FA_ASSET_ID),

Line 164: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, OLD_FA_ASSET_ID, p_OLD_FA_ASSET_ID),

160: decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_ID, p_OLD_INSTANCE_ID),
161: NEW_INSTANCE_ID =
162: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_ID, p_NEW_INSTANCE_ID),
163: OLD_FA_ASSET_ID =
164: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, OLD_FA_ASSET_ID, p_OLD_FA_ASSET_ID),
165: NEW_FA_ASSET_ID =
166: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NEW_FA_ASSET_ID, p_NEW_FA_ASSET_ID),
167: OLD_ASSET_QUANTITY =
168: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, OLD_ASSET_QUANTITY, p_OLD_ASSET_QUANTITY),

Line 166: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NEW_FA_ASSET_ID, p_NEW_FA_ASSET_ID),

162: decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_ID, p_NEW_INSTANCE_ID),
163: OLD_FA_ASSET_ID =
164: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, OLD_FA_ASSET_ID, p_OLD_FA_ASSET_ID),
165: NEW_FA_ASSET_ID =
166: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NEW_FA_ASSET_ID, p_NEW_FA_ASSET_ID),
167: OLD_ASSET_QUANTITY =
168: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, OLD_ASSET_QUANTITY, p_OLD_ASSET_QUANTITY),
169: NEW_ASSET_QUANTITY =
170: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NEW_ASSET_QUANTITY, p_NEW_ASSET_QUANTITY),

Line 168: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, OLD_ASSET_QUANTITY, p_OLD_ASSET_QUANTITY),

164: decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, OLD_FA_ASSET_ID, p_OLD_FA_ASSET_ID),
165: NEW_FA_ASSET_ID =
166: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NEW_FA_ASSET_ID, p_NEW_FA_ASSET_ID),
167: OLD_ASSET_QUANTITY =
168: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, OLD_ASSET_QUANTITY, p_OLD_ASSET_QUANTITY),
169: NEW_ASSET_QUANTITY =
170: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NEW_ASSET_QUANTITY, p_NEW_ASSET_QUANTITY),
171: OLD_FA_BOOK_TYPE_CODE =
172: decode(p_OLD_FA_BOOK_TYPE_CODE,FND_API.G_MISS_CHAR,OLD_FA_BOOK_TYPE_CODE,p_OLD_FA_BOOK_TYPE_CODE),

Line 170: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NEW_ASSET_QUANTITY, p_NEW_ASSET_QUANTITY),

166: decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NEW_FA_ASSET_ID, p_NEW_FA_ASSET_ID),
167: OLD_ASSET_QUANTITY =
168: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, OLD_ASSET_QUANTITY, p_OLD_ASSET_QUANTITY),
169: NEW_ASSET_QUANTITY =
170: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NEW_ASSET_QUANTITY, p_NEW_ASSET_QUANTITY),
171: OLD_FA_BOOK_TYPE_CODE =
172: decode(p_OLD_FA_BOOK_TYPE_CODE,FND_API.G_MISS_CHAR,OLD_FA_BOOK_TYPE_CODE,p_OLD_FA_BOOK_TYPE_CODE),
173: NEW_FA_BOOK_TYPE_CODE =
174: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_FA_BOOK_TYPE_CODE, p_NEW_FA_BOOK_TYPE_CODE),

Line 172: decode(p_OLD_FA_BOOK_TYPE_CODE,FND_API.G_MISS_CHAR,OLD_FA_BOOK_TYPE_CODE,p_OLD_FA_BOOK_TYPE_CODE),

168: decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, OLD_ASSET_QUANTITY, p_OLD_ASSET_QUANTITY),
169: NEW_ASSET_QUANTITY =
170: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NEW_ASSET_QUANTITY, p_NEW_ASSET_QUANTITY),
171: OLD_FA_BOOK_TYPE_CODE =
172: decode(p_OLD_FA_BOOK_TYPE_CODE,FND_API.G_MISS_CHAR,OLD_FA_BOOK_TYPE_CODE,p_OLD_FA_BOOK_TYPE_CODE),
173: NEW_FA_BOOK_TYPE_CODE =
174: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_FA_BOOK_TYPE_CODE, p_NEW_FA_BOOK_TYPE_CODE),
175: OLD_FA_LOCATION_ID =
176: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, OLD_FA_LOCATION_ID, p_OLD_FA_LOCATION_ID),

Line 174: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_FA_BOOK_TYPE_CODE, p_NEW_FA_BOOK_TYPE_CODE),

170: decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NEW_ASSET_QUANTITY, p_NEW_ASSET_QUANTITY),
171: OLD_FA_BOOK_TYPE_CODE =
172: decode(p_OLD_FA_BOOK_TYPE_CODE,FND_API.G_MISS_CHAR,OLD_FA_BOOK_TYPE_CODE,p_OLD_FA_BOOK_TYPE_CODE),
173: NEW_FA_BOOK_TYPE_CODE =
174: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_FA_BOOK_TYPE_CODE, p_NEW_FA_BOOK_TYPE_CODE),
175: OLD_FA_LOCATION_ID =
176: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, OLD_FA_LOCATION_ID, p_OLD_FA_LOCATION_ID),
177: NEW_FA_LOCATION_ID =
178: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NEW_FA_LOCATION_ID, p_NEW_FA_LOCATION_ID),

Line 176: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, OLD_FA_LOCATION_ID, p_OLD_FA_LOCATION_ID),

172: decode(p_OLD_FA_BOOK_TYPE_CODE,FND_API.G_MISS_CHAR,OLD_FA_BOOK_TYPE_CODE,p_OLD_FA_BOOK_TYPE_CODE),
173: NEW_FA_BOOK_TYPE_CODE =
174: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_FA_BOOK_TYPE_CODE, p_NEW_FA_BOOK_TYPE_CODE),
175: OLD_FA_LOCATION_ID =
176: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, OLD_FA_LOCATION_ID, p_OLD_FA_LOCATION_ID),
177: NEW_FA_LOCATION_ID =
178: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NEW_FA_LOCATION_ID, p_NEW_FA_LOCATION_ID),
179: OLD_UPDATE_STATUS =
180: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, OLD_UPDATE_STATUS, p_OLD_UPDATE_STATUS),

Line 178: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NEW_FA_LOCATION_ID, p_NEW_FA_LOCATION_ID),

174: decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_FA_BOOK_TYPE_CODE, p_NEW_FA_BOOK_TYPE_CODE),
175: OLD_FA_LOCATION_ID =
176: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, OLD_FA_LOCATION_ID, p_OLD_FA_LOCATION_ID),
177: NEW_FA_LOCATION_ID =
178: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NEW_FA_LOCATION_ID, p_NEW_FA_LOCATION_ID),
179: OLD_UPDATE_STATUS =
180: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, OLD_UPDATE_STATUS, p_OLD_UPDATE_STATUS),
181: NEW_UPDATE_STATUS =
182: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NEW_UPDATE_STATUS, p_NEW_UPDATE_STATUS),

Line 180: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, OLD_UPDATE_STATUS, p_OLD_UPDATE_STATUS),

176: decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, OLD_FA_LOCATION_ID, p_OLD_FA_LOCATION_ID),
177: NEW_FA_LOCATION_ID =
178: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NEW_FA_LOCATION_ID, p_NEW_FA_LOCATION_ID),
179: OLD_UPDATE_STATUS =
180: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, OLD_UPDATE_STATUS, p_OLD_UPDATE_STATUS),
181: NEW_UPDATE_STATUS =
182: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NEW_UPDATE_STATUS, p_NEW_UPDATE_STATUS),
183: OLD_FA_SYNC_FLAG =
184: decode(p_old_fa_sync_flag, FND_API.g_miss_char, old_fa_sync_flag, p_old_fa_sync_flag),

Line 182: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NEW_UPDATE_STATUS, p_NEW_UPDATE_STATUS),

178: decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NEW_FA_LOCATION_ID, p_NEW_FA_LOCATION_ID),
179: OLD_UPDATE_STATUS =
180: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, OLD_UPDATE_STATUS, p_OLD_UPDATE_STATUS),
181: NEW_UPDATE_STATUS =
182: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NEW_UPDATE_STATUS, p_NEW_UPDATE_STATUS),
183: OLD_FA_SYNC_FLAG =
184: decode(p_old_fa_sync_flag, FND_API.g_miss_char, old_fa_sync_flag, p_old_fa_sync_flag),
185: NEW_FA_SYNC_FLAG =
186: decode(p_new_fa_sync_flag, FND_API.g_miss_char, new_fa_sync_flag, p_new_fa_sync_flag),

Line 184: decode(p_old_fa_sync_flag, FND_API.g_miss_char, old_fa_sync_flag, p_old_fa_sync_flag),

180: decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, OLD_UPDATE_STATUS, p_OLD_UPDATE_STATUS),
181: NEW_UPDATE_STATUS =
182: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NEW_UPDATE_STATUS, p_NEW_UPDATE_STATUS),
183: OLD_FA_SYNC_FLAG =
184: decode(p_old_fa_sync_flag, FND_API.g_miss_char, old_fa_sync_flag, p_old_fa_sync_flag),
185: NEW_FA_SYNC_FLAG =
186: decode(p_new_fa_sync_flag, FND_API.g_miss_char, new_fa_sync_flag, p_new_fa_sync_flag),
187: OLD_FA_MASS_ADDITION_ID =
188: decode(p_old_fa_mass_addition_id, FND_API.g_miss_num, old_fa_mass_addition_id, p_old_fa_mass_addition_id),

Line 186: decode(p_new_fa_sync_flag, FND_API.g_miss_char, new_fa_sync_flag, p_new_fa_sync_flag),

182: decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NEW_UPDATE_STATUS, p_NEW_UPDATE_STATUS),
183: OLD_FA_SYNC_FLAG =
184: decode(p_old_fa_sync_flag, FND_API.g_miss_char, old_fa_sync_flag, p_old_fa_sync_flag),
185: NEW_FA_SYNC_FLAG =
186: decode(p_new_fa_sync_flag, FND_API.g_miss_char, new_fa_sync_flag, p_new_fa_sync_flag),
187: OLD_FA_MASS_ADDITION_ID =
188: decode(p_old_fa_mass_addition_id, FND_API.g_miss_num, old_fa_mass_addition_id, p_old_fa_mass_addition_id),
189: NEW_FA_MASS_ADDITION_ID =
190: decode(p_new_fa_mass_addition_id, FND_API.g_miss_num, new_fa_mass_addition_id, p_new_fa_mass_addition_id),

Line 188: decode(p_old_fa_mass_addition_id, FND_API.g_miss_num, old_fa_mass_addition_id, p_old_fa_mass_addition_id),

184: decode(p_old_fa_sync_flag, FND_API.g_miss_char, old_fa_sync_flag, p_old_fa_sync_flag),
185: NEW_FA_SYNC_FLAG =
186: decode(p_new_fa_sync_flag, FND_API.g_miss_char, new_fa_sync_flag, p_new_fa_sync_flag),
187: OLD_FA_MASS_ADDITION_ID =
188: decode(p_old_fa_mass_addition_id, FND_API.g_miss_num, old_fa_mass_addition_id, p_old_fa_mass_addition_id),
189: NEW_FA_MASS_ADDITION_ID =
190: decode(p_new_fa_mass_addition_id, FND_API.g_miss_num, new_fa_mass_addition_id, p_new_fa_mass_addition_id),
191: OLD_CREATION_COMPLETE_FLAG =
192: decode(p_old_CREATION_COMPLETE_flag, FND_API.g_miss_char, old_CREATION_COMPLETE_flag, p_old_CREATION_COMPLETE_flag),

Line 190: decode(p_new_fa_mass_addition_id, FND_API.g_miss_num, new_fa_mass_addition_id, p_new_fa_mass_addition_id),

186: decode(p_new_fa_sync_flag, FND_API.g_miss_char, new_fa_sync_flag, p_new_fa_sync_flag),
187: OLD_FA_MASS_ADDITION_ID =
188: decode(p_old_fa_mass_addition_id, FND_API.g_miss_num, old_fa_mass_addition_id, p_old_fa_mass_addition_id),
189: NEW_FA_MASS_ADDITION_ID =
190: decode(p_new_fa_mass_addition_id, FND_API.g_miss_num, new_fa_mass_addition_id, p_new_fa_mass_addition_id),
191: OLD_CREATION_COMPLETE_FLAG =
192: decode(p_old_CREATION_COMPLETE_flag, FND_API.g_miss_char, old_CREATION_COMPLETE_flag, p_old_CREATION_COMPLETE_flag),
193: NEW_CREATION_COMPLETE_FLAG =
194: decode(p_new_CREATION_COMPLETE_flag, FND_API.g_miss_char, new_CREATION_COMPLETE_flag, p_new_CREATION_COMPLETE_flag),

Line 192: decode(p_old_CREATION_COMPLETE_flag, FND_API.g_miss_char, old_CREATION_COMPLETE_flag, p_old_CREATION_COMPLETE_flag),

188: decode(p_old_fa_mass_addition_id, FND_API.g_miss_num, old_fa_mass_addition_id, p_old_fa_mass_addition_id),
189: NEW_FA_MASS_ADDITION_ID =
190: decode(p_new_fa_mass_addition_id, FND_API.g_miss_num, new_fa_mass_addition_id, p_new_fa_mass_addition_id),
191: OLD_CREATION_COMPLETE_FLAG =
192: decode(p_old_CREATION_COMPLETE_flag, FND_API.g_miss_char, old_CREATION_COMPLETE_flag, p_old_CREATION_COMPLETE_flag),
193: NEW_CREATION_COMPLETE_FLAG =
194: decode(p_new_CREATION_COMPLETE_flag, FND_API.g_miss_char, new_CREATION_COMPLETE_flag, p_new_CREATION_COMPLETE_flag),
195: FULL_DUMP_FLAG =
196: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),

Line 194: decode(p_new_CREATION_COMPLETE_flag, FND_API.g_miss_char, new_CREATION_COMPLETE_flag, p_new_CREATION_COMPLETE_flag),

190: decode(p_new_fa_mass_addition_id, FND_API.g_miss_num, new_fa_mass_addition_id, p_new_fa_mass_addition_id),
191: OLD_CREATION_COMPLETE_FLAG =
192: decode(p_old_CREATION_COMPLETE_flag, FND_API.g_miss_char, old_CREATION_COMPLETE_flag, p_old_CREATION_COMPLETE_flag),
193: NEW_CREATION_COMPLETE_FLAG =
194: decode(p_new_CREATION_COMPLETE_flag, FND_API.g_miss_char, new_CREATION_COMPLETE_flag, p_new_CREATION_COMPLETE_flag),
195: FULL_DUMP_FLAG =
196: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
197: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
198: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 196: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),

192: decode(p_old_CREATION_COMPLETE_flag, FND_API.g_miss_char, old_CREATION_COMPLETE_flag, p_old_CREATION_COMPLETE_flag),
193: NEW_CREATION_COMPLETE_FLAG =
194: decode(p_new_CREATION_COMPLETE_flag, FND_API.g_miss_char, new_CREATION_COMPLETE_flag, p_new_CREATION_COMPLETE_flag),
195: FULL_DUMP_FLAG =
196: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
197: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
198: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
199: LAST_UPDATED_BY =
200: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

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

193: NEW_CREATION_COMPLETE_FLAG =
194: decode(p_new_CREATION_COMPLETE_flag, FND_API.g_miss_char, new_CREATION_COMPLETE_flag, p_new_CREATION_COMPLETE_flag),
195: FULL_DUMP_FLAG =
196: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
197: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
198: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
199: LAST_UPDATED_BY =
200: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
201: LAST_UPDATE_DATE =

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

194: decode(p_new_CREATION_COMPLETE_flag, FND_API.g_miss_char, new_CREATION_COMPLETE_flag, p_new_CREATION_COMPLETE_flag),
195: FULL_DUMP_FLAG =
196: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
197: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
198: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
199: LAST_UPDATED_BY =
200: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
201: LAST_UPDATE_DATE =
202: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 200: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

196: decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
197: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
198: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
199: LAST_UPDATED_BY =
200: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
201: LAST_UPDATE_DATE =
202: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
203: LAST_UPDATE_LOGIN =
204: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 202: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

198: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
199: LAST_UPDATED_BY =
200: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
201: LAST_UPDATE_DATE =
202: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
203: LAST_UPDATE_LOGIN =
204: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
205: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
206: OLD_ACTIVE_START_DATE =

Line 204: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

200: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
201: LAST_UPDATE_DATE =
202: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
203: LAST_UPDATE_LOGIN =
204: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
205: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
206: OLD_ACTIVE_START_DATE =
207: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
208: NEW_ACTIVE_START_DATE =

Line 207: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),

203: LAST_UPDATE_LOGIN =
204: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
205: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
206: OLD_ACTIVE_START_DATE =
207: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
208: NEW_ACTIVE_START_DATE =
209: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
210: OLD_ACTIVE_END_DATE =
211: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),

Line 209: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),

205: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
206: OLD_ACTIVE_START_DATE =
207: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
208: NEW_ACTIVE_START_DATE =
209: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
210: OLD_ACTIVE_END_DATE =
211: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),
212: NEW_ACTIVE_END_DATE =
213: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE)

Line 211: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),

207: decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
208: NEW_ACTIVE_START_DATE =
209: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
210: OLD_ACTIVE_END_DATE =
211: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),
212: NEW_ACTIVE_END_DATE =
213: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE)
214: WHERE INSTANCE_ASSET_HISTORY_ID = p_INSTANCE_ASSET_HISTORY_ID;
215:

Line 213: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE)

209: decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
210: OLD_ACTIVE_END_DATE =
211: decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),
212: NEW_ACTIVE_END_DATE =
213: decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE)
214: WHERE INSTANCE_ASSET_HISTORY_ID = p_INSTANCE_ASSET_HISTORY_ID;
215:
216: If (SQL%NOTFOUND) then
217: RAISE NO_DATA_FOUND;