DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on CSTPSCHK

Line 5301: l_acct := CSTPSCHK.std_get_account_id(i_org_id, i_txn_id, sign(i_p_qty), l_acct_line_type,

5297: and layer_id = l_layer_id
5298: and cost_element_id = cost_element;
5299:
5300: if (l_cost is not NULL) then
5301: l_acct := CSTPSCHK.std_get_account_id(i_org_id, i_txn_id, sign(i_p_qty), l_acct_line_type,
5302: cost_element, 0, i_subinv, l_cost_grp_id, l_exp,
5303: i_snd_rcv, l_err_num, l_err_code, l_err_msg);
5304: -- check error
5305: if(l_err_num<>0) then

Line 5972: l_acct := CSTPSCHK.std_get_account_id(i_org_id, i_txn_id, sign(i_p_qty),

5968: cost_element, NULL, i_subinv,
5969: 0, i_snd_rcv, l_err_num, l_err_code,
5970: l_err_msg);
5971: else
5972: l_acct := CSTPSCHK.std_get_account_id(i_org_id, i_txn_id, sign(i_p_qty),
5973: i_acct_line_type, cost_element, 0, i_subinv, i_cost_grp_id,
5974: 0, i_snd_rcv, l_err_num, l_err_code, l_err_msg);
5975: end if;
5976:

Line 6121: l_acct := CSTPSCHK.std_get_account_id(i_org_id, i_txn_id, sign(i_p_qty),

6117: NULL, NULL, i_subinv,
6118: 0, i_snd_rcv, l_err_num, l_err_code,
6119: l_err_msg);
6120: else
6121: l_acct := CSTPSCHK.std_get_account_id(i_org_id, i_txn_id, sign(i_p_qty),
6122: i_acct_line_type, NULL, 0, i_subinv, i_cost_grp_id,
6123: 0, i_snd_rcv, l_err_num, l_err_code, l_err_msg);
6124: end if;
6125:

Line 7457: l_return_code := CSTPSCHK.std_cost_dist_hook( org_id, trans_id,

7453: |hook has been used.
7454: +----------------------------------------------------------------------*/
7455:
7456: l_stmt_num := 290;
7457: l_return_code := CSTPSCHK.std_cost_dist_hook( org_id, trans_id,
7458: user_id, login_id, req_id, prg_appid,
7459: prg_id, O_Error_Num, O_Error_Code, O_Error_Message);
7460:
7461: if (O_Error_Num <> 0)

Line 7821: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

7817: /* Cr Sending Org Freight Exp account */
7818: if (txn_act_id = 3) and (trp_cost <> 0)
7819: then
7820:
7821: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
7822: -1, 12, 1, 0,
7823: subinv, cg_id, 0, snd_rcv,
7824: O_Error_Num, O_Error_Code, O_Error_Message);
7825:

Line 7858: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

7854:
7855: /*----------------------------------------------------------------------+
7856: | Dr Receivalbes with transfer price
7857: +----------------------------------------------------------------------*/
7858: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
7859: 1, 10, 1, 0,
7860: subinv, cg_id, 0, snd_rcv,
7861: O_Error_Num, O_Error_Code, O_Error_Message);
7862:

Line 7928: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

7924:
7925: if (interorg_profit <> 0)
7926: then
7927:
7928: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
7929: -1, G_INTERORG_PROFIT_ACCT, 1, 0,
7930: subinv, cg_id, 0, snd_rcv,
7931: O_Error_Num, O_Error_Code, O_Error_Message);
7932:

Line 8040: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8036:
8037: /*----------------------------------------------------------------------+
8038: | Cr Inv. Val @ with zero cost
8039: +----------------------------------------------------------------------*/
8040: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8041: -1, 1, 1, 0,
8042: subinv, cg_id, 0, snd_rcv,
8043: O_Error_Num, O_Error_Code, O_Error_Message);
8044:

Line 8070: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8066:
8067: /*----------------------------------------------------------------------+
8068: | Dr Intransit Acct with zero cost
8069: +----------------------------------------------------------------------*/
8070: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8071: -1, 14, 1, 0,
8072: subinv, cg_id, 0, snd_rcv,
8073: O_Error_Num, O_Error_Code, O_Error_Message);
8074:

Line 8200: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8196: /* Amount to account */
8197: payamt := interorg_xfr_price * p_qty;
8198:
8199:
8200: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8201: -1, 9, 1, 0,
8202: subinv, cg_id, 0, snd_rcv,
8203: O_Error_Num, O_Error_Code, O_Error_Message);
8204:

Line 8237: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8233: then
8234:
8235: /* Dr expense account for direct transfer */
8236:
8237: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8238: -1, 2, 1, 0,
8239: subinv, cg_id, 0, snd_rcv,
8240: O_Error_Num, O_Error_Code, O_Error_Message);
8241:

Line 8340: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8336: WHERE transaction_id = trans_id
8337: RETURNING variance_amount INTO ppv_amt;
8338:
8339:
8340: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8341: -1, 6, 1, 0,
8342: subinv, cg_id, 0, snd_rcv,
8343: O_Error_Num, O_Error_Code, O_Error_Message);
8344:

