eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MERGE_PARTIES_PKG dependencies on FND_API

Line 31: If (px_BATCH_PARTY_ID IS NULL) OR (px_BATCH_PARTY_ID = FND_API.G_MISS_NUM) then

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

Line 51: decode( p_BATCH_ID, FND_API.G_MISS_NUM, NULL, p_BATCH_ID),

47: LAST_UPDATE_DATE,
48: LAST_UPDATED_BY
49: ) VALUES (
50: px_BATCH_PARTY_ID,
51: decode( p_BATCH_ID, FND_API.G_MISS_NUM, NULL, p_BATCH_ID),
52: decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, NULL, p_MERGE_TYPE),
53: decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_FROM_PARTY_ID),
54: decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_TO_PARTY_ID),
55: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),

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

48: LAST_UPDATED_BY
49: ) VALUES (
50: px_BATCH_PARTY_ID,
51: decode( p_BATCH_ID, FND_API.G_MISS_NUM, NULL, p_BATCH_ID),
52: decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, NULL, p_MERGE_TYPE),
53: decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_FROM_PARTY_ID),
54: decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_TO_PARTY_ID),
55: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
56: decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, NULL, p_MERGE_STATUS),

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

49: ) VALUES (
50: px_BATCH_PARTY_ID,
51: decode( p_BATCH_ID, FND_API.G_MISS_NUM, NULL, p_BATCH_ID),
52: decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, NULL, p_MERGE_TYPE),
53: decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_FROM_PARTY_ID),
54: decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_TO_PARTY_ID),
55: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
56: decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, NULL, p_MERGE_STATUS),
57: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

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

50: px_BATCH_PARTY_ID,
51: decode( p_BATCH_ID, FND_API.G_MISS_NUM, NULL, p_BATCH_ID),
52: decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, NULL, p_MERGE_TYPE),
53: decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_FROM_PARTY_ID),
54: decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_TO_PARTY_ID),
55: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
56: decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, NULL, p_MERGE_STATUS),
57: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
58: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

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

51: decode( p_BATCH_ID, FND_API.G_MISS_NUM, NULL, p_BATCH_ID),
52: decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, NULL, p_MERGE_TYPE),
53: decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_FROM_PARTY_ID),
54: decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_TO_PARTY_ID),
55: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
56: decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, NULL, p_MERGE_STATUS),
57: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
58: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
59: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

52: decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, NULL, p_MERGE_TYPE),
53: decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_FROM_PARTY_ID),
54: decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_TO_PARTY_ID),
55: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
56: decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, NULL, p_MERGE_STATUS),
57: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
58: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
59: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
60: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

53: decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_FROM_PARTY_ID),
54: decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_TO_PARTY_ID),
55: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
56: decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, NULL, p_MERGE_STATUS),
57: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
58: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
59: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
60: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
61: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));

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

54: decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_TO_PARTY_ID),
55: decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_MERGE_REASON_CODE),
56: decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, NULL, p_MERGE_STATUS),
57: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
58: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
59: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
60: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
61: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));
62: End Insert_Row;

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

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

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

56: decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, NULL, p_MERGE_STATUS),
57: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
58: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
59: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
60: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
61: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));
62: End Insert_Row;
63:
64: PROCEDURE Update_Row(

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

57: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
58: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
59: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
60: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
61: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY));
62: End Insert_Row;
63:
64: PROCEDURE Update_Row(
65: p_BATCH_PARTY_ID NUMBER,

Line 82: BATCH_ID = decode( p_BATCH_ID, FND_API.G_MISS_NUM, BATCH_ID, p_BATCH_ID),

78: IS
79: BEGIN
80: Update HZ_MERGE_PARTIES
81: SET
82: BATCH_ID = decode( p_BATCH_ID, FND_API.G_MISS_NUM, BATCH_ID, p_BATCH_ID),
83: MERGE_TYPE = decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, MERGE_TYPE, p_MERGE_TYPE),
84: FROM_PARTY_ID = decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, FROM_PARTY_ID, p_FROM_PARTY_ID),
85: TO_PARTY_ID = decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, TO_PARTY_ID, p_TO_PARTY_ID),
86: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),

Line 83: MERGE_TYPE = decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, MERGE_TYPE, p_MERGE_TYPE),

