41: p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
42: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
43: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
44:
45: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
46: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
47: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
48: ) ;
49:
42: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
43: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
44:
45: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
46: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
47: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
48: ) ;
49:
50: PROCEDURE Update_debrief_Labor_line(
43: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
44:
45: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
46: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
47: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
48: ) ;
49:
50: PROCEDURE Update_debrief_Labor_line(
51: p_debrief_line_id IN NUMBER,
80: p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
81: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
82: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
83:
84: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
85: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
86: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
87: );
88:
81: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
82: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
83:
84: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
85: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
86: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
87: );
88:
89:
82: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
83:
84: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
85: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
86: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
87: );
88:
89:
90: PROCEDURE Create_Expense_Line
120: p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
121: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
122: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
123:
124: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
125: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
126: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
127: ) ;
128:
121: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
122: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
123:
124: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
125: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
126: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
127: ) ;
128:
129: PROCEDURE Update_debrief_Expense_line(
122: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
123:
124: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
125: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
126: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
127: ) ;
128:
129: PROCEDURE Update_debrief_Expense_line(
130: p_debrief_line_id IN NUMBER,
158: p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
159: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
160: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
161:
162: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
163: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
164: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
165: );
166:
159: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
160: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
161:
162: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
163: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
164: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
165: );
166:
167:
160: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
161:
162: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
163: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
164: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
165: );
166:
167:
168: PROCEDURE SAVE_DEBRIEF_MATERIAL_LINE (
236: p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
237: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
238: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
239:
240: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
242: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
243: );
244:
237: p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
238: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
239:
240: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
242: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
243: );
244:
245:
238: p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
239:
240: p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
242: p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
243: );
244:
245:
246: FUNCTION validate_labor_time(
289:
290: -- For Debrief Header DFF
291: PROCEDURE Update_Debrief_Header
292: ( p_DEBRIEF_ID IN NUMBER,
293: p_DEBRIEF_NUMBER IN VARCHAR2 default FND_API.G_MISS_CHAR,
294: p_DEBRIEF_DATE IN DATE default FND_API.G_MISS_DATE,
295: p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
296: p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
290: -- For Debrief Header DFF
291: PROCEDURE Update_Debrief_Header
292: ( p_DEBRIEF_ID IN NUMBER,
293: p_DEBRIEF_NUMBER IN VARCHAR2 default FND_API.G_MISS_CHAR,
294: p_DEBRIEF_DATE IN DATE default FND_API.G_MISS_DATE,
295: p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
296: p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298: p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
291: PROCEDURE Update_Debrief_Header
292: ( p_DEBRIEF_ID IN NUMBER,
293: p_DEBRIEF_NUMBER IN VARCHAR2 default FND_API.G_MISS_CHAR,
294: p_DEBRIEF_DATE IN DATE default FND_API.G_MISS_DATE,
295: p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
296: p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298: p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
299: p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
292: ( p_DEBRIEF_ID IN NUMBER,
293: p_DEBRIEF_NUMBER IN VARCHAR2 default FND_API.G_MISS_CHAR,
294: p_DEBRIEF_DATE IN DATE default FND_API.G_MISS_DATE,
295: p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
296: p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298: p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
299: p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
300: p_LAST_UPDATE_DATE IN DATE default FND_API.G_MISS_DATE,
293: p_DEBRIEF_NUMBER IN VARCHAR2 default FND_API.G_MISS_CHAR,
294: p_DEBRIEF_DATE IN DATE default FND_API.G_MISS_DATE,
295: p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
296: p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298: p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
299: p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
300: p_LAST_UPDATE_DATE IN DATE default FND_API.G_MISS_DATE,
301: p_LAST_UPDATE_LOGIN IN NUMBER default FND_API.G_MISS_NUM,
294: p_DEBRIEF_DATE IN DATE default FND_API.G_MISS_DATE,
295: p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
296: p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298: p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
299: p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
300: p_LAST_UPDATE_DATE IN DATE default FND_API.G_MISS_DATE,
301: p_LAST_UPDATE_LOGIN IN NUMBER default FND_API.G_MISS_NUM,
302: p_ATTRIBUTE1 IN VARCHAR2,
295: p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
296: p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298: p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
299: p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
300: p_LAST_UPDATE_DATE IN DATE default FND_API.G_MISS_DATE,
301: p_LAST_UPDATE_LOGIN IN NUMBER default FND_API.G_MISS_NUM,
302: p_ATTRIBUTE1 IN VARCHAR2,
303: p_ATTRIBUTE2 IN VARCHAR2,
296: p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298: p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
299: p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
300: p_LAST_UPDATE_DATE IN DATE default FND_API.G_MISS_DATE,
301: p_LAST_UPDATE_LOGIN IN NUMBER default FND_API.G_MISS_NUM,
302: p_ATTRIBUTE1 IN VARCHAR2,
303: p_ATTRIBUTE2 IN VARCHAR2,
304: p_ATTRIBUTE3 IN VARCHAR2,
297: p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298: p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
299: p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
300: p_LAST_UPDATE_DATE IN DATE default FND_API.G_MISS_DATE,
301: p_LAST_UPDATE_LOGIN IN NUMBER default FND_API.G_MISS_NUM,
302: p_ATTRIBUTE1 IN VARCHAR2,
303: p_ATTRIBUTE2 IN VARCHAR2,
304: p_ATTRIBUTE3 IN VARCHAR2,
305: p_ATTRIBUTE4 IN VARCHAR2,