80: +------------------------------------------------------------*/
81: l_stmt_num := 5;
82: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
83: INTO l_pd_txfr_ind
84: FROM MTL_PARAMETERS MP
85: WHERE MP.ORGANIZATION_ID = i_txn_org_id
86: OR MP.ORGANIZATION_ID = i_txfr_org_id;
87: /*End OPM INVCONV sschinch process discrete changes */
88:
119:
120: l_stmt_num := 10;
121: SELECT count(*)
122: INTO l_layer_cost_org
123: FROM MTL_PARAMETERS
124: WHERE ORGANIZATION_ID = i_txn_org_id
125: AND PRIMARY_COST_METHOD in (5,6);
126:
127: if (l_layer_cost_org > 0) then
162: THEN
163:
164: SELECT count(*)
165: INTO l_layer_cost_org
166: FROM MTL_PARAMETERS
167: WHERE ORGANIZATION_ID = i_txfr_org_id
168: AND PRIMARY_COST_METHOD in (5,6);
169:
170:
204: elsif (i_txfr_cost_group_id <> -1 ) then
205:
206: SELECT count(*)
207: INTO l_layer_cost_org
208: FROM MTL_PARAMETERS
209: WHERE ORGANIZATION_ID = i_txn_org_id
210: AND PRIMARY_COST_METHOD in (5,6);
211:
212: if (l_layer_cost_org > 0) then
260: +------------------------------------------------------------*/
261: else
262: SELECT count(*)
263: INTO l_layer_cost_org
264: FROM MTL_PARAMETERS
265: WHERE ORGANIZATION_ID = i_txn_org_id
266: AND PRIMARY_COST_METHOD in (5,6);
267:
268: if (l_layer_cost_org > 0) then
447: IF ( I_TXN_ACTION_ID in (12, 21) ) THEN
448: BEGIN
449: SELECT 'Y'
450: INTO l_std_txfr_flag
451: FROM MTL_PARAMETERS
452: WHERE ORGANIZATION_ID IN ( i_txn_org_id, i_txfr_org_id )
453: AND PRIMARY_COST_METHOD = 1;
454: EXCEPTION
455: WHEN OTHERS THEN
466: encumbrance_reversal_flag
467: INTO
468: l_enc_reversal_flag
469: FROM
470: MTL_PARAMETERS
471: WHERE
472: organization_id = i_txn_org_id;
473:
474: l_trx_info.TRANSACTION_ID := i_txn_id;