APPS.HZ_INDUSTRIAL_CLASSES_PKG dependencies on FND_API

Line 44: decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CODE_NAME),

40: PROGRAM_UPDATE_DATE,
41: WH_UPDATE_DATE
42: ) VALUES (
43: x_INDUSTRIAL_CLASS_ID,
44: decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CODE_NAME),
45: decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR, NULL,x_CODE_PRIMARY_SEGMENT),
46: decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CLASS_SOURCE),
47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

Line 45: decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR, NULL,x_CODE_PRIMARY_SEGMENT),

41: WH_UPDATE_DATE
42: ) VALUES (
43: x_INDUSTRIAL_CLASS_ID,
44: decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CODE_NAME),
45: decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR, NULL,x_CODE_PRIMARY_SEGMENT),
46: decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CLASS_SOURCE),
47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

Line 46: decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CLASS_SOURCE),

42: ) VALUES (
43: x_INDUSTRIAL_CLASS_ID,
44: decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CODE_NAME),
45: decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR, NULL,x_CODE_PRIMARY_SEGMENT),
46: decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CLASS_SOURCE),
47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

Line 47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),

43: x_INDUSTRIAL_CLASS_ID,
44: decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CODE_NAME),
45: decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR, NULL,x_CODE_PRIMARY_SEGMENT),
46: decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CLASS_SOURCE),
47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

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

44: decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CODE_NAME),
45: decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR, NULL,x_CODE_PRIMARY_SEGMENT),
46: decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CLASS_SOURCE),
47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

Line 49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

45: decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR, NULL,x_CODE_PRIMARY_SEGMENT),
46: decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CLASS_SOURCE),
47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),

Line 50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

46: decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRIAL_CLASS_SOURCE),
47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
54: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),

Line 51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

47: decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_CODE_DESCRIPTION),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
54: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
55: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),

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

48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
54: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
55: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
56: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),

Line 53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),

49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
54: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
55: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
56: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
57: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE));

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

50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
54: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
55: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
56: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
57: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE));
58: OPEN C;

Line 55: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),

51: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
54: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
55: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
56: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
57: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE));
58: OPEN C;
59: FETCH C INTO x_Rowid;

Line 56: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),

52: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
54: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
55: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
56: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
57: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE));
58: OPEN C;
59: FETCH C INTO x_Rowid;
60: If (C%NOTFOUND) then

Line 57: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE));

53: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
54: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
55: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
56: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
57: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE));
58: OPEN C;
59: FETCH C INTO x_Rowid;
60: If (C%NOTFOUND) then
61: CLOSE C;

Line 101: INDUSTRIAL_CLASS_ID = decode( x_INDUSTRIAL_CLASS_ID, FND_API.G_MISS_NUM,INDUSTRIAL_CLASS_ID,x_INDUSTRIAL_CLASS_ID),

97: ) IS
98: BEGIN
99: Update HZ_INDUSTRIAL_CLASSES
100: SET
101: INDUSTRIAL_CLASS_ID = decode( x_INDUSTRIAL_CLASS_ID, FND_API.G_MISS_NUM,INDUSTRIAL_CLASS_ID,x_INDUSTRIAL_CLASS_ID),
102: INDUSTRIAL_CODE_NAME = decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR,INDUSTRIAL_CODE_NAME,x_INDUSTRIAL_CODE_NAME),
103: CODE_PRIMARY_SEGMENT = decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR,CODE_PRIMARY_SEGMENT,x_CODE_PRIMARY_SEGMENT),
104: INDUSTRIAL_CLASS_SOURCE = decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR,INDUSTRIAL_CLASS_SOURCE,x_INDUSTRIAL_CLASS_SOURCE),
105: CODE_DESCRIPTION = decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR,CODE_DESCRIPTION,x_CODE_DESCRIPTION),

Line 102: INDUSTRIAL_CODE_NAME = decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR,INDUSTRIAL_CODE_NAME,x_INDUSTRIAL_CODE_NAME),

98: BEGIN
99: Update HZ_INDUSTRIAL_CLASSES
100: SET
101: INDUSTRIAL_CLASS_ID = decode( x_INDUSTRIAL_CLASS_ID, FND_API.G_MISS_NUM,INDUSTRIAL_CLASS_ID,x_INDUSTRIAL_CLASS_ID),
102: INDUSTRIAL_CODE_NAME = decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR,INDUSTRIAL_CODE_NAME,x_INDUSTRIAL_CODE_NAME),
103: CODE_PRIMARY_SEGMENT = decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR,CODE_PRIMARY_SEGMENT,x_CODE_PRIMARY_SEGMENT),
104: INDUSTRIAL_CLASS_SOURCE = decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR,INDUSTRIAL_CLASS_SOURCE,x_INDUSTRIAL_CLASS_SOURCE),
105: CODE_DESCRIPTION = decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR,CODE_DESCRIPTION,x_CODE_DESCRIPTION),
106: -- Bug 3032780

