[Home] [Help]
62: REM+ tables and APS effectivity data is writen to the _PROCESS_EFFECTIVITY +
63: REM+ and GMP_FORM_EFF tables. The writing of routing data is somewhat more +
64: REM+ complex. Basic routing header and detail data is written to the _ROUTINGS+
65: REM+ AND The _ROUTING_OPERATIONS tables. Each detail row (ie each step) then +
66: REM+ has its detail (ie the individual activities) written to the _OPERATION_ +
67: REM+ RESOURCE_SEQS table. Each activity is given a sequence number within the +
68: REM+ step in which it occurs. Each activity's detail (ie each resource used +
69: REM+ in the activity in the step (are you still with me?) is then written to +
70: REM+ the _OPERATION_RESOURCES table. The final complication is that alternate +
72: REM+ each alternative. Each row written has the original resource and a diff- +
73: REM+ erent alternative. If there are no alternatives, only one row is written +
74: REM+ and the alternative is not specified. Got all that? +
75: REM+ +
76: REM+ For further processing details, see the individual procedure headers. +
77: REM+ +
78: REM+ All externally callable routines share the same interface: +
79: REM+ +
80: REM+ LINK_NAME IN VARCHAR2 +
2493: ||' :pto_um , '
2494: ||' NULL , '
2495: ||' NULL '
2496: ||' ) '
2497: ||' FROM dual';
2498: v_matl_qty := -1;
2499: OPEN c_uom_conv FOR uom_conv_cursor USING
2500: formula_detail_tab(j).inventory_item_id,
2501: effectivity.organization_id, --sowmya added.
6007: BEGIN
6008: cur_time := NULL ;
6009:
6010: SELECT to_char(sysdate,'MM/DD/YYYY HH24:MI:SS')
6011: INTO cur_time FROM sys.dual ;
6012:
6013: log_message(cur_time);
6014: EXCEPTION
6015: WHEN OTHERS THEN
7355: l_gmp_um_code VARCHAR2(32767);
7356: BEGIN
7357: LOG_MESSAGE(' GMP_BOM_ROUTING_PKG.get_profile_value called for profile '||profile_name||' with dblink '||pdblink);
7358:
7359: uom_code_dblink := 'select fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' from dual ';
7360:
7361: OPEN uom_code_ref for uom_code_dblink ;
7362: FETCH uom_code_ref INTO l_gmp_um_code;
7363: CLOSE uom_code_ref;