71: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_MSUTIL_PUB';
72: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
73: gMrpAssignmentSet number ;
74:
75: gUserId number := nvl(fnd_global.user_id, -1);
76: gLoginId number := nvl(fnd_global.login_id, -1);
77:
78:
79: procedure process_sourcing_chain(
72: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
73: gMrpAssignmentSet number ;
74:
75: gUserId number := nvl(fnd_global.user_id, -1);
76: gLoginId number := nvl(fnd_global.login_id, -1);
77:
78:
79: procedure process_sourcing_chain(
80: p_model_item_id IN number
1368: -- pLineId is the line_id of the model line
1369: --
1370:
1371: lStmtNumber := 10;
1372: gUserId := nvl(fnd_global.user_id, -1);
1373: gLoginId := nvl(fnd_global.login_id, -1);
1374:
1375: /* get top model's ato_line_id */
1376: --
1369: --
1370:
1371: lStmtNumber := 10;
1372: gUserId := nvl(fnd_global.user_id, -1);
1373: gLoginId := nvl(fnd_global.login_id, -1);
1374:
1375: /* get top model's ato_line_id */
1376: --
1377: -- The column top_model_line_id in bom_cto_src_orgs is being used