DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on WSM_PARAMETERS

Line 2737: the inv_lot_txn_enabled column in wsm_parameters is checked

2733:
2734:
2735: /* A check to see if WMS is enabled or not is no longer
2736: done to see if the inv lot transaction is valid. Instead
2737: the inv_lot_txn_enabled column in wsm_parameters is checked
2738: commenting out the following code and adding new code for
2739: the altered check
2740:
2741: -- check if org is not WMS enabled

Line 2771: -- WSM_PARAMETERS

2767:
2768: */
2769:
2770: -- Begin Addition of code to check INV_LOT_TXN_ENABLED column in
2771: -- WSM_PARAMETERS
2772:
2773: lProcLocation := 27;
2774:
2775: BEGIN

Line 2781: FROM wsm_parameters wp

2777: l_invTxnEnabledFlag := 0;
2778:
2779: SELECT wp.inv_lot_txn_enabled
2780: INTO l_invTxnEnabledFlag
2781: FROM wsm_parameters wp
2782: WHERE wp.organization_id = x_organization_id;
2783:
2784:
2785: IF (nvl(l_invTxnEnabledFlag,0) = 0) THEN

Line 2797: -- WSM_PARAMETERS

2793:
2794:
2795:
2796: -- END changes code to check INV_LOT_TXN_ENABLED column in
2797: -- WSM_PARAMETERS
2798:
2799: -- check if the user is a valid user.
2800:
2801: lProcLocation := 30;

Line 4357: from wsm_parameters wp

4353:
4354: Begin
4355:
4356: select wp.transaction_account_id into x_dist_acct_id
4357: from wsm_parameters wp
4358: Where wp.organization_id = X_Organization_Id
4359: and exists (select 1
4360: From gl_code_combinations gl
4361: Where gl.code_combination_id = wp.transaction_account_id

Line 4744: from wsm_parameters wp

4740:
4741: Begin
4742:
4743: select wp.transaction_account_id into x_dist_acct_id
4744: from wsm_parameters wp
4745: Where wp.organization_id = X_Organization_Id
4746: and exists (select 1
4747: From gl_code_combinations gl
4748: Where gl.code_combination_id = wp.transaction_account_id