Line 103: CODE_PRIMARY_SEGMENT = decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR,CODE_PRIMARY_SEGMENT,x_CODE_PRIMARY_SEGMENT),

99: Update HZ_INDUSTRIAL_CLASSES
100: SET
101: INDUSTRIAL_CLASS_ID = decode( x_INDUSTRIAL_CLASS_ID, FND_API.G_MISS_NUM,INDUSTRIAL_CLASS_ID,x_INDUSTRIAL_CLASS_ID),
102: INDUSTRIAL_CODE_NAME = decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR,INDUSTRIAL_CODE_NAME,x_INDUSTRIAL_CODE_NAME),
103: CODE_PRIMARY_SEGMENT = decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR,CODE_PRIMARY_SEGMENT,x_CODE_PRIMARY_SEGMENT),
104: INDUSTRIAL_CLASS_SOURCE = decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR,INDUSTRIAL_CLASS_SOURCE,x_INDUSTRIAL_CLASS_SOURCE),
105: CODE_DESCRIPTION = decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR,CODE_DESCRIPTION,x_CODE_DESCRIPTION),
106: -- Bug 3032780
107: /*

Line 104: INDUSTRIAL_CLASS_SOURCE = decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR,INDUSTRIAL_CLASS_SOURCE,x_INDUSTRIAL_CLASS_SOURCE),

100: SET
101: INDUSTRIAL_CLASS_ID = decode( x_INDUSTRIAL_CLASS_ID, FND_API.G_MISS_NUM,INDUSTRIAL_CLASS_ID,x_INDUSTRIAL_CLASS_ID),
102: INDUSTRIAL_CODE_NAME = decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR,INDUSTRIAL_CODE_NAME,x_INDUSTRIAL_CODE_NAME),
103: CODE_PRIMARY_SEGMENT = decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR,CODE_PRIMARY_SEGMENT,x_CODE_PRIMARY_SEGMENT),
104: INDUSTRIAL_CLASS_SOURCE = decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR,INDUSTRIAL_CLASS_SOURCE,x_INDUSTRIAL_CLASS_SOURCE),
105: CODE_DESCRIPTION = decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR,CODE_DESCRIPTION,x_CODE_DESCRIPTION),
106: -- Bug 3032780
107: /*
108: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

Line 105: CODE_DESCRIPTION = decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR,CODE_DESCRIPTION,x_CODE_DESCRIPTION),

101: INDUSTRIAL_CLASS_ID = decode( x_INDUSTRIAL_CLASS_ID, FND_API.G_MISS_NUM,INDUSTRIAL_CLASS_ID,x_INDUSTRIAL_CLASS_ID),
102: INDUSTRIAL_CODE_NAME = decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR,INDUSTRIAL_CODE_NAME,x_INDUSTRIAL_CODE_NAME),
103: CODE_PRIMARY_SEGMENT = decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR,CODE_PRIMARY_SEGMENT,x_CODE_PRIMARY_SEGMENT),
104: INDUSTRIAL_CLASS_SOURCE = decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR,INDUSTRIAL_CLASS_SOURCE,x_INDUSTRIAL_CLASS_SOURCE),
105: CODE_DESCRIPTION = decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR,CODE_DESCRIPTION,x_CODE_DESCRIPTION),
106: -- Bug 3032780
107: /*
108: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
109: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

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

104: INDUSTRIAL_CLASS_SOURCE = decode( x_INDUSTRIAL_CLASS_SOURCE, FND_API.G_MISS_CHAR,INDUSTRIAL_CLASS_SOURCE,x_INDUSTRIAL_CLASS_SOURCE),
105: CODE_DESCRIPTION = decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR,CODE_DESCRIPTION,x_CODE_DESCRIPTION),
106: -- Bug 3032780
107: /*
108: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
109: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
110: */
111: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
112: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

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

105: CODE_DESCRIPTION = decode( x_CODE_DESCRIPTION, FND_API.G_MISS_CHAR,CODE_DESCRIPTION,x_CODE_DESCRIPTION),
106: -- Bug 3032780
107: /*
108: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
109: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
110: */
111: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
112: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
113: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

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

107: /*
108: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
109: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
110: */
111: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
112: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
113: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),

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

108: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
109: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
110: */
111: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
112: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
113: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
116: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),

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

109: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
110: */
111: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
112: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
113: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
116: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
117: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),

Line 114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),

110: */
111: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
112: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
113: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
116: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
117: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
118: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE)

Line 115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),

111: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
112: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
113: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
116: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
117: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
118: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE)
119: where rowid = X_RowId;

Line 116: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),

112: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
113: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
116: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
117: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
118: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE)
119: where rowid = X_RowId;
120:

Line 117: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),

113: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
116: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
117: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
118: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE)
119: where rowid = X_RowId;
120:
121: If (SQL%NOTFOUND) then

Line 118: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE)

114: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
115: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
116: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
117: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
118: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE)
119: where rowid = X_RowId;
120:
121: If (SQL%NOTFOUND) then
122: RAISE NO_DATA_FOUND;