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.CSD_GROUP_JOB_PARAM_TEMP_PKG dependencies on FND_API

Line 42: If (px_GROUP_JOB_ID IS NULL) OR (px_GROUP_JOB_ID = FND_API.G_MISS_NUM) then

38:
39: IS
40: CURSOR C2 IS SELECT CSD_GROUP_JOB_PARAM_TEMP_S1.nextval FROM sys.dual;
41: BEGIN
42: If (px_GROUP_JOB_ID IS NULL) OR (px_GROUP_JOB_ID = FND_API.G_MISS_NUM) then
43: OPEN C2;
44: FETCH C2 INTO px_GROUP_JOB_ID;
45: CLOSE C2;
46: End If;

Line 72: ,decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_GROUP_ID)

68: ,INCIDENT_ID
69: ,PROCESS_ID
70: ) VALUES (
71: px_GROUP_JOB_ID
72: ,decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_GROUP_ID)
73: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
74: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)
76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)

Line 73: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)

69: ,PROCESS_ID
70: ) VALUES (
71: px_GROUP_JOB_ID
72: ,decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_GROUP_ID)
73: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
74: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)
76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)
77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)

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

70: ) VALUES (
71: px_GROUP_JOB_ID
72: ,decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_GROUP_ID)
73: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
74: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)
76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)
77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)
78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)

Line 75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)

71: px_GROUP_JOB_ID
72: ,decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_GROUP_ID)
73: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
74: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)
76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)
77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)
78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)
79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)

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

72: ,decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_GROUP_ID)
73: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
74: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)
76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)
77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)
78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)
79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)
80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)

Line 77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)

73: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
74: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)
76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)
77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)
78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)
79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)
80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)
81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)

Line 78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)

74: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)
76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)
77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)
78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)
79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)
80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)
81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)
82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)

Line 79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)

75: ,decode( p_JOB_TYPE, FND_API.G_MISS_NUM, NULL, p_JOB_TYPE)
76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)
77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)
78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)
79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)
80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)
81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)
82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)
83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)

Line 80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)

76: ,decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, p_ROUTING_REFERENCE_ID)
77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)
78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)
79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)
80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)
81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)
82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)
83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)
84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)

Line 81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)

77: ,decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, NULL, p_ALTERNATE_DESIGNATOR_CODE)
78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)
79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)
80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)
81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)
82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)
83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)
84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)

78: ,decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_JOB_STATUS_TYPE)
79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)
80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)
81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)
82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)
83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)
84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

Line 83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)

79: ,decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS)
80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)
81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)
82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)
83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)
84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)

80: ,decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE)
81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)
82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)
83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)
84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

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

81: ,decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COMPLETION_DATE)
82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)
83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)
84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

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

82: ,decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RECEIVED)
83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)
84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
90: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

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

83: ,decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SUBMITTED)
84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
90: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
91: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)

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

84: ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
90: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
91: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
92: ,decode( p_PROCESS_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_ID));

Line 89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

85: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
90: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
91: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
92: ,decode( p_PROCESS_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_ID));
93: End Insert_Row;

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

86: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
90: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
91: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
92: ,decode( p_PROCESS_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_ID));
93: End Insert_Row;
94:

Line 91: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)

87: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
90: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
91: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
92: ,decode( p_PROCESS_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_ID));
93: End Insert_Row;
94:
95: PROCEDURE Update_Row(

Line 92: ,decode( p_PROCESS_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_ID));

88: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
89: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
90: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
91: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
92: ,decode( p_PROCESS_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_ID));
93: End Insert_Row;
94:
95: PROCEDURE Update_Row(
96: p_GROUP_JOB_ID NUMBER

Line 123: REPAIR_GROUP_ID = decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, REPAIR_GROUP_ID, p_REPAIR_GROUP_ID)

119: IS
120: BEGIN
121: Update CSD_GROUP_JOB_PARAM_TEMP
122: SET
123: REPAIR_GROUP_ID = decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, REPAIR_GROUP_ID, p_REPAIR_GROUP_ID)
124: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
125: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)
127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)

Line 124: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)

120: BEGIN
121: Update CSD_GROUP_JOB_PARAM_TEMP
122: SET
123: REPAIR_GROUP_ID = decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, REPAIR_GROUP_ID, p_REPAIR_GROUP_ID)
124: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
125: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)
127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)
128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)

Line 125: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)

121: Update CSD_GROUP_JOB_PARAM_TEMP
122: SET
123: REPAIR_GROUP_ID = decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, REPAIR_GROUP_ID, p_REPAIR_GROUP_ID)
124: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
125: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)
127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)
128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)
129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)

