[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 +
2835: ||' :pto_um , '
2836: ||' NULL , '
2837: ||' NULL '
2838: ||' ) '
2839: ||' FROM dual';
2840: v_matl_qty := -1;
2841: OPEN c_uom_conv FOR uom_conv_cursor USING
2842: formula_detail_tab(j).inventory_item_id,
2843: effectivity.organization_id, --sowmya added.
6547: BEGIN
6548: cur_time := NULL ;
6549:
6550: SELECT to_char(sysdate,'MM/DD/YYYY HH24:MI:SS')
6551: INTO cur_time FROM sys.dual ;
6552:
6553: log_message(cur_time);
6554: EXCEPTION
6555: WHEN OTHERS THEN
8150: l_gmp_um_code VARCHAR2(32767);
8151: BEGIN
8152: LOG_MESSAGE(' GMP_BOM_ROUTING_PKG.get_profile_value called for profile '||profile_name||' with dblink '||pdblink);
8153:
8154: uom_code_dblink := 'select fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' from dual ';
8155:
8156: OPEN uom_code_ref for uom_code_dblink ;
8157: FETCH uom_code_ref INTO l_gmp_um_code;
8158: CLOSE uom_code_ref;