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_SUSPENSION_ACTIVITY_PKG dependencies on FND_API

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

59: PROGRAM_UPDATE_DATE,
60: WH_UPDATE_DATE
61: ) VALUES (
62: p_SUSPENSION_ACTIVITY_ID,
63: decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTION_EFFECTIVE_ON_DATE),
64: decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, NULL, p_ACTION_REASON),
65: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),
67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),

Line 64: decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, NULL, p_ACTION_REASON),

60: WH_UPDATE_DATE
61: ) VALUES (
62: p_SUSPENSION_ACTIVITY_ID,
63: decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTION_EFFECTIVE_ON_DATE),
64: decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, NULL, p_ACTION_REASON),
65: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),
67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),

Line 65: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),

61: ) VALUES (
62: p_SUSPENSION_ACTIVITY_ID,
63: decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTION_EFFECTIVE_ON_DATE),
64: decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, NULL, p_ACTION_REASON),
65: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),
67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),
69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),

Line 66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),

62: p_SUSPENSION_ACTIVITY_ID,
63: decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTION_EFFECTIVE_ON_DATE),
64: decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, NULL, p_ACTION_REASON),
65: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),
67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),
69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),
70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),

Line 67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),

63: decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTION_EFFECTIVE_ON_DATE),
64: decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, NULL, p_ACTION_REASON),
65: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),
67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),
69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),
70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),
71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),

Line 68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),

64: decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, NULL, p_ACTION_REASON),
65: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),
67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),
69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),
70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),
71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),
72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),

Line 69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),

65: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),
67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),
69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),
70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),
71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),
72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),
73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),

Line 70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),

66: decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_SITE_USE_ID),
67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),
69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),
70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),
71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),
72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),
73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),

67: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),
69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),
70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),
71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),
72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),
73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

Line 72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),

68: decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NULL, p_NOTICE_METHOD),
69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),
70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),
71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),
72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),
73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),

69: decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, 'N', NULL, 'N', p_NOTICE_RECEIVED_CONFIRMATION),
70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),
71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),
72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),
73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

70: decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NOTICE_SENT_DATE),
71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),
72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),
73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

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

71: decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NOTICE_TYPE),
72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),
73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

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

72: decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BEGIN_DATE),
73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

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

73: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
81: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

74: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
81: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
82: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),

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

75: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
81: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
82: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
83: decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WH_UPDATE_DATE));

Line 80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

76: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
81: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
82: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
83: decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WH_UPDATE_DATE));
84: End Insert_Row;

Line 81: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

77: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
81: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
82: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
83: decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WH_UPDATE_DATE));
84: End Insert_Row;
85:

Line 82: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),

78: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
81: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
82: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
83: decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WH_UPDATE_DATE));
84: End Insert_Row;
85:
86: PROCEDURE Update_Row(

Line 83: decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WH_UPDATE_DATE));

79: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
80: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
81: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
82: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
83: decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WH_UPDATE_DATE));
84: End Insert_Row;
85:
86: PROCEDURE Update_Row(
87: p_SUSPENSION_ACTIVITY_ID NUMBER,

Line 114: ACTION_EFFECTIVE_ON_DATE = decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, ACTION_EFFECTIVE_ON_DATE, p_ACTION_EFFECTIVE_ON_DATE),

110: IS
111: BEGIN
112: Update HZ_SUSPENSION_ACTIVITY
113: SET
114: ACTION_EFFECTIVE_ON_DATE = decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, ACTION_EFFECTIVE_ON_DATE, p_ACTION_EFFECTIVE_ON_DATE),
115: ACTION_REASON = decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, ACTION_REASON, p_ACTION_REASON),
116: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),
118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),

Line 115: ACTION_REASON = decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, ACTION_REASON, p_ACTION_REASON),

111: BEGIN
112: Update HZ_SUSPENSION_ACTIVITY
113: SET
114: ACTION_EFFECTIVE_ON_DATE = decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, ACTION_EFFECTIVE_ON_DATE, p_ACTION_EFFECTIVE_ON_DATE),
115: ACTION_REASON = decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, ACTION_REASON, p_ACTION_REASON),
116: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),
118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),

Line 116: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),

112: Update HZ_SUSPENSION_ACTIVITY
113: SET
114: ACTION_EFFECTIVE_ON_DATE = decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, ACTION_EFFECTIVE_ON_DATE, p_ACTION_EFFECTIVE_ON_DATE),
115: ACTION_REASON = decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, ACTION_REASON, p_ACTION_REASON),
116: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),
118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),
120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),

Line 117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),

113: SET
114: ACTION_EFFECTIVE_ON_DATE = decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, ACTION_EFFECTIVE_ON_DATE, p_ACTION_EFFECTIVE_ON_DATE),
115: ACTION_REASON = decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, ACTION_REASON, p_ACTION_REASON),
116: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),
118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),
120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),
121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),

Line 118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),