79: BEGIN
80: Update HZ_MERGE_PARTIES
81: SET
82: BATCH_ID = decode( p_BATCH_ID, FND_API.G_MISS_NUM, BATCH_ID, p_BATCH_ID),
83: MERGE_TYPE = decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, MERGE_TYPE, p_MERGE_TYPE),
84: FROM_PARTY_ID = decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, FROM_PARTY_ID, p_FROM_PARTY_ID),
85: TO_PARTY_ID = decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, TO_PARTY_ID, p_TO_PARTY_ID),
86: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
87: MERGE_STATUS = decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, MERGE_STATUS, p_MERGE_STATUS),

Line 84: FROM_PARTY_ID = decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, FROM_PARTY_ID, p_FROM_PARTY_ID),

80: Update HZ_MERGE_PARTIES
81: SET
82: BATCH_ID = decode( p_BATCH_ID, FND_API.G_MISS_NUM, BATCH_ID, p_BATCH_ID),
83: MERGE_TYPE = decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, MERGE_TYPE, p_MERGE_TYPE),
84: FROM_PARTY_ID = decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, FROM_PARTY_ID, p_FROM_PARTY_ID),
85: TO_PARTY_ID = decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, TO_PARTY_ID, p_TO_PARTY_ID),
86: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
87: MERGE_STATUS = decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, MERGE_STATUS, p_MERGE_STATUS),
88: -- Bug 3032780

Line 85: TO_PARTY_ID = decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, TO_PARTY_ID, p_TO_PARTY_ID),

81: SET
82: BATCH_ID = decode( p_BATCH_ID, FND_API.G_MISS_NUM, BATCH_ID, p_BATCH_ID),
83: MERGE_TYPE = decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, MERGE_TYPE, p_MERGE_TYPE),
84: FROM_PARTY_ID = decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, FROM_PARTY_ID, p_FROM_PARTY_ID),
85: TO_PARTY_ID = decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, TO_PARTY_ID, p_TO_PARTY_ID),
86: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
87: MERGE_STATUS = decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, MERGE_STATUS, p_MERGE_STATUS),
88: -- Bug 3032780
89: /*

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

82: BATCH_ID = decode( p_BATCH_ID, FND_API.G_MISS_NUM, BATCH_ID, p_BATCH_ID),
83: MERGE_TYPE = decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, MERGE_TYPE, p_MERGE_TYPE),
84: FROM_PARTY_ID = decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, FROM_PARTY_ID, p_FROM_PARTY_ID),
85: TO_PARTY_ID = decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, TO_PARTY_ID, p_TO_PARTY_ID),
86: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
87: MERGE_STATUS = decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, MERGE_STATUS, p_MERGE_STATUS),
88: -- Bug 3032780
89: /*
90: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 87: MERGE_STATUS = decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, MERGE_STATUS, p_MERGE_STATUS),

83: MERGE_TYPE = decode( p_MERGE_TYPE, FND_API.G_MISS_CHAR, MERGE_TYPE, p_MERGE_TYPE),
84: FROM_PARTY_ID = decode( p_FROM_PARTY_ID, FND_API.G_MISS_NUM, FROM_PARTY_ID, p_FROM_PARTY_ID),
85: TO_PARTY_ID = decode( p_TO_PARTY_ID, FND_API.G_MISS_NUM, TO_PARTY_ID, p_TO_PARTY_ID),
86: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
87: MERGE_STATUS = decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, MERGE_STATUS, p_MERGE_STATUS),
88: -- Bug 3032780
89: /*
90: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
91: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

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

86: MERGE_REASON_CODE = decode( p_MERGE_REASON_CODE, FND_API.G_MISS_CHAR, MERGE_REASON_CODE, p_MERGE_REASON_CODE),
87: MERGE_STATUS = decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, MERGE_STATUS, p_MERGE_STATUS),
88: -- Bug 3032780
89: /*
90: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
91: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
92: */
93: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
94: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

87: MERGE_STATUS = decode( p_MERGE_STATUS, FND_API.G_MISS_CHAR, MERGE_STATUS, p_MERGE_STATUS),
88: -- Bug 3032780
89: /*
90: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
91: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
92: */
93: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
94: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

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

89: /*
90: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
91: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
92: */
93: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
94: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
96: where BATCH_PARTY_ID = p_BATCH_PARTY_ID;
97:

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

90: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
91: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
92: */
93: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
94: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
96: where BATCH_PARTY_ID = p_BATCH_PARTY_ID;
97:
98: If (SQL%NOTFOUND) then

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

91: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
92: */
93: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
94: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
96: where BATCH_PARTY_ID = p_BATCH_PARTY_ID;
97:
98: If (SQL%NOTFOUND) then
99: RAISE NO_DATA_FOUND;