DBA Data[Home] [Help]

APPS.CSTPLENG dependencies on CSTPACDP

Line 4168: ** the distribution proc. CSTPACDP.inventory_ **

4164: ** HISTORY **
4165: ** 4/24/00 Dieu-Thuong Le Creation **
4166: ** 9/05/00 Dieu-Thuong Le Fix bug 1393484: payback variance should **
4167: ** be stored in MCACD by qty unit because **
4168: ** the distribution proc. CSTPACDP.inventory_ **
4169: ** accounts will calc payback variance to be **
4170: ** posted (-1*i_pqty*l_payback_var) **
4171: *********************************************************************************/
4172:

Line 6083: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, l_qty_adj * l_cost,

6079: into l_acct
6080: from dual;
6081: end if;
6082:
6083: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, l_qty_adj * l_cost,
6084: sign(l_qty_adj * l_cost) * abs(l_qty_adj)/*modified for bug #4005770*/ /*l_qty_adj*/, l_acct, l_sob_id, 1,
6085: cost_element, NULL,
6086: l_txn_date, l_txn_src_id, 15,
6087: l_pri_curr, l_alt_curr, l_conv_date, l_conv_rate, l_conv_type,

Line 6125: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, (l_qty_adj * l_cost) - l_var - l_onhand_var,

6121: into l_acct
6122: from dual;
6123: end if;
6124:
6125: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, (l_qty_adj * l_cost) - l_var - l_onhand_var,
6126: l_qty_adj, l_acct, l_sob_id, 2,
6127: cost_element, NULL,
6128: l_txn_date, l_txn_src_id, 15,
6129: l_pri_curr, l_alt_curr, l_conv_date, l_conv_rate, l_conv_type,

Line 6155: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, l_onhand_var,

6151: if (l_acct = -1) then
6152: l_acct := l_onhand_var_acct;
6153: end if;
6154:
6155: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, l_onhand_var,
6156: l_qty_adj, l_acct, l_sob_id, 20,
6157: cost_element, NULL,
6158: l_txn_date, l_txn_src_id, 15,
6159: l_pri_curr, l_alt_curr, l_conv_date, l_conv_rate, l_conv_type,

Line 6201: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, l_var,

6197: if (l_acct = -1) then
6198: l_acct := l_avg_cost_var_acct;
6199: end if;
6200:
6201: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, l_var,
6202: l_qty_adj, l_acct, l_sob_id, 13,
6203: NULL, NULL,
6204: l_txn_date, l_txn_src_id, 15,
6205: l_pri_curr, l_alt_curr, l_conv_date, l_conv_rate, l_conv_type,

Line 6222: CSTPACDP.balance_account (i_org_id, i_txn_id, l_err_num, l_err_code, l_err_msg);

6218: WHERE transaction_id = i_txn_id
6219: AND transaction_costed_date IS NULL;
6220:
6221: -----For Bug 14768572, fixing the rounding issue in MTA table, start ------------------------------
6222: CSTPACDP.balance_account (i_org_id, i_txn_id, l_err_num, l_err_code, l_err_msg);
6223: if (l_err_num <>0) then
6224: raise process_error;
6225: end if;
6226: -----For Bug 14768572, fixing the rounding issue in MTA table, end ------------------------------