APPS.HZ_INDUSTRIAL_REFERENCE_PKG dependencies on FND_API

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

44: PARTY_ID,
45: STATUS
46: ) VALUES (
47: x_INDUSTRY_REFERENCE_ID,
48: decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRY_REFERENCE),
49: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
50: decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_NAME_OF_REFERENCE),
51: decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_RECOGNIZED_AS_OF_DATE),
52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

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

45: STATUS
46: ) VALUES (
47: x_INDUSTRY_REFERENCE_ID,
48: decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRY_REFERENCE),
49: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
50: decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_NAME_OF_REFERENCE),
51: decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_RECOGNIZED_AS_OF_DATE),
52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

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

46: ) VALUES (
47: x_INDUSTRY_REFERENCE_ID,
48: decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRY_REFERENCE),
49: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
50: decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_NAME_OF_REFERENCE),
51: decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_RECOGNIZED_AS_OF_DATE),
52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

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

47: x_INDUSTRY_REFERENCE_ID,
48: decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRY_REFERENCE),
49: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
50: decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_NAME_OF_REFERENCE),
51: decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_RECOGNIZED_AS_OF_DATE),
52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

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

48: decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_INDUSTRY_REFERENCE),
49: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
50: decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_NAME_OF_REFERENCE),
51: decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_RECOGNIZED_AS_OF_DATE),
52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

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

49: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
50: decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_NAME_OF_REFERENCE),
51: decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_RECOGNIZED_AS_OF_DATE),
52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),

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

50: decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_NAME_OF_REFERENCE),
51: decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_RECOGNIZED_AS_OF_DATE),
52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),

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

51: decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_RECOGNIZED_AS_OF_DATE),
52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),

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

52: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
60: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),

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

53: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
60: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
61: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),

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

54: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
60: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
61: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
62: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),

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

55: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
60: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
61: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
62: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
63: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));

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

56: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
60: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
61: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
62: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
63: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));
64: OPEN C;

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

57: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
60: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
61: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
62: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
63: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));
64: OPEN C;
65: FETCH C INTO x_Rowid;

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

58: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
60: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
61: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
62: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
63: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));
64: OPEN C;
65: FETCH C INTO x_Rowid;
66: If (C%NOTFOUND) then

Line 63: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));

59: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
60: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
61: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
62: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
63: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));
64: OPEN C;
65: FETCH C INTO x_Rowid;
66: If (C%NOTFOUND) then
67: CLOSE C;

Line 109: INDUSTRY_REFERENCE_ID = decode( x_INDUSTRY_REFERENCE_ID, FND_API.G_MISS_NUM,INDUSTRY_REFERENCE_ID,x_INDUSTRY_REFERENCE_ID),

105: ) IS
106: BEGIN
107: Update HZ_INDUSTRIAL_REFERENCE
108: SET
109: INDUSTRY_REFERENCE_ID = decode( x_INDUSTRY_REFERENCE_ID, FND_API.G_MISS_NUM,INDUSTRY_REFERENCE_ID,x_INDUSTRY_REFERENCE_ID),
110: INDUSTRY_REFERENCE = decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR,INDUSTRY_REFERENCE,x_INDUSTRY_REFERENCE),
111: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
112: NAME_OF_REFERENCE = decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR,NAME_OF_REFERENCE,x_NAME_OF_REFERENCE),
113: RECOGNIZED_AS_OF_DATE = decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE,RECOGNIZED_AS_OF_DATE,x_RECOGNIZED_AS_OF_DATE),

Line 110: INDUSTRY_REFERENCE = decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR,INDUSTRY_REFERENCE,x_INDUSTRY_REFERENCE),

106: BEGIN
107: Update HZ_INDUSTRIAL_REFERENCE
108: SET
109: INDUSTRY_REFERENCE_ID = decode( x_INDUSTRY_REFERENCE_ID, FND_API.G_MISS_NUM,INDUSTRY_REFERENCE_ID,x_INDUSTRY_REFERENCE_ID),
110: INDUSTRY_REFERENCE = decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR,INDUSTRY_REFERENCE,x_INDUSTRY_REFERENCE),
111: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
112: NAME_OF_REFERENCE = decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR,NAME_OF_REFERENCE,x_NAME_OF_REFERENCE),
113: RECOGNIZED_AS_OF_DATE = decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE,RECOGNIZED_AS_OF_DATE,x_RECOGNIZED_AS_OF_DATE),
114: -- Bug 3032780

Line 111: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),

107: Update HZ_INDUSTRIAL_REFERENCE
108: SET
109: INDUSTRY_REFERENCE_ID = decode( x_INDUSTRY_REFERENCE_ID, FND_API.G_MISS_NUM,INDUSTRY_REFERENCE_ID,x_INDUSTRY_REFERENCE_ID),
110: INDUSTRY_REFERENCE = decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR,INDUSTRY_REFERENCE,x_INDUSTRY_REFERENCE),
111: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
112: NAME_OF_REFERENCE = decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR,NAME_OF_REFERENCE,x_NAME_OF_REFERENCE),
113: RECOGNIZED_AS_OF_DATE = decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE,RECOGNIZED_AS_OF_DATE,x_RECOGNIZED_AS_OF_DATE),
114: -- Bug 3032780
115: /*

Line 112: NAME_OF_REFERENCE = decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR,NAME_OF_REFERENCE,x_NAME_OF_REFERENCE),

108: SET
109: INDUSTRY_REFERENCE_ID = decode( x_INDUSTRY_REFERENCE_ID, FND_API.G_MISS_NUM,INDUSTRY_REFERENCE_ID,x_INDUSTRY_REFERENCE_ID),
110: INDUSTRY_REFERENCE = decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR,INDUSTRY_REFERENCE,x_INDUSTRY_REFERENCE),
111: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
112: NAME_OF_REFERENCE = decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR,NAME_OF_REFERENCE,x_NAME_OF_REFERENCE),
113: RECOGNIZED_AS_OF_DATE = decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE,RECOGNIZED_AS_OF_DATE,x_RECOGNIZED_AS_OF_DATE),
114: -- Bug 3032780
115: /*
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

Line 113: RECOGNIZED_AS_OF_DATE = decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE,RECOGNIZED_AS_OF_DATE,x_RECOGNIZED_AS_OF_DATE),

109: INDUSTRY_REFERENCE_ID = decode( x_INDUSTRY_REFERENCE_ID, FND_API.G_MISS_NUM,INDUSTRY_REFERENCE_ID,x_INDUSTRY_REFERENCE_ID),
110: INDUSTRY_REFERENCE = decode( x_INDUSTRY_REFERENCE, FND_API.G_MISS_CHAR,INDUSTRY_REFERENCE,x_INDUSTRY_REFERENCE),
111: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
112: NAME_OF_REFERENCE = decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR,NAME_OF_REFERENCE,x_NAME_OF_REFERENCE),
113: RECOGNIZED_AS_OF_DATE = decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE,RECOGNIZED_AS_OF_DATE,x_RECOGNIZED_AS_OF_DATE),
114: -- Bug 3032780
115: /*
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

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

112: NAME_OF_REFERENCE = decode( x_NAME_OF_REFERENCE, FND_API.G_MISS_CHAR,NAME_OF_REFERENCE,x_NAME_OF_REFERENCE),
113: RECOGNIZED_AS_OF_DATE = decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE,RECOGNIZED_AS_OF_DATE,x_RECOGNIZED_AS_OF_DATE),
114: -- Bug 3032780
115: /*
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: */
119: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

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

113: RECOGNIZED_AS_OF_DATE = decode( x_RECOGNIZED_AS_OF_DATE, FND_API.G_MISS_DATE,RECOGNIZED_AS_OF_DATE,x_RECOGNIZED_AS_OF_DATE),
114: -- Bug 3032780
115: /*
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: */
119: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

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

115: /*
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: */
119: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),

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

116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: */
119: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),

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

117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: */
119: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
125: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),

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

118: */
119: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
125: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
126: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),

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

119: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
125: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
126: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
127: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),

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

120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
125: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
126: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
127: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
128: STATUS =decode(x_STATUS,FND_API.G_MISS_CHAR,STATUS,x_STATUS)

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

121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
125: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
126: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
127: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
128: STATUS =decode(x_STATUS,FND_API.G_MISS_CHAR,STATUS,x_STATUS)
129: where rowid = X_RowId;

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

122: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
125: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
126: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
127: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
128: STATUS =decode(x_STATUS,FND_API.G_MISS_CHAR,STATUS,x_STATUS)
129: where rowid = X_RowId;
130:

Line 127: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),

123: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
125: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
126: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
127: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
128: STATUS =decode(x_STATUS,FND_API.G_MISS_CHAR,STATUS,x_STATUS)
129: where rowid = X_RowId;
130:
131: If (SQL%NOTFOUND) then

Line 128: STATUS =decode(x_STATUS,FND_API.G_MISS_CHAR,STATUS,x_STATUS)

124: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
125: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
126: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
127: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
128: STATUS =decode(x_STATUS,FND_API.G_MISS_CHAR,STATUS,x_STATUS)
129: where rowid = X_RowId;
130:
131: If (SQL%NOTFOUND) then
132: RAISE NO_DATA_FOUND;