Line 8408: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8404: +----------------------------------------------------------------------*/
8405: -- receiving asset item into exp sub
8406: l_stmt_num := 910;
8407:
8408: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8409: -1, 2, 1, 0,
8410: subinv, cg_id, 0, snd_rcv,
8411: O_Error_Num, O_Error_Code, O_Error_Message);
8412:

Line 8474: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8470: -- {
8471: if (NOT iexp_flg = 1)
8472: then
8473:
8474: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8475: -1, 14, 1, 0,
8476: subinv, cg_id, 0, snd_rcv,
8477: O_Error_Num, O_Error_Code, O_Error_Message);
8478:

Line 8524: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8520:
8521: payamt := -1.0 * txf_price * p_qty;
8522:
8523:
8524: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8525: -1, 9, 1, 0,
8526: subinv, cg_id, 0, snd_rcv,
8527: O_Error_Num, O_Error_Code, O_Error_Message);
8528:

Line 8622: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8618: WHERE transaction_id = trans_id
8619: RETURNING variance_amount INTO ppv_amt;
8620:
8621:
8622: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8623: -1, 6, 1, 0,
8624: subinv, cg_id, 0, snd_rcv,
8625: O_Error_Num, O_Error_Code, O_Error_Message);
8626:

Line 8659: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8655: +----------------------------------------------------------------------*/
8656:
8657: l_stmt_num := 920;
8658:
8659: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8660: -1, 2, 1, 0,
8661: subinv, cg_id, 0, snd_rcv,
8662: O_Error_Num, O_Error_Code, O_Error_Message);
8663:

Line 8751: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8747: | need to book intransit entry.
8748: +----------------------------------------------------------------------*/
8749: if (NOT iexp_flg = 1) -- Bug 5332764.
8750: then
8751: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8752: -1, 14, 1, 0,
8753: subinv, cg_id, 0, snd_rcv,
8754: O_Error_Num, O_Error_Code, O_Error_Message);
8755:

Line 8787: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8783: +----------------------------------------------------------------------*/
8784: if(trp_cost <> 0)
8785: then
8786:
8787: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8788: -1, 12, 1, 0,
8789: subinv, cg_id, 0, snd_rcv,
8790: O_Error_Num, O_Error_Code, O_Error_Message);
8791:

Line 8820: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8816: /*----------------------------------------------------------------------+
8817: | Dr Sending Org Receivable with Transfer Price
8818: +----------------------------------------------------------------------*/
8819:
8820: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8821: 1, 10, 1, 0,
8822: subinv, cg_id, 0, snd_rcv,
8823: O_Error_Num, O_Error_Code, O_Error_Message);
8824:

Line 8877: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8873:
8874: if (interorg_profit <> 0)
8875: then
8876:
8877: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8878: -1, G_INTERORG_PROFIT_ACCT, 1, 0,
8879: subinv, cg_id, 0, snd_rcv,
8880: O_Error_Num, O_Error_Code, O_Error_Message);
8881:

Line 8945: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8941: +----------------------------------------------------------------------*/
8942:
8943: payamt := -1.0 * txf_price * p_qty;
8944:
8945: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8946: -1, 9, 1, 0,
8947: subinv, cg_id, 0, snd_rcv,
8948: O_Error_Num, O_Error_Code, O_Error_Message);
8949:

Line 8979: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

8975: +----------------------------------------------------------------------*/
8976: if (trp_cost <> 0)
8977: then
8978:
8979: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
8980: -1, 12, 1, 0,
8981: subinv, cg_id, 0, snd_rcv,
8982: O_Error_Num, O_Error_Code, O_Error_Message);
8983:

Line 9015: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

9011: +----------------------------------------------------------------------*/
9012: if (var_amt <> 0)
9013: then
9014:
9015: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
9016: -1, 13, 1, 0,
9017: subinv, cg_id, 0, snd_rcv,
9018: O_Error_Num, O_Error_Code, O_Error_Message);
9019:

Line 9056: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

9052: --
9053: if (iexp_flg = 1)
9054: then
9055:
9056: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
9057: -1, 2, 1, 0,
9058: subinv, cg_id, 0, snd_rcv,
9059: O_Error_Num, O_Error_Code, O_Error_Message);
9060:

Line 9092: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

9088: /*----------------------------------------------------------------------+
9089: | Dr intransit @ receiving org cost
9090: +----------------------------------------------------------------------*/
9091:
9092: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
9093: -1, 14, 1, 0,
9094: subinv, cg_id, 0, snd_rcv,
9095: O_Error_Num, O_Error_Code, O_Error_Message);
9096:

Line 9171: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

9167:
9168: if (ppv_amt <> 0)
9169: then
9170:
9171: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
9172: -1, 6, 1, 0,
9173: subinv, cg_id, 0, snd_rcv,
9174: O_Error_Num, O_Error_Code, O_Error_Message);
9175:

Line 9214: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,

9210: then
9211: if (enc_rev is not null AND enc_amt <> 0)
9212: then
9213:
9214: user_acct_id := CSTPSCHK.std_get_account_id( org_id, trans_id,
9215: -1, 15, 1, 0,
9216: subinv, cg_id, 0, snd_rcv,
9217: O_Error_Num, O_Error_Code, O_Error_Message);
9218: