APPS.HZ_MERGE_BATCH_PKG dependencies on FND_API

Line 32: If (px_BATCH_ID IS NULL) OR (px_BATCH_ID = FND_API.G_MISS_NUM) then

28:
29: IS
30: CURSOR C2 IS SELECT HZ_MERGE_BATCH_S.nextval FROM sys.dual;
31: BEGIN
32: If (px_BATCH_ID IS NULL) OR (px_BATCH_ID = FND_API.G_MISS_NUM) then
33: OPEN C2;
34: FETCH C2 INTO px_BATCH_ID;
35: CLOSE C2;
36: End If;

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

49: LAST_UPDATE_DATE,
50: LAST_UPDATED_BY
51: ) VALUES (
52: px_BATCH_ID,
53: decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_SET_NAME),
54: decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME),
55: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),
57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),

Line 54: decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME),

50: LAST_UPDATED_BY
51: ) VALUES (
52: px_BATCH_ID,
53: decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_SET_NAME),
54: decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME),
55: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),
57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),
58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),

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

51: ) VALUES (
52: px_BATCH_ID,
53: decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_SET_NAME),
54: decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME),
55: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),
57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),
58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),
59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),

Line 56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),

52: px_BATCH_ID,
53: decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_SET_NAME),
54: decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME),
55: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),
57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),
58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),
59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),

53: decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_SET_NAME),
54: decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME),
55: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),
57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),
58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),
59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
61: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

Line 58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),

54: decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME),
55: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),
57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),
58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),
59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
61: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
62: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),

55: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),
57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),
58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),
59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
61: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
62: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
63: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

56: decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, NULL, p_BATCH_STATUS),
57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),
58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),
59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
61: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
62: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
63: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
64: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));

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

57: decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, NULL, p_BATCH_COMMIT),
58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),
59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
61: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
62: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
63: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
64: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));
65: End Insert_Row;

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

58: decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, NULL, p_BATCH_DELETE),
59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
61: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
62: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
63: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
64: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));
65: End Insert_Row;
66:

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

59: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
61: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
62: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
63: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
64: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));
65: End Insert_Row;
66:
67: PROCEDURE Update_Row(

Line 64: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));

60: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
61: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
62: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
63: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
64: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));
65: End Insert_Row;
66:
67: PROCEDURE Update_Row(
68: p_BATCH_ID NUMBER,

Line 86: RULE_SET_NAME = decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, RULE_SET_NAME, p_RULE_SET_NAME),

82: IS
83: BEGIN
84: Update HZ_MERGE_BATCH
85: SET
86: RULE_SET_NAME = decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, RULE_SET_NAME, p_RULE_SET_NAME),
87: BATCH_NAME = decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, BATCH_NAME, p_BATCH_NAME),
88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
89: BATCH_STATUS = decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, BATCH_STATUS, p_BATCH_STATUS),
90: BATCH_COMMIT = decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, BATCH_COMMIT, p_BATCH_COMMIT),

Line 87: BATCH_NAME = decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, BATCH_NAME, p_BATCH_NAME),

83: BEGIN
84: Update HZ_MERGE_BATCH
85: SET
86: RULE_SET_NAME = decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, RULE_SET_NAME, p_RULE_SET_NAME),
87: BATCH_NAME = decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, BATCH_NAME, p_BATCH_NAME),
88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
89: BATCH_STATUS = decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, BATCH_STATUS, p_BATCH_STATUS),
90: BATCH_COMMIT = decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, BATCH_COMMIT, p_BATCH_COMMIT),
91: BATCH_DELETE = decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, BATCH_DELETE, p_BATCH_DELETE),

Line 88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

84: Update HZ_MERGE_BATCH
85: SET
86: RULE_SET_NAME = decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, RULE_SET_NAME, p_RULE_SET_NAME),
87: BATCH_NAME = decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, BATCH_NAME, p_BATCH_NAME),
88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
89: BATCH_STATUS = decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, BATCH_STATUS, p_BATCH_STATUS),
90: BATCH_COMMIT = decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, BATCH_COMMIT, p_BATCH_COMMIT),
91: BATCH_DELETE = decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, BATCH_DELETE, p_BATCH_DELETE),
92: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),

Line 89: BATCH_STATUS = decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, BATCH_STATUS, p_BATCH_STATUS),

85: SET
86: RULE_SET_NAME = decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, RULE_SET_NAME, p_RULE_SET_NAME),
87: BATCH_NAME = decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, BATCH_NAME, p_BATCH_NAME),
88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
89: BATCH_STATUS = decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, BATCH_STATUS, p_BATCH_STATUS),
90: BATCH_COMMIT = decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, BATCH_COMMIT, p_BATCH_COMMIT),
91: BATCH_DELETE = decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, BATCH_DELETE, p_BATCH_DELETE),
92: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
93: -- Bug 3032780

Line 90: BATCH_COMMIT = decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, BATCH_COMMIT, p_BATCH_COMMIT),

86: RULE_SET_NAME = decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, RULE_SET_NAME, p_RULE_SET_NAME),
87: BATCH_NAME = decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, BATCH_NAME, p_BATCH_NAME),
88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
89: BATCH_STATUS = decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, BATCH_STATUS, p_BATCH_STATUS),
90: BATCH_COMMIT = decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, BATCH_COMMIT, p_BATCH_COMMIT),
91: BATCH_DELETE = decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, BATCH_DELETE, p_BATCH_DELETE),
92: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
93: -- Bug 3032780
94: /*

Line 91: BATCH_DELETE = decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, BATCH_DELETE, p_BATCH_DELETE),

87: BATCH_NAME = decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, BATCH_NAME, p_BATCH_NAME),
88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
89: BATCH_STATUS = decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, BATCH_STATUS, p_BATCH_STATUS),
90: BATCH_COMMIT = decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, BATCH_COMMIT, p_BATCH_COMMIT),
91: BATCH_DELETE = decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, BATCH_DELETE, p_BATCH_DELETE),
92: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
93: -- Bug 3032780
94: /*
95: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 92: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),

88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
89: BATCH_STATUS = decode( p_BATCH_STATUS, FND_API.G_MISS_CHAR, BATCH_STATUS, p_BATCH_STATUS),
90: BATCH_COMMIT = decode( p_BATCH_COMMIT, FND_API.G_MISS_CHAR, BATCH_COMMIT, p_BATCH_COMMIT),
91: BATCH_DELETE = decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, BATCH_DELETE, p_BATCH_DELETE),
92: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
93: -- Bug 3032780
94: /*
95: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
96: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

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

91: BATCH_DELETE = decode( p_BATCH_DELETE, FND_API.G_MISS_CHAR, BATCH_DELETE, p_BATCH_DELETE),
92: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
93: -- Bug 3032780
94: /*
95: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
96: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
97: */
98: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
99: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

92: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
93: -- Bug 3032780
94: /*
95: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
96: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
97: */
98: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
99: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
100: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

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

94: /*
95: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
96: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
97: */
98: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
99: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
100: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
101: where BATCH_ID = p_BATCH_ID;
102:

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

95: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
96: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
97: */
98: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
99: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
100: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
101: where BATCH_ID = p_BATCH_ID;
102:
103: If (SQL%NOTFOUND) then

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

96: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
97: */
98: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
99: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
100: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
101: where BATCH_ID = p_BATCH_ID;
102:
103: If (SQL%NOTFOUND) then
104: RAISE NO_DATA_FOUND;