[Home] [Help]
70: x_wip_entity_id NUMBER, x_wip_entity_type VARCHAR2,
71: x_wip_line_id NUMBER, x_wip_repetitive_schedule_id NUMBER,
72: x_wip_operation_seq_num NUMBER, x_wip_resource_seq_num NUMBER,
73: x_po_encumberance_flag VARCHAR2, x_gl_encumbered_date DATE,
74: WF_itemkey IN OUT NOCOPY VARCHAR2, -- because of changes due to WF synch mode this input parameter is not used.
75: x_new_combination IN OUT NOCOPY BOOLEAN,
76:
77: header_att1 VARCHAR2, header_att2 VARCHAR2, header_att3 VARCHAR2, header_att4 VARCHAR2,
78: header_att5 VARCHAR2, header_att6 VARCHAR2, header_att7 VARCHAR2, header_att8 VARCHAR2,
156: -- at the beginning of the procedure since they're called at the end
157: -- but it doesn't hurt to keep them anyway
158: WF_ENGINE_UTIL.CLEARCACHE;
159: WF_ACTIVITY.CLEARCACHE;
160: WF_ITEM_ACTIVITY_STATUS.CLEARCACHE;
161: WF_ITEM.CLEARCACHE;
162: WF_PROCESS_ACTIVITY.CLEARCACHE;
163:
164:
157: -- but it doesn't hurt to keep them anyway
158: WF_ENGINE_UTIL.CLEARCACHE;
159: WF_ACTIVITY.CLEARCACHE;
160: WF_ITEM_ACTIVITY_STATUS.CLEARCACHE;
161: WF_ITEM.CLEARCACHE;
162: WF_PROCESS_ACTIVITY.CLEARCACHE;
163:
164:
165: -- Bug 2249061. Changes End.
169: x_appl_short_name := 'SQLGL';
170: x_flex_field_code := 'GL#';
171: x_flex_field_struc_num := x_coa_id;
172:
173: WF_ItemKey := FND_FLEX_WORKFLOW.INITIALIZE (x_appl_short_name, x_flex_field_code, x_flex_field_struc_num, ItemType);
174:
175: /* If (debug_acc_generator_wf) then dbms_output.put_line ('WF Itemkey is : ' || WF_ItemKey); end if;
176: */
177:
171: x_flex_field_struc_num := x_coa_id;
172:
173: WF_ItemKey := FND_FLEX_WORKFLOW.INITIALIZE (x_appl_short_name, x_flex_field_code, x_flex_field_struc_num, ItemType);
174:
175: /* If (debug_acc_generator_wf) then dbms_output.put_line ('WF Itemkey is : ' || WF_ItemKey); end if;
176: */
177:
178: x_progress := 'ITEM KEY FOR REQ ACCOUNT:' || WF_ItemKey;
179: IF (g_po_wf_debug = 'Y') THEN
174:
175: /* If (debug_acc_generator_wf) then dbms_output.put_line ('WF Itemkey is : ' || WF_ItemKey); end if;
176: */
177:
178: x_progress := 'ITEM KEY FOR REQ ACCOUNT:' || WF_ItemKey;
179: IF (g_po_wf_debug = 'Y') THEN
180: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,WF_ItemKey,x_progress);
181: END IF;
182:
176: */
177:
178: x_progress := 'ITEM KEY FOR REQ ACCOUNT:' || WF_ItemKey;
179: IF (g_po_wf_debug = 'Y') THEN
180: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,WF_ItemKey,x_progress);
181: END IF;
182:
183: IF ( ItemType is not NULL ) AND ( WF_ItemKey is not NULL) THEN
184: -- Initialize workflow item attributes
179: IF (g_po_wf_debug = 'Y') THEN
180: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,WF_ItemKey,x_progress);
181: END IF;
182:
183: IF ( ItemType is not NULL ) AND ( WF_ItemKey is not NULL) THEN
184: -- Initialize workflow item attributes
185: --
186: IF (x_project_id IS NOT NULL) THEN
187:
191:
192: x_progress := 'Calling pa_acc_gen_wf_pkg.wf_acc_derive_params with project_id:' ||
193: to_char(x_project_id);
194: IF (g_po_wf_debug = 'Y') THEN
195: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,WF_ItemKey,x_progress);
196: END IF;
197:
198: pa_acc_gen_wf_pkg.wf_acc_derive_params (p_project_id => x_project_id,
199: p_task_id => x_task_id,
224: when others then
225: NULL;
226: END;
227:
228: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'CLASS_CODE', l_class_code);
229: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DIRECT_FLAG', l_direct_flag);
230: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_CATEGORY', l_expenditure_category);
231: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORG_NAME', l_expenditure_org_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
225: NULL;
226: END;
227:
228: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'CLASS_CODE', l_class_code);
229: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DIRECT_FLAG', l_direct_flag);
230: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_CATEGORY', l_expenditure_category);
231: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORG_NAME', l_expenditure_org_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
226: END;
227:
228: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'CLASS_CODE', l_class_code);
229: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DIRECT_FLAG', l_direct_flag);
230: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_CATEGORY', l_expenditure_category);
231: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORG_NAME', l_expenditure_org_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
227:
228: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'CLASS_CODE', l_class_code);
229: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DIRECT_FLAG', l_direct_flag);
230: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_CATEGORY', l_expenditure_category);
231: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORG_NAME', l_expenditure_org_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
228: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'CLASS_CODE', l_class_code);
229: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DIRECT_FLAG', l_direct_flag);
230: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_CATEGORY', l_expenditure_category);
231: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORG_NAME', l_expenditure_org_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
229: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DIRECT_FLAG', l_direct_flag);
230: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_CATEGORY', l_expenditure_category);
231: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORG_NAME', l_expenditure_org_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
230: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_CATEGORY', l_expenditure_category);
231: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORG_NAME', l_expenditure_org_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
231: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORG_NAME', l_expenditure_org_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
232: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_NUMBER', l_project_number);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
233: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_NAME', l_project_organization_name);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
234: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_ORGANIZATION_ID', l_project_organization_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
235: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PROJECT_TYPE', l_project_type);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
243: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TOP_TASK_NUMBER', l_top_task_number);
236: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PUBLIC_SECTOR_FLAG', l_public_sector_flag);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
243: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TOP_TASK_NUMBER', l_top_task_number);
244: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_ID', l_vendor_employee_id);
237: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'REVENUE_CATEGORY', l_revenue_category);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
243: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TOP_TASK_NUMBER', l_top_task_number);
244: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_ID', l_vendor_employee_id);
245: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_NUMBER', l_vendor_employee_number);
238: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_NUMBER', l_task_number);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
243: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TOP_TASK_NUMBER', l_top_task_number);
244: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_ID', l_vendor_employee_id);
245: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_NUMBER', l_vendor_employee_number);
246: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_TYPE', l_vendor_type);
239: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_NAME', l_task_organization_name);
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
243: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TOP_TASK_NUMBER', l_top_task_number);
244: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_ID', l_vendor_employee_id);
245: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_NUMBER', l_vendor_employee_number);
246: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_TYPE', l_vendor_type);
247:
240: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ORGANIZATION_ID', l_task_organization_id);
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
243: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TOP_TASK_NUMBER', l_top_task_number);
244: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_ID', l_vendor_employee_id);
245: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_NUMBER', l_vendor_employee_number);
246: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_TYPE', l_vendor_type);
247:
248: -- -----------------------------------------------------------------------
241: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TASK_SERVICE_TYPE', l_task_service_type);
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
243: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TOP_TASK_NUMBER', l_top_task_number);
244: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_ID', l_vendor_employee_id);
245: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_NUMBER', l_vendor_employee_number);
246: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_TYPE', l_vendor_type);
247:
248: -- -----------------------------------------------------------------------
249: -- OGM_0.0 changes . Set award_id into award_set_id item attribute..
242: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TOP_TASK_ID', l_top_task_id);
243: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TOP_TASK_NUMBER', l_top_task_number);
244: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_ID', l_vendor_employee_id);
245: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_EMPLOYEE_NUMBER', l_vendor_employee_number);
246: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'VENDOR_TYPE', l_vendor_type);
247:
248: -- -----------------------------------------------------------------------
249: -- OGM_0.0 changes . Set award_id into award_set_id item attribute..
250: -- OGM stores award_set_id into award_id and award_id is derived from
250: -- OGM stores award_set_id into award_id and award_id is derived from
251: -- award_distribution table.
252: -- ------------------------------------------------------------------------
253: IF x_award_id is not NULL then
254: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'AWARD_SET_ID', x_award_id); -- OGM_0.0 changes...
255: END IF ;
256:
257: END IF;
258:
258:
259: -- done setting AP project accounting attributes.
260:
261: IF (ItemType IN ('POWFRQBA', 'POWFRQAA', 'POWFRQVA')) THEN
262: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CODE_COMBINATION_ID', x_code_combination_id);
263: END IF;
264:
265: IF (ItemType IN ('POWFRQAA', 'POWFRQVA')) THEN
266: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BUDGET_ACCOUNT_ID', x_budget_account_id);
262: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CODE_COMBINATION_ID', x_code_combination_id);
263: END IF;
264:
265: IF (ItemType IN ('POWFRQAA', 'POWFRQVA')) THEN
266: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BUDGET_ACCOUNT_ID', x_budget_account_id);
267: END IF;
268:
269: IF (ItemType IN ('POWFRQVA')) THEN
270: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ACCRUAL_ACCOUNT_ID', x_accrual_account_id);
266: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BUDGET_ACCOUNT_ID', x_budget_account_id);
267: END IF;
268:
269: IF (ItemType IN ('POWFRQVA')) THEN
270: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ACCRUAL_ACCOUNT_ID', x_accrual_account_id);
271: END IF;
272:
273: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CHART_OF_ACCOUNTS_ID', x_coa_id);
274: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_COST_ELEMENT_ID', x_bom_cost_element_id);
269: IF (ItemType IN ('POWFRQVA')) THEN
270: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ACCRUAL_ACCOUNT_ID', x_accrual_account_id);
271: END IF;
272:
273: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CHART_OF_ACCOUNTS_ID', x_coa_id);
274: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_COST_ELEMENT_ID', x_bom_cost_element_id);
275: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_RESOURCE_ID', x_bom_resource_id);
276: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CATEGORY_ID', x_category_id);
277: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DELIVER_TO_LOCATION_ID', x_deliver_to_location_id);
270: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ACCRUAL_ACCOUNT_ID', x_accrual_account_id);
271: END IF;
272:
273: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CHART_OF_ACCOUNTS_ID', x_coa_id);
274: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_COST_ELEMENT_ID', x_bom_cost_element_id);
275: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_RESOURCE_ID', x_bom_resource_id);
276: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CATEGORY_ID', x_category_id);
277: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DELIVER_TO_LOCATION_ID', x_deliver_to_location_id);
278: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DESTINATION_ORGANIZATION_ID',
271: END IF;
272:
273: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CHART_OF_ACCOUNTS_ID', x_coa_id);
274: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_COST_ELEMENT_ID', x_bom_cost_element_id);
275: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_RESOURCE_ID', x_bom_resource_id);
276: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CATEGORY_ID', x_category_id);
277: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DELIVER_TO_LOCATION_ID', x_deliver_to_location_id);
278: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DESTINATION_ORGANIZATION_ID',
279: x_destination_organization_id);
272:
273: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CHART_OF_ACCOUNTS_ID', x_coa_id);
274: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_COST_ELEMENT_ID', x_bom_cost_element_id);
275: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_RESOURCE_ID', x_bom_resource_id);
276: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CATEGORY_ID', x_category_id);
277: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DELIVER_TO_LOCATION_ID', x_deliver_to_location_id);
278: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DESTINATION_ORGANIZATION_ID',
279: x_destination_organization_id);
280: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_SUBINVENTORY',
273: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CHART_OF_ACCOUNTS_ID', x_coa_id);
274: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_COST_ELEMENT_ID', x_bom_cost_element_id);
275: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_RESOURCE_ID', x_bom_resource_id);
276: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CATEGORY_ID', x_category_id);
277: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DELIVER_TO_LOCATION_ID', x_deliver_to_location_id);
278: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DESTINATION_ORGANIZATION_ID',
279: x_destination_organization_id);
280: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_SUBINVENTORY',
281: x_destination_subinventory);
274: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_COST_ELEMENT_ID', x_bom_cost_element_id);
275: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BOM_RESOURCE_ID', x_bom_resource_id);
276: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CATEGORY_ID', x_category_id);
277: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DELIVER_TO_LOCATION_ID', x_deliver_to_location_id);
278: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DESTINATION_ORGANIZATION_ID',
279: x_destination_organization_id);
280: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_SUBINVENTORY',
281: x_destination_subinventory);
282:
276: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'CATEGORY_ID', x_category_id);
277: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DELIVER_TO_LOCATION_ID', x_deliver_to_location_id);
278: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'DESTINATION_ORGANIZATION_ID',
279: x_destination_organization_id);
280: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_SUBINVENTORY',
281: x_destination_subinventory);
282:
283: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_TYPE_CODE', x_destination_type_code);
284:
279: x_destination_organization_id);
280: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_SUBINVENTORY',
281: x_destination_subinventory);
282:
283: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_TYPE_CODE', x_destination_type_code);
284:
285: wf_engine.SetItemAttrText ( itemtype => itemtype,
286: itemkey => WF_ItemKey,
287: aname => 'PO_ENCUMBRANCE_FLAG',
282:
283: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_TYPE_CODE', x_destination_type_code);
284:
285: wf_engine.SetItemAttrText ( itemtype => itemtype,
286: itemkey => WF_ItemKey,
287: aname => 'PO_ENCUMBRANCE_FLAG',
288: avalue => x_po_encumberance_flag );
289:
290: -- Header
288: avalue => x_po_encumberance_flag );
289:
290: -- Header
291:
292: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT1', header_att1);
293: If header_att1 is not null then
294: begin
295: wf_engine.SetItemAttrText ( itemtype => itemtype,
296: itemkey => WF_ItemKey,
292: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT1', header_att1);
293: If header_att1 is not null then
294: begin
295: wf_engine.SetItemAttrText ( itemtype => itemtype,
296: itemkey => WF_ItemKey,
297: aname => 'HEADER_ATT1',
298: avalue => header_att1 );
299: exception when others then
300: null;
300: null;
301: end;
302: end if;
303:
304: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT2', header_att2);
305: If header_att2 is not null then
306: begin
307: wf_engine.SetItemAttrText ( itemtype => itemtype,
308: itemkey => WF_ItemKey,
304: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT2', header_att2);
305: If header_att2 is not null then
306: begin
307: wf_engine.SetItemAttrText ( itemtype => itemtype,
308: itemkey => WF_ItemKey,
309: aname => 'HEADER_ATT2',
310: avalue => header_att2 );
311: exception when others then
312: null;
312: null;
313: end;
314: end if;
315:
316: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT3', header_att3);
317: If header_att3 is not null then
318: begin
319: wf_engine.SetItemAttrText ( itemtype => itemtype,
320: itemkey => WF_ItemKey,
316: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT3', header_att3);
317: If header_att3 is not null then
318: begin
319: wf_engine.SetItemAttrText ( itemtype => itemtype,
320: itemkey => WF_ItemKey,
321: aname => 'HEADER_ATT3',
322: avalue => header_att3 );
323: exception when others then
324: null;
324: null;
325: end;
326: end if;
327:
328: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT4', header_att4);
329: If header_att4 is not null then
330: begin
331: wf_engine.SetItemAttrText ( itemtype => itemtype,
332: itemkey => WF_ItemKey,
328: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT4', header_att4);
329: If header_att4 is not null then
330: begin
331: wf_engine.SetItemAttrText ( itemtype => itemtype,
332: itemkey => WF_ItemKey,
333: aname => 'HEADER_ATT4',
334: avalue => header_att4 );
335: exception when others then
336: null;
340: -- Call_WF_API_to_set_Att (ItemType, ItemKey, 'HEADER_ATT5', header_att5);
341: If header_att5 is not null then
342: begin
343: wf_engine.SetItemAttrText ( itemtype => itemtype,
344: itemkey => WF_ItemKey,
345: aname => 'HEADER_ATT5',
346: avalue => header_att5 );
347: exception when others then
348: null;
348: null;
349: end;
350: end if;
351:
352: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT6', header_att6);
353: If header_att6 is not null then
354: begin
355: wf_engine.SetItemAttrText ( itemtype => itemtype,
356: itemkey => WF_ItemKey,
352: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT6', header_att6);
353: If header_att6 is not null then
354: begin
355: wf_engine.SetItemAttrText ( itemtype => itemtype,
356: itemkey => WF_ItemKey,
357: aname => 'HEADER_ATT6',
358: avalue => header_att6 );
359: exception when others then
360: null;
360: null;
361: end;
362: end if;
363:
364: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT7', header_att7);
365: If header_att7 is not null then
366: begin
367: wf_engine.SetItemAttrText ( itemtype => itemtype,
368: itemkey => WF_ItemKey,
364: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT7', header_att7);
365: If header_att7 is not null then
366: begin
367: wf_engine.SetItemAttrText ( itemtype => itemtype,
368: itemkey => WF_ItemKey,
369: aname => 'HEADER_ATT7',
370: avalue => header_att7 );
371: exception when others then
372: null;
372: null;
373: end;
374: end if;
375:
376: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT8', header_att8);
377: If header_att8 is not null then
378: begin
379: wf_engine.SetItemAttrText ( itemtype => itemtype,
380: itemkey => WF_ItemKey,
376: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT8', header_att8);
377: If header_att8 is not null then
378: begin
379: wf_engine.SetItemAttrText ( itemtype => itemtype,
380: itemkey => WF_ItemKey,
381: aname => 'HEADER_ATT8',
382: avalue => header_att8 );
383: exception when others then
384: null;
384: null;
385: end;
386: end if;
387:
388: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT9', header_att9);
389: If header_att9 is not null then
390: begin
391: wf_engine.SetItemAttrText ( itemtype => itemtype,
392: itemkey => WF_ItemKey,
388: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT9', header_att9);
389: If header_att9 is not null then
390: begin
391: wf_engine.SetItemAttrText ( itemtype => itemtype,
392: itemkey => WF_ItemKey,
393: aname => 'HEADER_ATT9',
394: avalue => header_att9 );
395: exception when others then
396: null;
396: null;
397: end;
398: end if;
399:
400: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT10', header_att10);
401: If header_att10 is not null then
402: begin
403: wf_engine.SetItemAttrText ( itemtype => itemtype,
404: itemkey => WF_ItemKey,
400: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT10', header_att10);
401: If header_att10 is not null then
402: begin
403: wf_engine.SetItemAttrText ( itemtype => itemtype,
404: itemkey => WF_ItemKey,
405: aname => 'HEADER_ATT10',
406: avalue => header_att10 );
407: exception when others then
408: null;
408: null;
409: end;
410: end if;
411:
412: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT11', header_att11);
413: If header_att11 is not null then
414: begin
415: wf_engine.SetItemAttrText ( itemtype => itemtype,
416: itemkey => WF_ItemKey,
412: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT11', header_att11);
413: If header_att11 is not null then
414: begin
415: wf_engine.SetItemAttrText ( itemtype => itemtype,
416: itemkey => WF_ItemKey,
417: aname => 'HEADER_ATT11',
418: avalue => header_att11 );
419: exception when others then
420: null;
420: null;
421: end;
422: end if;
423:
424: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT12', header_att12);
425: If header_att12 is not null then
426: begin
427: wf_engine.SetItemAttrText ( itemtype => itemtype,
428: itemkey => WF_ItemKey,
424: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT12', header_att12);
425: If header_att12 is not null then
426: begin
427: wf_engine.SetItemAttrText ( itemtype => itemtype,
428: itemkey => WF_ItemKey,
429: aname => 'HEADER_ATT12',
430: avalue => header_att12 );
431: exception when others then
432: null;
432: null;
433: end;
434: end if;
435:
436: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT13', header_att13);
437: If header_att13 is not null then
438: begin
439: wf_engine.SetItemAttrText ( itemtype => itemtype,
440: itemkey => WF_ItemKey,
436: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT13', header_att13);
437: If header_att13 is not null then
438: begin
439: wf_engine.SetItemAttrText ( itemtype => itemtype,
440: itemkey => WF_ItemKey,
441: aname => 'HEADER_ATT13',
442: avalue => header_att13 );
443: exception when others then
444: null;
444: null;
445: end;
446: end if;
447:
448: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT14', header_att14);
449: If header_att14 is not null then
450: begin
451: wf_engine.SetItemAttrText ( itemtype => itemtype,
452: itemkey => WF_ItemKey,
448: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT14', header_att14);
449: If header_att14 is not null then
450: begin
451: wf_engine.SetItemAttrText ( itemtype => itemtype,
452: itemkey => WF_ItemKey,
453: aname => 'HEADER_ATT14',
454: avalue => header_att14 );
455: exception when others then
456: null;
456: null;
457: end;
458: end if;
459:
460: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT15', header_att15);
461: If header_att15 is not null then
462: begin
463: wf_engine.SetItemAttrText ( itemtype => itemtype,
464: itemkey => WF_ItemKey,
460: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT15', header_att15);
461: If header_att15 is not null then
462: begin
463: wf_engine.SetItemAttrText ( itemtype => itemtype,
464: itemkey => WF_ItemKey,
465: aname => 'HEADER_ATT15',
466: avalue => header_att15 );
467: exception when others then
468: null;
470: end if;
471:
472: -- Line
473:
474: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT1', line_att1);
475: If line_att1 is not null then
476: begin
477: wf_engine.SetItemAttrText ( itemtype => itemtype,
478: itemkey => WF_ItemKey,
474: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT1', line_att1);
475: If line_att1 is not null then
476: begin
477: wf_engine.SetItemAttrText ( itemtype => itemtype,
478: itemkey => WF_ItemKey,
479: aname => 'LINE_ATT1',
480: avalue => line_att1 );
481: exception when others then
482: null;
482: null;
483: end;
484: end if;
485:
486: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT2', line_att2);
487: If line_att2 is not null then
488: begin
489: wf_engine.SetItemAttrText ( itemtype => itemtype,
490: itemkey => WF_ItemKey,
486: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT2', line_att2);
487: If line_att2 is not null then
488: begin
489: wf_engine.SetItemAttrText ( itemtype => itemtype,
490: itemkey => WF_ItemKey,
491: aname => 'LINE_ATT2',
492: avalue => line_att2 );
493: exception when others then
494: null;
494: null;
495: end;
496: end if;
497:
498: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT3', line_att3);
499: If line_att3 is not null then
500: begin
501: wf_engine.SetItemAttrText ( itemtype => itemtype,
502: itemkey => WF_ItemKey,
498: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT3', line_att3);
499: If line_att3 is not null then
500: begin
501: wf_engine.SetItemAttrText ( itemtype => itemtype,
502: itemkey => WF_ItemKey,
503: aname => 'LINE_ATT3',
504: avalue => line_att3 );
505: exception when others then
506: null;
506: null;
507: end;
508: end if;
509:
510: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT4', line_att4);
511: If line_att4 is not null then
512: begin
513: wf_engine.SetItemAttrText ( itemtype => itemtype,
514: itemkey => WF_ItemKey,
510: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT4', line_att4);
511: If line_att4 is not null then
512: begin
513: wf_engine.SetItemAttrText ( itemtype => itemtype,
514: itemkey => WF_ItemKey,
515: aname => 'LINE_ATT4',
516: avalue => line_att4 );
517: exception when others then
518: null;
518: null;
519: end;
520: end if;
521:
522: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT5', line_att5);
523: If line_att5 is not null then
524: begin
525: wf_engine.SetItemAttrText ( itemtype => itemtype,
526: itemkey => WF_ItemKey,
522: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT5', line_att5);
523: If line_att5 is not null then
524: begin
525: wf_engine.SetItemAttrText ( itemtype => itemtype,
526: itemkey => WF_ItemKey,
527: aname => 'LINE_ATT5',
528: avalue => line_att5 );
529: exception when others then
530: null;
530: null;
531: end;
532: end if;
533:
534: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT6', line_att6);
535: If line_att6 is not null then
536: begin
537: wf_engine.SetItemAttrText ( itemtype => itemtype,
538: itemkey => WF_ItemKey,
534: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT6', line_att6);
535: If line_att6 is not null then
536: begin
537: wf_engine.SetItemAttrText ( itemtype => itemtype,
538: itemkey => WF_ItemKey,
539: aname => 'LINE_ATT6',
540: avalue => line_att6 );
541: exception when others then
542: null;
542: null;
543: end;
544: end if;
545:
546: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT7', line_att7);
547: If line_att7 is not null then
548: begin
549: wf_engine.SetItemAttrText ( itemtype => itemtype,
550: itemkey => WF_ItemKey,
546: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT7', line_att7);
547: If line_att7 is not null then
548: begin
549: wf_engine.SetItemAttrText ( itemtype => itemtype,
550: itemkey => WF_ItemKey,
551: aname => 'LINE_ATT7',
552: avalue => line_att7 );
553: exception when others then
554: null;
554: null;
555: end;
556: end if;
557:
558: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT8', line_att8);
559: If line_att8 is not null then
560: begin
561: wf_engine.SetItemAttrText ( itemtype => itemtype,
562: itemkey => WF_ItemKey,
558: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT8', line_att8);
559: If line_att8 is not null then
560: begin
561: wf_engine.SetItemAttrText ( itemtype => itemtype,
562: itemkey => WF_ItemKey,
563: aname => 'LINE_ATT8',
564: avalue => line_att8 );
565: exception when others then
566: null;
566: null;
567: end;
568: end if;
569:
570: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT9', line_att9);
571: If line_att9 is not null then
572: begin
573: wf_engine.SetItemAttrText ( itemtype => itemtype,
574: itemkey => WF_ItemKey,
570: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT9', line_att9);
571: If line_att9 is not null then
572: begin
573: wf_engine.SetItemAttrText ( itemtype => itemtype,
574: itemkey => WF_ItemKey,
575: aname => 'LINE_ATT9',
576: avalue => line_att9 );
577: exception when others then
578: null;
578: null;
579: end;
580: end if;
581:
582: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT10', line_att10);
583: If line_att10 is not null then
584: begin
585: wf_engine.SetItemAttrText ( itemtype => itemtype,
586: itemkey => WF_ItemKey,
582: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT10', line_att10);
583: If line_att10 is not null then
584: begin
585: wf_engine.SetItemAttrText ( itemtype => itemtype,
586: itemkey => WF_ItemKey,
587: aname => 'LINE_ATT10',
588: avalue => line_att10 );
589: exception when others then
590: null;
590: null;
591: end;
592: end if;
593:
594: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT11', line_att11);
595: If line_att11 is not null then
596: begin
597: wf_engine.SetItemAttrText ( itemtype => itemtype,
598: itemkey => WF_ItemKey,
594: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT11', line_att11);
595: If line_att11 is not null then
596: begin
597: wf_engine.SetItemAttrText ( itemtype => itemtype,
598: itemkey => WF_ItemKey,
599: aname => 'LINE_ATT11',
600: avalue => line_att11 );
601: exception when others then
602: null;
602: null;
603: end;
604: end if;
605:
606: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT12', line_att12);
607: If line_att12 is not null then
608: begin
609: wf_engine.SetItemAttrText ( itemtype => itemtype,
610: itemkey => WF_ItemKey,
606: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT12', line_att12);
607: If line_att12 is not null then
608: begin
609: wf_engine.SetItemAttrText ( itemtype => itemtype,
610: itemkey => WF_ItemKey,
611: aname => 'LINE_ATT12',
612: avalue => line_att12 );
613: exception when others then
614: null;
614: null;
615: end;
616: end if;
617:
618: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT13', line_att13);
619: If line_att13 is not null then
620: begin
621: wf_engine.SetItemAttrText ( itemtype => itemtype,
622: itemkey => WF_ItemKey,
618: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT13', line_att13);
619: If line_att13 is not null then
620: begin
621: wf_engine.SetItemAttrText ( itemtype => itemtype,
622: itemkey => WF_ItemKey,
623: aname => 'LINE_ATT13',
624: avalue => line_att13 );
625: exception when others then
626: null;
626: null;
627: end;
628: end if;
629:
630: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT14', line_att14);
631: If line_att14 is not null then
632: begin
633: wf_engine.SetItemAttrText ( itemtype => itemtype,
634: itemkey => WF_ItemKey,
630: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT14', line_att14);
631: If line_att14 is not null then
632: begin
633: wf_engine.SetItemAttrText ( itemtype => itemtype,
634: itemkey => WF_ItemKey,
635: aname => 'LINE_ATT14',
636: avalue => line_att14 );
637: exception when others then
638: null;
638: null;
639: end;
640: end if;
641:
642: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT15', line_att15);
643: If line_att15 is not null then
644: begin
645: wf_engine.SetItemAttrText ( itemtype => itemtype,
646: itemkey => WF_ItemKey,
642: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT15', line_att15);
643: If line_att15 is not null then
644: begin
645: wf_engine.SetItemAttrText ( itemtype => itemtype,
646: itemkey => WF_ItemKey,
647: aname => 'LINE_ATT15',
648: avalue => line_att15 );
649: exception when others then
650: null;
652: end if;
653:
654: -- Distribution
655:
656: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT1', distribution_att1);
657: If distribution_att1 is not null then
658: begin
659: wf_engine.SetItemAttrText ( itemtype => itemtype,
660: itemkey => WF_ItemKey,
656: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT1', distribution_att1);
657: If distribution_att1 is not null then
658: begin
659: wf_engine.SetItemAttrText ( itemtype => itemtype,
660: itemkey => WF_ItemKey,
661: aname => 'DISTRIBUTION_ATT1',
662: avalue => distribution_att1 );
663: exception when others then
664: null;
664: null;
665: end;
666: end if;
667:
668: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT2', distribution_att2);
669: If distribution_att2 is not null then
670: begin
671: wf_engine.SetItemAttrText ( itemtype => itemtype,
672: itemkey => WF_ItemKey,
668: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT2', distribution_att2);
669: If distribution_att2 is not null then
670: begin
671: wf_engine.SetItemAttrText ( itemtype => itemtype,
672: itemkey => WF_ItemKey,
673: aname => 'DISTRIBUTION_ATT2',
674: avalue => distribution_att2 );
675: exception when others then
676: null;
676: null;
677: end;
678: end if;
679:
680: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT3', distribution_att3);
681: If distribution_att3 is not null then
682: begin
683: wf_engine.SetItemAttrText ( itemtype => itemtype,
684: itemkey => WF_ItemKey,
680: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT3', distribution_att3);
681: If distribution_att3 is not null then
682: begin
683: wf_engine.SetItemAttrText ( itemtype => itemtype,
684: itemkey => WF_ItemKey,
685: aname => 'DISTRIBUTION_ATT3',
686: avalue => distribution_att3 );
687: exception when others then
688: null;
688: null;
689: end;
690: end if;
691:
692: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT4', distribution_att4);
693: If distribution_att4 is not null then
694: begin
695: wf_engine.SetItemAttrText ( itemtype => itemtype,
696: itemkey => WF_ItemKey,
692: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT4', distribution_att4);
693: If distribution_att4 is not null then
694: begin
695: wf_engine.SetItemAttrText ( itemtype => itemtype,
696: itemkey => WF_ItemKey,
697: aname => 'DISTRIBUTION_ATT4',
698: avalue => distribution_att4 );
699: exception when others then
700: null;
700: null;
701: end;
702: end if;
703:
704: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT5', distribution_att5);
705: If distribution_att5 is not null then
706: begin
707: wf_engine.SetItemAttrText ( itemtype => itemtype,
708: itemkey => WF_ItemKey,
704: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT5', distribution_att5);
705: If distribution_att5 is not null then
706: begin
707: wf_engine.SetItemAttrText ( itemtype => itemtype,
708: itemkey => WF_ItemKey,
709: aname => 'DISTRIBUTION_ATT5',
710: avalue => distribution_att5 );
711: exception when others then
712: null;
712: null;
713: end;
714: end if;
715:
716: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT6', distribution_att6);
717: If distribution_att6 is not null then
718: begin
719: wf_engine.SetItemAttrText ( itemtype => itemtype,
720: itemkey => WF_ItemKey,
716: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT6', distribution_att6);
717: If distribution_att6 is not null then
718: begin
719: wf_engine.SetItemAttrText ( itemtype => itemtype,
720: itemkey => WF_ItemKey,
721: aname => 'DISTRIBUTION_ATT6',
722: avalue => distribution_att6 );
723: exception when others then
724: null;
724: null;
725: end;
726: end if;
727:
728: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT7', distribution_att7);
729: If distribution_att7 is not null then
730: begin
731: wf_engine.SetItemAttrText ( itemtype => itemtype,
732: itemkey => WF_ItemKey,
728: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT7', distribution_att7);
729: If distribution_att7 is not null then
730: begin
731: wf_engine.SetItemAttrText ( itemtype => itemtype,
732: itemkey => WF_ItemKey,
733: aname => 'DISTRIBUTION_ATT7',
734: avalue => distribution_att7 );
735: exception when others then
736: null;
736: null;
737: end;
738: end if;
739:
740: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT8', distribution_att8);
741: If distribution_att8 is not null then
742: begin
743: wf_engine.SetItemAttrText ( itemtype => itemtype,
744: itemkey => WF_ItemKey,
740: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT8', distribution_att8);
741: If distribution_att8 is not null then
742: begin
743: wf_engine.SetItemAttrText ( itemtype => itemtype,
744: itemkey => WF_ItemKey,
745: aname => 'DISTRIBUTION_ATT8',
746: avalue => distribution_att8 );
747: exception when others then
748: null;
748: null;
749: end;
750: end if;
751:
752: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT9', distribution_att9);
753: If distribution_att9 is not null then
754: begin
755: wf_engine.SetItemAttrText ( itemtype => itemtype,
756: itemkey => WF_ItemKey,
752: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT9', distribution_att9);
753: If distribution_att9 is not null then
754: begin
755: wf_engine.SetItemAttrText ( itemtype => itemtype,
756: itemkey => WF_ItemKey,
757: aname => 'DISTRIBUTION_ATT9',
758: avalue => distribution_att9 );
759: exception when others then
760: null;
760: null;
761: end;
762: end if;
763:
764: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT10', distribution_att10);
765: If distribution_att10 is not null then
766: begin
767: wf_engine.SetItemAttrText ( itemtype => itemtype,
768: itemkey => WF_ItemKey,
764: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT10', distribution_att10);
765: If distribution_att10 is not null then
766: begin
767: wf_engine.SetItemAttrText ( itemtype => itemtype,
768: itemkey => WF_ItemKey,
769: aname => 'DISTRIBUTION_ATT10',
770: avalue => distribution_att10 );
771: exception when others then
772: null;
772: null;
773: end;
774: end if;
775:
776: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT11', distribution_att11);
777: If distribution_att11 is not null then
778: begin
779: wf_engine.SetItemAttrText ( itemtype => itemtype,
780: itemkey => WF_ItemKey,
776: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT11', distribution_att11);
777: If distribution_att11 is not null then
778: begin
779: wf_engine.SetItemAttrText ( itemtype => itemtype,
780: itemkey => WF_ItemKey,
781: aname => 'DISTRIBUTION_ATT11',
782: avalue => distribution_att11 );
783: exception when others then
784: null;
784: null;
785: end;
786: end if;
787:
788: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT12', distribution_att12);
789: If distribution_att12 is not null then
790: begin
791: wf_engine.SetItemAttrText ( itemtype => itemtype,
792: itemkey => WF_ItemKey,
788: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT12', distribution_att12);
789: If distribution_att12 is not null then
790: begin
791: wf_engine.SetItemAttrText ( itemtype => itemtype,
792: itemkey => WF_ItemKey,
793: aname => 'DISTRIBUTION_ATT12',
794: avalue => distribution_att12 );
795: exception when others then
796: null;
796: null;
797: end;
798: end if;
799:
800: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT13', distribution_att13);
801: If distribution_att13 is not null then
802: begin
803: wf_engine.SetItemAttrText ( itemtype => itemtype,
804: itemkey => WF_ItemKey,
800: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT13', distribution_att13);
801: If distribution_att13 is not null then
802: begin
803: wf_engine.SetItemAttrText ( itemtype => itemtype,
804: itemkey => WF_ItemKey,
805: aname => 'DISTRIBUTION_ATT13',
806: avalue => distribution_att13 );
807: exception when others then
808: null;
808: null;
809: end;
810: end if;
811:
812: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT14', distribution_att14);
813: If distribution_att14 is not null then
814: begin
815: wf_engine.SetItemAttrText ( itemtype => itemtype,
816: itemkey => WF_ItemKey,
812: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT14', distribution_att14);
813: If distribution_att14 is not null then
814: begin
815: wf_engine.SetItemAttrText ( itemtype => itemtype,
816: itemkey => WF_ItemKey,
817: aname => 'DISTRIBUTION_ATT14',
818: avalue => distribution_att14 );
819: exception when others then
820: null;
820: null;
821: end;
822: end if;
823:
824: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT15', distribution_att15);
825: If distribution_att15 is not null then
826: begin
827: wf_engine.SetItemAttrText ( itemtype => itemtype,
828: itemkey => WF_ItemKey,
824: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT15', distribution_att15);
825: If distribution_att15 is not null then
826: begin
827: wf_engine.SetItemAttrText ( itemtype => itemtype,
828: itemkey => WF_ItemKey,
829: aname => 'DISTRIBUTION_ATT15',
830: avalue => distribution_att15 );
831: exception when others then
832: null;
833: end;
834: end if;
835:
836:
837: Call_WF_API_to_set_date_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ITEM_DATE', x_expenditure_item_date);
838: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORGANIZATION_ID',
839: x_expenditure_organization_id);
840: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_TYPE', x_expenditure_type);
841: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ITEM_ID', x_item_id);
834: end if;
835:
836:
837: Call_WF_API_to_set_date_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ITEM_DATE', x_expenditure_item_date);
838: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORGANIZATION_ID',
839: x_expenditure_organization_id);
840: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_TYPE', x_expenditure_type);
841: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ITEM_ID', x_item_id);
842: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'LINE_TYPE_ID', x_line_type_id);
836:
837: Call_WF_API_to_set_date_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ITEM_DATE', x_expenditure_item_date);
838: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORGANIZATION_ID',
839: x_expenditure_organization_id);
840: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_TYPE', x_expenditure_type);
841: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ITEM_ID', x_item_id);
842: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'LINE_TYPE_ID', x_line_type_id);
843: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PA_BILLABLE_FLAG', x_result_billable_flag);
844:
837: Call_WF_API_to_set_date_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ITEM_DATE', x_expenditure_item_date);
838: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORGANIZATION_ID',
839: x_expenditure_organization_id);
840: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_TYPE', x_expenditure_type);
841: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ITEM_ID', x_item_id);
842: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'LINE_TYPE_ID', x_line_type_id);
843: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PA_BILLABLE_FLAG', x_result_billable_flag);
844:
845: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PREPARER_ID', x_preparer_id);
838: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'EXPENDITURE_ORGANIZATION_ID',
839: x_expenditure_organization_id);
840: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_TYPE', x_expenditure_type);
841: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ITEM_ID', x_item_id);
842: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'LINE_TYPE_ID', x_line_type_id);
843: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PA_BILLABLE_FLAG', x_result_billable_flag);
844:
845: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PREPARER_ID', x_preparer_id);
846: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PROJECT_ID', x_project_id);
839: x_expenditure_organization_id);
840: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'EXPENDITURE_TYPE', x_expenditure_type);
841: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ITEM_ID', x_item_id);
842: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'LINE_TYPE_ID', x_line_type_id);
843: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PA_BILLABLE_FLAG', x_result_billable_flag);
844:
845: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PREPARER_ID', x_preparer_id);
846: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PROJECT_ID', x_project_id);
847:
841: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'ITEM_ID', x_item_id);
842: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'LINE_TYPE_ID', x_line_type_id);
843: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PA_BILLABLE_FLAG', x_result_billable_flag);
844:
845: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PREPARER_ID', x_preparer_id);
846: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PROJECT_ID', x_project_id);
847:
848: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DOCUMENT_TYPE_CODE', x_document_type_code);
849: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BLANKET_PO_HEADER_ID', x_blanket_po_header_id);
842: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'LINE_TYPE_ID', x_line_type_id);
843: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'PA_BILLABLE_FLAG', x_result_billable_flag);
844:
845: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PREPARER_ID', x_preparer_id);
846: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PROJECT_ID', x_project_id);
847:
848: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DOCUMENT_TYPE_CODE', x_document_type_code);
849: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BLANKET_PO_HEADER_ID', x_blanket_po_header_id);
850: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_TYPE_CODE', x_source_type_code);
844:
845: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PREPARER_ID', x_preparer_id);
846: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PROJECT_ID', x_project_id);
847:
848: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DOCUMENT_TYPE_CODE', x_document_type_code);
849: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BLANKET_PO_HEADER_ID', x_blanket_po_header_id);
850: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_TYPE_CODE', x_source_type_code);
851: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SOURCE_ORGANIZATION_ID',
852: x_source_organization_id);
845: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PREPARER_ID', x_preparer_id);
846: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PROJECT_ID', x_project_id);
847:
848: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DOCUMENT_TYPE_CODE', x_document_type_code);
849: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BLANKET_PO_HEADER_ID', x_blanket_po_header_id);
850: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_TYPE_CODE', x_source_type_code);
851: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SOURCE_ORGANIZATION_ID',
852: x_source_organization_id);
853: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_SUBINVENTORY', x_source_subinventory);
846: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'PROJECT_ID', x_project_id);
847:
848: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DOCUMENT_TYPE_CODE', x_document_type_code);
849: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BLANKET_PO_HEADER_ID', x_blanket_po_header_id);
850: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_TYPE_CODE', x_source_type_code);
851: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SOURCE_ORGANIZATION_ID',
852: x_source_organization_id);
853: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_SUBINVENTORY', x_source_subinventory);
854:
847:
848: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DOCUMENT_TYPE_CODE', x_document_type_code);
849: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BLANKET_PO_HEADER_ID', x_blanket_po_header_id);
850: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_TYPE_CODE', x_source_type_code);
851: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SOURCE_ORGANIZATION_ID',
852: x_source_organization_id);
853: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_SUBINVENTORY', x_source_subinventory);
854:
855: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ID', x_task_id);
849: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'BLANKET_PO_HEADER_ID', x_blanket_po_header_id);
850: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_TYPE_CODE', x_source_type_code);
851: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SOURCE_ORGANIZATION_ID',
852: x_source_organization_id);
853: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_SUBINVENTORY', x_source_subinventory);
854:
855: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ID', x_task_id);
856: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TO_PERSON_ID', x_deliver_to_person_id);
857: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TYPE_LOOKUP_CODE', x_type_lookup_code);
851: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SOURCE_ORGANIZATION_ID',
852: x_source_organization_id);
853: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_SUBINVENTORY', x_source_subinventory);
854:
855: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ID', x_task_id);
856: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TO_PERSON_ID', x_deliver_to_person_id);
857: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TYPE_LOOKUP_CODE', x_type_lookup_code);
858: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SUGGESTED_VENDOR_ID', x_suggested_vendor_id);
859: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_SITE_ID', x_suggested_vendor_site_id); /* B1548597 Common Receiving RVK */
852: x_source_organization_id);
853: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_SUBINVENTORY', x_source_subinventory);
854:
855: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ID', x_task_id);
856: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TO_PERSON_ID', x_deliver_to_person_id);
857: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TYPE_LOOKUP_CODE', x_type_lookup_code);
858: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SUGGESTED_VENDOR_ID', x_suggested_vendor_id);
859: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_SITE_ID', x_suggested_vendor_site_id); /* B1548597 Common Receiving RVK */
860: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_ID', x_wip_entity_id);
853: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'SOURCE_SUBINVENTORY', x_source_subinventory);
854:
855: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ID', x_task_id);
856: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TO_PERSON_ID', x_deliver_to_person_id);
857: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TYPE_LOOKUP_CODE', x_type_lookup_code);
858: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SUGGESTED_VENDOR_ID', x_suggested_vendor_id);
859: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_SITE_ID', x_suggested_vendor_site_id); /* B1548597 Common Receiving RVK */
860: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_ID', x_wip_entity_id);
861:
854:
855: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ID', x_task_id);
856: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TO_PERSON_ID', x_deliver_to_person_id);
857: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TYPE_LOOKUP_CODE', x_type_lookup_code);
858: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SUGGESTED_VENDOR_ID', x_suggested_vendor_id);
859: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_SITE_ID', x_suggested_vendor_site_id); /* B1548597 Common Receiving RVK */
860: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_ID', x_wip_entity_id);
861:
862:
855: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TASK_ID', x_task_id);
856: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TO_PERSON_ID', x_deliver_to_person_id);
857: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TYPE_LOOKUP_CODE', x_type_lookup_code);
858: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SUGGESTED_VENDOR_ID', x_suggested_vendor_id);
859: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_SITE_ID', x_suggested_vendor_site_id); /* B1548597 Common Receiving RVK */
860: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_ID', x_wip_entity_id);
861:
862:
863: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_TYPE', x_wip_entity_type);
856: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'TO_PERSON_ID', x_deliver_to_person_id);
857: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'TYPE_LOOKUP_CODE', x_type_lookup_code);
858: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'SUGGESTED_VENDOR_ID', x_suggested_vendor_id);
859: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_SITE_ID', x_suggested_vendor_site_id); /* B1548597 Common Receiving RVK */
860: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_ID', x_wip_entity_id);
861:
862:
863: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_TYPE', x_wip_entity_type);
864: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_LINE_ID', x_wip_line_id );
859: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'VENDOR_SITE_ID', x_suggested_vendor_site_id); /* B1548597 Common Receiving RVK */
860: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_ID', x_wip_entity_id);
861:
862:
863: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_TYPE', x_wip_entity_type);
864: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_LINE_ID', x_wip_line_id );
865: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_OPERATION_SEQ_NUM', x_wip_operation_seq_num);
866: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_REPETITIVE_SCHEDULE_ID',
867: x_wip_repetitive_schedule_id);
860: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_ID', x_wip_entity_id);
861:
862:
863: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_TYPE', x_wip_entity_type);
864: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_LINE_ID', x_wip_line_id );
865: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_OPERATION_SEQ_NUM', x_wip_operation_seq_num);
866: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_REPETITIVE_SCHEDULE_ID',
867: x_wip_repetitive_schedule_id);
868: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_RESOURCE_SEQ_NUM', x_wip_resource_seq_num);
861:
862:
863: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_TYPE', x_wip_entity_type);
864: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_LINE_ID', x_wip_line_id );
865: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_OPERATION_SEQ_NUM', x_wip_operation_seq_num);
866: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_REPETITIVE_SCHEDULE_ID',
867: x_wip_repetitive_schedule_id);
868: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_RESOURCE_SEQ_NUM', x_wip_resource_seq_num);
869:
862:
863: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'WIP_ENTITY_TYPE', x_wip_entity_type);
864: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_LINE_ID', x_wip_line_id );
865: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_OPERATION_SEQ_NUM', x_wip_operation_seq_num);
866: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_REPETITIVE_SCHEDULE_ID',
867: x_wip_repetitive_schedule_id);
868: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_RESOURCE_SEQ_NUM', x_wip_resource_seq_num);
869:
870: --
864: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_LINE_ID', x_wip_line_id );
865: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_OPERATION_SEQ_NUM', x_wip_operation_seq_num);
866: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_REPETITIVE_SCHEDULE_ID',
867: x_wip_repetitive_schedule_id);
868: Call_WF_API_to_set_no_Att (ItemType, WF_ItemKey, 'WIP_RESOURCE_SEQ_NUM', x_wip_resource_seq_num);
869:
870: --
871: --Call WF API to set unit_price attribute.
872: --unit_price will be taken into consideration when generating accounts.
871: --Call WF API to set unit_price attribute.
872: --unit_price will be taken into consideration when generating accounts.
873:
874: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
875: itemkey => wf_itemkey,
876: aname => 'UNIT_PRICE',
877: avalue => p_unit_price);
878:
879: IF (g_po_wf_debug = 'Y') THEN
877: avalue => p_unit_price);
878:
879: IF (g_po_wf_debug = 'Y') THEN
880: PO_WF_DEBUG_PKG.insert_debug(itemtype,
881: wf_itemkey,
882: 'Set WF item UNIT_PRICE to ' ||
883: PO_WF_UTIL_PKG.GetItemAttrNumber (
884: itemtype => itemtype,
885: itemkey => wf_itemkey,
878:
879: IF (g_po_wf_debug = 'Y') THEN
880: PO_WF_DEBUG_PKG.insert_debug(itemtype,
881: wf_itemkey,
882: 'Set WF item UNIT_PRICE to ' ||
883: PO_WF_UTIL_PKG.GetItemAttrNumber (
884: itemtype => itemtype,
885: itemkey => wf_itemkey,
886: aname => 'UNIT_PRICE'));
881: wf_itemkey,
882: 'Set WF item UNIT_PRICE to ' ||
883: PO_WF_UTIL_PKG.GetItemAttrNumber (
884: itemtype => itemtype,
885: itemkey => wf_itemkey,
886: aname => 'UNIT_PRICE'));
887: END IF;
888: --
889:
890: --
891: -- Call WF API to set blanket_po_line_num attribute.
892: -- blanket_po_line_num will be taken into consideration when generating accounts.
893: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
894: itemkey => wf_itemkey,
895: aname => 'BLANKET_PO_LINE_NUM',
896: avalue => p_blanket_po_line_num);
897:
898: IF (g_po_wf_debug = 'Y') THEN
895: aname => 'BLANKET_PO_LINE_NUM',
896: avalue => p_blanket_po_line_num);
897:
898: IF (g_po_wf_debug = 'Y') THEN
899: PO_WF_DEBUG_PKG.insert_debug(itemtype, wf_itemkey,
900: 'Set WF item BLANKET_PO_LINE_NUM to ' ||
901: PO_WF_UTIL_PKG.GetItemAttrNumber(
902: itemtype => itemtype,
903: itemkey => wf_itemkey,
896: avalue => p_blanket_po_line_num);
897:
898: IF (g_po_wf_debug = 'Y') THEN
899: PO_WF_DEBUG_PKG.insert_debug(itemtype, wf_itemkey,
900: 'Set WF item BLANKET_PO_LINE_NUM to ' ||
901: PO_WF_UTIL_PKG.GetItemAttrNumber(
902: itemtype => itemtype,
903: itemkey => wf_itemkey,
904: aname => 'BLANKET_PO_LINE_NUM'));
899: PO_WF_DEBUG_PKG.insert_debug(itemtype, wf_itemkey,
900: 'Set WF item BLANKET_PO_LINE_NUM to ' ||
901: PO_WF_UTIL_PKG.GetItemAttrNumber(
902: itemtype => itemtype,
903: itemkey => wf_itemkey,
904: aname => 'BLANKET_PO_LINE_NUM'));
905: END IF;
906: --
907:
905: END IF;
906: --
907:
908:
909: -- Done setting WF item attributes
910:
911: if x_code_combination_id is null then
912:
913: x_progress := 'FND_FLEX_WORKFLOW.GENERATE: Before call';
911: if x_code_combination_id is null then
912:
913: x_progress := 'FND_FLEX_WORKFLOW.GENERATE: Before call';
914: IF (g_po_wf_debug = 'Y') THEN
915: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,WF_ItemKey,x_progress);
916: END IF;
917:
918: /* If (debug_acc_generator_wf) then dbms_output.put_line ('Calling generate to build Charge Account'); end if;
919: */
921: x_block_activity_label := NULL;
922:
923: -- Bug 1497909 : Set the encumbrance date for validation
924: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
925: itemkey => wf_itemkey,
926: aname => 'ENCUMBRANCE_DATE',
927: avalue => x_gl_encumbered_date);
928:
929: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
926: aname => 'ENCUMBRANCE_DATE',
927: avalue => x_gl_encumbered_date);
928:
929: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
930: WF_ItemKey,
931: 'DEFAULT_CHARGE_ACC_GENERATION',
932: x_block_activity_label,
933: x_insert_if_new,
934: ccid,
942:
943: -- Complete the blocked workflow as it may be running in synch mode and cause problems for consequent
944: -- account generation runs for this session.
945: begin
946: wf_engine.CompleteActivity(itemtype, wf_itemkey, 'BLOCK_BUDGET_ACC_GENERATION', 'FAILURE');
947: exception
948: when others then
949: IF (g_po_wf_debug = 'Y') THEN
950: PO_WF_DEBUG_PKG.insert_debug(itemtype,wf_itemkey,'Exception when completing WF' || Wf_Itemkey);
946: wf_engine.CompleteActivity(itemtype, wf_itemkey, 'BLOCK_BUDGET_ACC_GENERATION', 'FAILURE');
947: exception
948: when others then
949: IF (g_po_wf_debug = 'Y') THEN
950: PO_WF_DEBUG_PKG.insert_debug(itemtype,wf_itemkey,'Exception when completing WF' || Wf_Itemkey);
951: END IF;
952: -- DBMS_OUTPUT.put_line ('Exception completing blocked WF');
953: end;
954: end if;
965:
966: x_progress := 'ccid:' || to_char(ccid) || ' concat_segs:' || concat_segs || ' concat_ids:' || concat_ids ||
967: ' concat_descrs:' || concat_descrs || ' FB_ERROR_MSG:' || FB_ERROR_MSG;
968: IF (g_po_wf_debug = 'Y') THEN
969: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,WF_ItemKey,x_progress);
970: END IF;
971:
972: x_code_combination_id := ccid;
973: x_charge_account_flex := concat_segs;
987: If (x_success and (x_code_combination_id IS NOT NULL) and (x_code_combination_id <> 0) and
988: (x_code_combination_id <> -1)) then
989:
990: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
991: itemkey => WF_ItemKey,
992: aname => 'CODE_COMBINATION_ID',
993: avalue => x_code_combination_id );
994:
995: x_charge_success := x_success;
1007: end if;
1008:
1009: -- Bug 1497909 : Set the encumbrance date for validation
1010: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
1011: itemkey => wf_itemkey,
1012: aname => 'ENCUMBRANCE_DATE',
1013: avalue => x_gl_encumbered_date);
1014:
1015: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
1012: aname => 'ENCUMBRANCE_DATE',
1013: avalue => x_gl_encumbered_date);
1014:
1015: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
1016: WF_ItemKey,
1017: 'DEFAULT_BUDGET_ACC_GENERATION',
1018: x_block_activity_label,
1019: x_insert_if_new,
1020: ccid,
1045:
1046: if x_success then
1047:
1048: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
1049: itemkey => WF_ItemKey,
1050: aname => 'BUDGET_ACCOUNT_ID',
1051: avalue => x_budget_account_id );
1052:
1053: -- Generate Accrual Account
1069: end if;
1070:
1071: -- Bug 1497909 : Set the encumbrance date for validation
1072: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
1073: itemkey => wf_itemkey,
1074: aname => 'ENCUMBRANCE_DATE',
1075: avalue => x_gl_encumbered_date);
1076:
1077: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
1074: aname => 'ENCUMBRANCE_DATE',
1075: avalue => x_gl_encumbered_date);
1076:
1077: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
1078: WF_ItemKey,
1079: 'DEFAULT_ACCRUAL_ACC_GENERATION',
1080: x_block_activity_label,
1081: x_insert_if_new,
1082: ccid,
1102:
1103: If x_success then
1104:
1105: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
1106: itemkey => WF_ItemKey,
1107: aname => 'ACCRUAL_ACCOUNT_ID',
1108: avalue => x_accrual_account_id );
1109:
1110: -- Generate Variance Account
1109:
1110: -- Generate Variance Account
1111: -- Bug 1497909 : Set the encumbrance date for validation
1112: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
1113: itemkey => wf_itemkey,
1114: aname => 'ENCUMBRANCE_DATE',
1115: avalue => x_gl_encumbered_date);
1116:
1117: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
1114: aname => 'ENCUMBRANCE_DATE',
1115: avalue => x_gl_encumbered_date);
1116:
1117: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
1118: WF_ItemKey,
1119: 'DEFAULT_VARIANCE_ACC_GENERATION',
1120: 'BLOCK_VARIANCE_ACC_GENERATION',
1121: x_insert_if_new,
1122: ccid,