114: ACTION_EFFECTIVE_ON_DATE = decode( p_ACTION_EFFECTIVE_ON_DATE, FND_API.G_MISS_DATE, ACTION_EFFECTIVE_ON_DATE, p_ACTION_EFFECTIVE_ON_DATE),
115: ACTION_REASON = decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, ACTION_REASON, p_ACTION_REASON),
116: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),
118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),
120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),
121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),
122: NOTICE_TYPE = decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NOTICE_TYPE, p_NOTICE_TYPE),

Line 119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),

115: ACTION_REASON = decode( p_ACTION_REASON, FND_API.G_MISS_CHAR, ACTION_REASON, p_ACTION_REASON),
116: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),
118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),
120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),
121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),
122: NOTICE_TYPE = decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NOTICE_TYPE, p_NOTICE_TYPE),
123: BEGIN_DATE = decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, BEGIN_DATE, p_BEGIN_DATE),

Line 120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),

116: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),
118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),
120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),
121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),
122: NOTICE_TYPE = decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NOTICE_TYPE, p_NOTICE_TYPE),
123: BEGIN_DATE = decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, BEGIN_DATE, p_BEGIN_DATE),
124: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),

Line 121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),

117: SITE_USE_ID = decode( p_SITE_USE_ID, FND_API.G_MISS_NUM, SITE_USE_ID, p_SITE_USE_ID),
118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),
120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),
121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),
122: NOTICE_TYPE = decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NOTICE_TYPE, p_NOTICE_TYPE),
123: BEGIN_DATE = decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, BEGIN_DATE, p_BEGIN_DATE),
124: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
125: -- Bug 3032780

Line 122: NOTICE_TYPE = decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NOTICE_TYPE, p_NOTICE_TYPE),

118: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),
120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),
121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),
122: NOTICE_TYPE = decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NOTICE_TYPE, p_NOTICE_TYPE),
123: BEGIN_DATE = decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, BEGIN_DATE, p_BEGIN_DATE),
124: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
125: -- Bug 3032780
126: /*

Line 123: BEGIN_DATE = decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, BEGIN_DATE, p_BEGIN_DATE),

119: NOTICE_METHOD = decode( p_NOTICE_METHOD, FND_API.G_MISS_CHAR, NOTICE_METHOD, p_NOTICE_METHOD),
120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),
121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),
122: NOTICE_TYPE = decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NOTICE_TYPE, p_NOTICE_TYPE),
123: BEGIN_DATE = decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, BEGIN_DATE, p_BEGIN_DATE),
124: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
125: -- Bug 3032780
126: /*
127: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 124: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),

120: NOTICE_RECEIVED_CONFIRMATION = decode( p_NOTICE_RECEIVED_CONFIRMATION, FND_API.G_MISS_CHAR, NOTICE_RECEIVED_CONFIRMATION, p_NOTICE_RECEIVED_CONFIRMATION),
121: NOTICE_SENT_DATE = decode( p_NOTICE_SENT_DATE, FND_API.G_MISS_DATE, NOTICE_SENT_DATE, p_NOTICE_SENT_DATE),
122: NOTICE_TYPE = decode( p_NOTICE_TYPE, FND_API.G_MISS_CHAR, NOTICE_TYPE, p_NOTICE_TYPE),
123: BEGIN_DATE = decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, BEGIN_DATE, p_BEGIN_DATE),
124: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
125: -- Bug 3032780
126: /*
127: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
128: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

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

123: BEGIN_DATE = decode( p_BEGIN_DATE, FND_API.G_MISS_DATE, BEGIN_DATE, p_BEGIN_DATE),
124: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
125: -- Bug 3032780
126: /*
127: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
128: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

124: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
125: -- Bug 3032780
126: /*
127: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
128: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

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

126: /*
127: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
128: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
133: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

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

127: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
128: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
133: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

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

128: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
133: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

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

129: */
130: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
133: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, WH_UPDATE_DATE, p_WH_UPDATE_DATE)

Line 134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

130: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
133: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, WH_UPDATE_DATE, p_WH_UPDATE_DATE)
138: where SUSPENSION_ACTIVITY_ID = p_SUSPENSION_ACTIVITY_ID;

Line 135: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

131: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
133: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, WH_UPDATE_DATE, p_WH_UPDATE_DATE)
138: where SUSPENSION_ACTIVITY_ID = p_SUSPENSION_ACTIVITY_ID;
139:

Line 136: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

132: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
133: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, WH_UPDATE_DATE, p_WH_UPDATE_DATE)
138: where SUSPENSION_ACTIVITY_ID = p_SUSPENSION_ACTIVITY_ID;
139:
140: If (SQL%NOTFOUND) then

Line 137: WH_UPDATE_DATE = decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, WH_UPDATE_DATE, p_WH_UPDATE_DATE)

133: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( p_WH_UPDATE_DATE, FND_API.G_MISS_DATE, WH_UPDATE_DATE, p_WH_UPDATE_DATE)
138: where SUSPENSION_ACTIVITY_ID = p_SUSPENSION_ACTIVITY_ID;
139:
140: If (SQL%NOTFOUND) then
141: RAISE NO_DATA_FOUND;