eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPUTIL dependencies on WSM_PARAMETERS

Line 93: ** see if a record exists in wsm_parameters table

89: AND UPPER(WSM_ENABLED_FLAG)='Y';
90: */
91:
92: /* Check_wsm_org should also include a check to
93: ** see if a record exists in wsm_parameters table
94: */
95:
96: SELECT count(*)
97: INTO l_rowcount

Line 98: FROM MTL_PARAMETERS MP, WSM_PARAMETERS WSM

94: */
95:
96: SELECT count(*)
97: INTO l_rowcount
98: FROM MTL_PARAMETERS MP, WSM_PARAMETERS WSM
99: WHERE WSM.ORGANIZATION_ID = p_organization_id
100: AND MP.ORGANIZATION_ID = WSM.ORGANIZATION_ID
101: AND UPPER(MP.WSM_ENABLED_FLAG)='Y';
102:

Line 670: from wsm_parameters

666: BEGIN
667: IF x_accounting_class_code IS NULL THEN
668: SELECT default_acct_class_code
669: INTO x_accounting_class_code
670: from wsm_parameters
671: WHERE organization_id = p_organization_id;
672: END IF;
673:
674: IF x_accounting_class_code IS NOT NULL THEN

Line 2721: from wsm_parameters

2717: l_stmt_no := 5;
2718: if p_org_id is not null then
2719: select nvl(ESTIMATED_SCRAP_ACCOUNTING, 1)
2720: into l_est_scrap_accounting
2721: from wsm_parameters
2722: where organization_id = p_org_id;
2723:
2724: return l_est_scrap_accounting;
2725: end if;

Line 2743: from wsm_parameters

2739: else
2740: l_stmt_no:= 20;
2741: select nvl(ESTIMATED_SCRAP_ACCOUNTING, 1)
2742: into l_est_scrap_accounting
2743: from wsm_parameters
2744: where organization_id = l_organization_id;
2745:
2746: return l_est_scrap_accounting;
2747: end if;

Line 2763: -- user creates a new org and wishes to setup wsm parameters in the org, this procedure is

2759: -- abb H, added by abedajna for optional scrap accounting project
2760: -- This API checks if all jobs in an org have one of the following status types or not:
2761: -- Unreleased, Closed On-Hold with date_released null and Cancelled. If all jobs in the
2762: -- org are in one of the statuses mentioned the API returns 0, else it returns 1. When the
2763: -- user creates a new org and wishes to setup wsm parameters in the org, this procedure is
2764: -- called by the Parameters form. In this case no row exists in wsm_parameters for the
2765: -- job as yet. In that case the proc has been designed to return 2.
2766:
2767: FUNCTION WSM_CHANGE_ESA_FLAG(p_org_id IN NUMBER,

Line 2764: -- called by the Parameters form. In this case no row exists in wsm_parameters for the

2760: -- This API checks if all jobs in an org have one of the following status types or not:
2761: -- Unreleased, Closed On-Hold with date_released null and Cancelled. If all jobs in the
2762: -- org are in one of the statuses mentioned the API returns 0, else it returns 1. When the
2763: -- user creates a new org and wishes to setup wsm parameters in the org, this procedure is
2764: -- called by the Parameters form. In this case no row exists in wsm_parameters for the
2765: -- job as yet. In that case the proc has been designed to return 2.
2766:
2767: FUNCTION WSM_CHANGE_ESA_FLAG(p_org_id IN NUMBER,
2768: err_code OUT NOCOPY NUMBER,

Line 2781: -- in an org, Then there's no row in the wsm_parameters and change of flag

2777: err_msg := '';
2778:
2779: BEGIN
2780: -- added by abb to take care of the case when the form is opened the first time
2781: -- in an org, Then there's no row in the wsm_parameters and change of flag
2782: -- should be allowed.
2783: begin
2784: select 1
2785: into l_dummy

Line 2786: from wsm_parameters

2782: -- should be allowed.
2783: begin
2784: select 1
2785: into l_dummy
2786: from wsm_parameters
2787: where organization_id = p_org_id;
2788: exception
2789: when no_data_found then return 2;
2790: end;

Line 3050: FROM WSM_PARAMETERS

3046: /****************
3047: -- At the last operation
3048: SELECT nvl(LAST_OPERATION_SEQ_NUM,9999)
3049: INTO l_last_op_seq_num
3050: FROM WSM_PARAMETERS
3051: WHERE ORGANIZATION_ID = p_organization_id;
3052: if(p_wo_op_seq_num = l_last_op_seq_num) then
3053: return 2; -- at last operation
3054: end if;

Line 3175: FROM WSM_PARAMETERS

3171:
3172: -- At the last operation
3173: SELECT nvl(LAST_OPERATION_SEQ_NUM,9999)
3174: INTO l_last_op_seq_num
3175: FROM WSM_PARAMETERS
3176: WHERE ORGANIZATION_ID = p_organization_id;
3177: if(p_wo_op_seq_num = l_last_op_seq_num) then
3178: return 2; -- at last operation
3179: end if;

Line 3327: --FROM wsm_parameters

3323: --Start deletions for 9999 project
3324: --Start additions to fix bug #2458260
3325: --SELECT nvl(last_operation_seq_num, 9999)
3326: --INTO l_last_op_seq_num
3327: --FROM wsm_parameters
3328: --WHERE organization_id = p_organization_id;
3329: --End additions to fix bug #2458260
3330: --End deletions for 9999 project
3331:

Line 5674: from wsm_parameters

5670: ||', Org Id is '|| l_mfg_org_id)
5671: );
5672:
5673: Select to_number(plan_code) into l_return_value
5674: from wsm_parameters
5675: where organization_id = to_number(l_mfg_org_id);
5676:
5677: If l_return_value IN (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO) Then
5678: return l_return_value;

Line 5716: from wsm_parameters

5712: l_return_value := CREATE_LBJ_COPY_RTG_PROFILE;
5713: ELSE -- Refer to the org level setting
5714: select plan_code
5715: into l_plan_code
5716: from wsm_parameters
5717: where organization_id = p_organization_id;
5718:
5719: IF (l_plan_code IS NULL) THEN -- retain the site level setting
5720: l_return_value := CREATE_LBJ_COPY_RTG_PROFILE;

Line 5741: from wsm_parameters

5737: /***** Following code should be commented out after UT/ST for FP.J ***
5738: ----------------------------------------------------------------------
5739:
5740: Select to_number(plan_code) into l_return_value
5741: from wsm_parameters
5742: where organization_id = p_organization_id;
5743:
5744: If l_return_value IN (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO) Then
5745: return l_return_value;