APPS.HZ_TIMEZONE_MAPPING_PKG dependencies on FND_API

Line 48: decode( x_AREA_CODE, FND_API.G_MISS_CHAR, NULL,x_AREA_CODE),

44: LAST_UPDATED_BY,
45: LAST_UPDATE_LOGIN
46: ) VALUES (
47: v_MAPPING_ID,
48: decode( x_AREA_CODE, FND_API.G_MISS_CHAR, NULL,x_AREA_CODE),
49: decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL,x_POSTAL_CODE),
50: decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),
51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),

Line 49: decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL,x_POSTAL_CODE),

45: LAST_UPDATE_LOGIN
46: ) VALUES (
47: v_MAPPING_ID,
48: decode( x_AREA_CODE, FND_API.G_MISS_CHAR, NULL,x_AREA_CODE),
49: decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL,x_POSTAL_CODE),
50: decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),
51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),

Line 50: decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),

46: ) VALUES (
47: v_MAPPING_ID,
48: decode( x_AREA_CODE, FND_API.G_MISS_CHAR, NULL,x_AREA_CODE),
49: decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL,x_POSTAL_CODE),
50: decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),
51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),

Line 51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),

47: v_MAPPING_ID,
48: decode( x_AREA_CODE, FND_API.G_MISS_CHAR, NULL,x_AREA_CODE),
49: decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL,x_POSTAL_CODE),
50: decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),
51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),

Line 52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),

48: decode( x_AREA_CODE, FND_API.G_MISS_CHAR, NULL,x_AREA_CODE),
49: decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL,x_POSTAL_CODE),
50: decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),
51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

Line 53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),

49: decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL,x_POSTAL_CODE),
50: decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),
51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
57: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),

Line 54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),

50: decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),
51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
57: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
58: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

Line 55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),

51: decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
57: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
58: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
59: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN));

Line 56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

52: decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
57: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
58: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
59: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN));
60: OPEN C;

Line 57: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),

53: decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
57: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
58: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
59: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN));
60: OPEN C;
61: FETCH C INTO v_Rowid;

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

54: decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
57: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
58: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
59: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN));
60: OPEN C;
61: FETCH C INTO v_Rowid;
62: If (C%NOTFOUND) then

Line 59: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN));

55: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
56: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
57: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
58: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
59: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN));
60: OPEN C;
61: FETCH C INTO v_Rowid;
62: If (C%NOTFOUND) then
63: CLOSE C;

Line 101: MAPPING_ID = decode( x_MAPPING_ID, FND_API.G_MISS_NUM,MAPPING_ID,x_MAPPING_ID),

97: ) IS
98: BEGIN
99: Update HZ_TIMEZONE_MAPPING
100: SET
101: MAPPING_ID = decode( x_MAPPING_ID, FND_API.G_MISS_NUM,MAPPING_ID,x_MAPPING_ID),
102: AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),
103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),
104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),

Line 102: AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),

98: BEGIN
99: Update HZ_TIMEZONE_MAPPING
100: SET
101: MAPPING_ID = decode( x_MAPPING_ID, FND_API.G_MISS_NUM,MAPPING_ID,x_MAPPING_ID),
102: AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),
103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),
104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),
106: PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),

Line 103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),

99: Update HZ_TIMEZONE_MAPPING
100: SET
101: MAPPING_ID = decode( x_MAPPING_ID, FND_API.G_MISS_NUM,MAPPING_ID,x_MAPPING_ID),
102: AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),
103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),
104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),
106: PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),
107: COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),

Line 104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),

100: SET
101: MAPPING_ID = decode( x_MAPPING_ID, FND_API.G_MISS_NUM,MAPPING_ID,x_MAPPING_ID),
102: AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),
103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),
104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),
106: PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),
107: COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),
108: TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),

Line 105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),

101: MAPPING_ID = decode( x_MAPPING_ID, FND_API.G_MISS_NUM,MAPPING_ID,x_MAPPING_ID),
102: AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),
103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),
104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),
106: PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),
107: COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),
108: TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),
109: -- Bug 3032780

Line 106: PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),

102: AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),
103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),
104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),
106: PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),
107: COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),
108: TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),
109: -- Bug 3032780
110: /*

Line 107: COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),

103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),
104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),
106: PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),
107: COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),
108: TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),
109: -- Bug 3032780
110: /*
111: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

Line 108: TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),

104: CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
105: STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),
106: PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),
107: COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),
108: TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),
109: -- Bug 3032780
110: /*
111: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
112: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

Line 111: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

107: COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),
108: TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),
109: -- Bug 3032780
110: /*
111: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
112: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
113: */
114: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
115: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 112: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

108: TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),
109: -- Bug 3032780
110: /*
111: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
112: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
113: */
114: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
115: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
116: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN)

Line 114: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

110: /*
111: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
112: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
113: */
114: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
115: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
116: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN)
117: where rowid = X_RowId;
118:

Line 115: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

111: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
112: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
113: */
114: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
115: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
116: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN)
117: where rowid = X_RowId;
118:
119: If (SQL%NOTFOUND) then

Line 116: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN)

112: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
113: */
114: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
115: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
116: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN)
117: where rowid = X_RowId;
118:
119: If (SQL%NOTFOUND) then
120: RAISE NO_DATA_FOUND;