[Home] [Help]
897: BEGIN
898:
899: SAVEPOINT start_of_autoassign;
900:
901: PJM_CONC.put_line( 'Processing material transaction ' || X_transaction_id );
902:
903: X_error_num := 0;
904: X_error_msg := NULL;
905:
947: if (L_proj_id is not null and
948: L_proj_check and
949: L_task_id is null) then
950:
951: PJM_CONC.put_line('Task ID : Input => ' || L_org_id ||
952: ' / ' || L_proj_id ||
953: ' / ' || L_item_id ||
954: ' / ' || L_po_header_id ||
955: ' / ' || L_cat_id ||
962: , L_po_header_id
963: , L_cat_id
964: , L_subinv_code );
965:
966: PJM_CONC.put_line('Task ID => ' || L_task_id);
967:
968: if (L_task_id is not null) then
969:
970: L_stmt_num := 40;
1013: L_to_subinv := L_txfr_subinv;
1014: L_to_cat_id := L_cat_id;
1015: end if;
1016:
1017: PJM_CONC.put_line('To Task ID : Input => ' || L_to_org_id ||
1018: ' / ' || L_to_proj_id ||
1019: ' / ' || L_item_id ||
1020: ' / ' || L_po_header_id ||
1021: ' / ' || L_to_cat_id ||
1028: , L_po_header_id
1029: , L_to_cat_id
1030: , L_to_subinv );
1031:
1032: PJM_CONC.put_line('To Task ID => ' || L_to_task_id);
1033:
1034: if (L_to_task_id is not null) then
1035:
1036: L_stmt_num := 60;
1068: , L_dept_id
1069: , L_operation_id;
1070: close c_wip;
1071:
1072: PJM_CONC.put_line('Src Task ID : Input => ' || L_org_id ||
1073: ' / ' || L_src_proj_id ||
1074: ' / ' || L_item_id ||
1075: ' / ' || L_cat_id ||
1076: ' / ' || L_subinv_code ||
1092: , L_assy_item_id
1093: , L_operation_id
1094: , L_dept_id );
1095:
1096: PJM_CONC.put_line('Src Task ID => ' || L_src_task_id);
1097:
1098: if (L_src_task_id is not null) then
1099:
1100: L_stmt_num := 80;
1231:
1232: X_error_num := 0;
1233: X_error_msg := NULL;
1234:
1235: PJM_CONC.put_line( 'Processing resource transaction ' || X_transaction_id );
1236:
1237: L_stmt_num := 10;
1238: DELETE FROM wip_txn_interface_errors
1239: WHERE transaction_id = X_transaction_id
1262: if (L_proj_id is not null and
1263: is_project(L_proj_id) and
1264: L_task_id is null) then
1265:
1266: PJM_CONC.put_line('Input => ' || L_org_id ||
1267: ' / ' || L_proj_id ||
1268: ' / ' || L_operation_id ||
1269: ' / ' || L_wip_entity_id ||
1270: ' / ' || L_assy_item_id ||
1287: else
1288: raise Entity_type_not_supported;
1289: end if;
1290:
1291: PJM_CONC.put_line('Operation ID => ' || L_operation_id);
1292: /*End : Bug 6785540 (FP of 6339257): Fetch operation based on entity type.*/
1293:
1294: /*Bug 7028109 (FP of 6820737): Follow normal flow if txn is not for direct item. Also check for cost element id.
1295: If it is 1/2 then treat txn as material txn else as resource transaction.*/
1293:
1294: /*Bug 7028109 (FP of 6820737): Follow normal flow if txn is not for direct item. Also check for cost element id.
1295: If it is 1/2 then treat txn as material txn else as resource transaction.*/
1296: if( L_transaction_type <> 17 OR L_cost_elm_id NOT IN (1,2) ) then
1297: PJM_CONC.put_line('Calling Wip_Task_WNPS to get task for resource txn.');
1298: L_stmt_num := 30;
1299: L_task_id := Wip_Task_WNPS ( L_org_id
1300: , L_proj_id
1301: , L_operation_id
1303: , L_assy_item_id
1304: , L_dept_id );
1305: /*Start - Bug 7028109 (FP of 6820737): For direct item, call material rule engine. */
1306: else
1307: PJM_CONC.put_line('Calling WipMat_Task_WNPS to get task for resource txn. (For direct item txn)');
1308: L_task_id := WipMat_Task_WNPS(X_org_id => L_org_id
1309: , X_project_id => L_proj_id
1310: , X_item_id => null
1311: , X_category_id => null
1317: , X_dept_id => L_dept_id );
1318: end if;
1319: /*End - Bug 7028109 (FP of 6820737): For direct item, check the cost element id and treat txn accordingly.*/
1320:
1321: PJM_CONC.put_line('Task ID => ' || L_task_id);
1322:
1323: if (L_task_id is not null) then
1324:
1325: L_stmt_num := 40;