Line 126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)

122: SET
123: REPAIR_GROUP_ID = decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, REPAIR_GROUP_ID, p_REPAIR_GROUP_ID)
124: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
125: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)
127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)
128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)
129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)
130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)

Line 127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)

123: REPAIR_GROUP_ID = decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, REPAIR_GROUP_ID, p_REPAIR_GROUP_ID)
124: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
125: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)
127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)
128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)
129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)
130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)
131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)

Line 128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)

124: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
125: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)
127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)
128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)
129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)
130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)
131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)
132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)

Line 129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)

125: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)
127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)
128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)
129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)
130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)
131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)
132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)
133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)

Line 130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)

126: ,JOB_TYPE = decode( p_JOB_TYPE, FND_API.G_MISS_NUM, JOB_TYPE, p_JOB_TYPE)
127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)
128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)
129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)
130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)
131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)
132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)
133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)
134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)

Line 131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)

127: ,ROUTING_REFERENCE_ID = decode( p_ROUTING_REFERENCE_ID, FND_API.G_MISS_NUM, ROUTING_REFERENCE_ID, p_ROUTING_REFERENCE_ID)
128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)
129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)
130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)
131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)
132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)
133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)
134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)
135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)

Line 132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)

128: ,ALTERNATE_DESIGNATOR_CODE = decode( p_ALTERNATE_DESIGNATOR_CODE, FND_API.G_MISS_CHAR, ALTERNATE_DESIGNATOR_CODE, p_ALTERNATE_DESIGNATOR_CODE)
129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)
130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)
131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)
132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)
133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)
134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)
135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

Line 133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)

129: ,JOB_STATUS_TYPE = decode( p_JOB_STATUS_TYPE, FND_API.G_MISS_CHAR, JOB_STATUS_TYPE, p_JOB_STATUS_TYPE)
130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)
131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)
132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)
133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)
134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)
135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)

130: ,ACCOUNTING_CLASS = decode( p_ACCOUNTING_CLASS, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS, p_ACCOUNTING_CLASS)
131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)
132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)
133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)
134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)
135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)

131: ,START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE)
132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)
133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)
134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)
135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

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

132: ,COMPLETION_DATE = decode( p_COMPLETION_DATE, FND_API.G_MISS_DATE, COMPLETION_DATE, p_COMPLETION_DATE)
133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)
134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)
135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

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

133: ,QUANTITY_RECEIVED = decode( p_QUANTITY_RECEIVED, FND_API.G_MISS_NUM, QUANTITY_RECEIVED, p_QUANTITY_RECEIVED)
134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)
135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
141: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

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

134: ,QUANTITY_SUBMITTED = decode( p_QUANTITY_SUBMITTED, FND_API.G_MISS_NUM, QUANTITY_SUBMITTED, p_QUANTITY_SUBMITTED)
135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
141: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
142: ,INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID)

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

135: ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
141: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
142: ,INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID)
143: ,PROCESS_ID = decode( p_PROCESS_ID, FND_API.G_MISS_NUM, PROCESS_ID, p_PROCESS_ID)

Line 140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

136: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
141: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
142: ,INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID)
143: ,PROCESS_ID = decode( p_PROCESS_ID, FND_API.G_MISS_NUM, PROCESS_ID, p_PROCESS_ID)
144: where GROUP_JOB_ID = p_GROUP_JOB_ID;

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

137: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
141: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
142: ,INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID)
143: ,PROCESS_ID = decode( p_PROCESS_ID, FND_API.G_MISS_NUM, PROCESS_ID, p_PROCESS_ID)
144: where GROUP_JOB_ID = p_GROUP_JOB_ID;
145:

Line 142: ,INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID)

138: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
141: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
142: ,INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID)
143: ,PROCESS_ID = decode( p_PROCESS_ID, FND_API.G_MISS_NUM, PROCESS_ID, p_PROCESS_ID)
144: where GROUP_JOB_ID = p_GROUP_JOB_ID;
145:
146: If (SQL%NOTFOUND) then

Line 143: ,PROCESS_ID = decode( p_PROCESS_ID, FND_API.G_MISS_NUM, PROCESS_ID, p_PROCESS_ID)

139: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
140: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
141: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
142: ,INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID)
143: ,PROCESS_ID = decode( p_PROCESS_ID, FND_API.G_MISS_NUM, PROCESS_ID, p_PROCESS_ID)
144: where GROUP_JOB_ID = p_GROUP_JOB_ID;
145:
146: If (SQL%NOTFOUND) then
147: RAISE NO_DATA_FOUND;