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.WSM_LBJ_INTERFACE_PVT dependencies on DBMS_UTILITY

Line 5: -- when calling dbms_utility.get_hash_value use larger seed number

1: PACKAGE BODY WSM_LBJ_INTERFACE_PVT AS
2: /* $Header: WSMVLJIB.pls 120.44.12020000.5 2013/02/22 09:12:49 kswarna ship $ */
3:
4: -- BUG 3934661
5: -- when calling dbms_utility.get_hash_value use larger seed number
6: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);
7: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);
8:
9: -- **********************************************************************************************

Line 6: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);

2: /* $Header: WSMVLJIB.pls 120.44.12020000.5 2013/02/22 09:12:49 kswarna ship $ */
3:
4: -- BUG 3934661
5: -- when calling dbms_utility.get_hash_value use larger seed number
6: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);
7: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);
8:
9: -- **********************************************************************************************
10: -- PACKAGE: WSM_LBJ_INTERFACE_PVT (OSFM 11.5.10 and above)

Line 7: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);

3:
4: -- BUG 3934661
5: -- when calling dbms_utility.get_hash_value use larger seed number
6: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);
7: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);
8:
9: -- **********************************************************************************************
10: -- PACKAGE: WSM_LBJ_INTERFACE_PVT (OSFM 11.5.10 and above)
11: -- (1) This is to handle WSM Lot Based Job Interface

Line 1119: l_job_name_hash := dbms_utility.get_hash_value(

1115: x_error_code := -1;
1116: return;
1117: end if;
1118:
1119: l_job_name_hash := dbms_utility.get_hash_value(
1120: p_job_name || p_org_id,
1121: 37, 1073741824);
1122: l_xst := g_v_job_name.exists(l_job_name_hash);
1123: if( NOT l_xst ) then

Line 1798: l_hash_value := dbms_utility.get_hash_value(

1794: p_error_code := -1;
1795: raise e_wljdi_common_error;
1796: else
1797: -- get resource id from item name
1798: l_hash_value := dbms_utility.get_hash_value(
1799: v_wljdi_resource_code_new(l_d) || p_org_id,
1800: 37, 1073741824);
1801: if(g_v_res_id.exists(l_hash_value)) then
1802: v_wljdi_resource_id_new(l_d) := g_v_res_id(l_hash_value);

Line 2018: l_hash_value := dbms_utility.get_hash_value(

2014: raise e_wljdi_common_error;
2015: else
2016: l_stmt_num := 50.2;
2017: -- get item id from item name
2018: l_hash_value := dbms_utility.get_hash_value(
2019: v_wljdi_inventory_item_new(l_d) || p_org_id,
2020: 37, 1073741824);
2021: if(g_v_item_id.exists(l_hash_value)) then
2022: v_wljdi_inventory_item_id_new(l_d) := g_v_item_id(l_hash_value);

Line 2063: l_hash_value := dbms_utility.get_hash_value(

2059: raise e_wljdi_common_error;
2060: else
2061: l_stmt_num := 50.3;
2062: -- get primary item id from item name
2063: l_hash_value := dbms_utility.get_hash_value(
2064: v_wljdi_primary_item(l_d) || p_org_id,
2065: 37, 1073741824);
2066: if(g_v_item_id.exists(l_hash_value)) then
2067: v_wljdi_primary_item_id(l_d) := g_v_item_id(l_hash_value);

Line 2090: l_hash_value := dbms_utility.get_hash_value(

2086: if v_wljdi_src_phantom_item_id(l_d) IS NULL then
2087: if v_wljdi_src_phantom_item(l_d) IS NOT NULL then
2088: l_stmt_num := 50.4;
2089: -- get item id from item name
2090: l_hash_value := dbms_utility.get_hash_value(
2091: v_wljdi_src_phantom_item(l_d) || p_org_id,
2092: 37, 1073741824);
2093: if(g_v_item_id.exists(l_hash_value)) then
2094: v_wljdi_src_phantom_item_id(l_d) := g_v_item_id(l_hash_value);

Line 2418: l_hash_value := dbms_utility.get_hash_value(

2414: p_error_code := -1;
2415: raise e_wljdi_common_error;
2416: else
2417: -- get resource id from item name
2418: l_hash_value := dbms_utility.get_hash_value(
2419: v_wljdi_resource_code_new(l_d) || p_org_id,
2420: 37, 1073741824);
2421: if(g_v_res_id.exists(l_hash_value)) then
2422: l_resource_id := g_v_res_id(l_hash_value);

Line 6434: l_job_name_hash := dbms_utility.get_hash_value(

6430: end if;
6431: l_stmt_num := 60;
6432: -- add valid job name to g_v_job_name
6433: l_h_valid_rows := l_h_valid_rows + 1;
6434: l_job_name_hash := dbms_utility.get_hash_value(
6435: v_wlji_job_name(l_h) || v_wlji_org_id(l_h),
6436: 37, 1073741824);
6437: g_v_job_name(l_job_name_hash) := v_wlji_job_name(l_h);
6438: g_v_wip_entity_id(l_job_name_hash) := v_wlji_wip_entity_id(l_h);

Line 6527: l_job_name_hash := dbms_utility.get_hash_value(

6523: end if;
6524:
6525: -- add valid job name to g_v_job_name
6526: l_d_valid_rows := l_d_valid_rows + 1;
6527: l_job_name_hash := dbms_utility.get_hash_value(
6528: v_wljdi_job_name(l_d) || v_wljdi_org_id(l_d),
6529: 37, 1073741824);
6530: g_v_job_name(l_job_name_hash) := v_wljdi_job_name(l_d);
6531: g_v_wip_entity_id(l_job_name_hash) := v_wljdi_wip_entity_id(l_d);

Line 6669: l_job_name_hash := dbms_utility.get_hash_value(

6665: l_h := v_wlji_header_id.first;
6666: WHILE l_h <= v_wlji_header_id.last
6667: LOOP
6668: if v_wlji_process_status(l_h) <> WIP_CONSTANTS.ERROR then
6669: l_job_name_hash := dbms_utility.get_hash_value(
6670: v_wlji_job_name(l_h) || v_wlji_org_id(l_h),
6671: 37, 1073741824);
6672: if not l_v_job_gid.exists(l_job_name_hash) then -- one new job name
6673: if mod(l_job_cnt, l_num_jobs_per) = 0 then

Line 6698: l_job_name_hash := dbms_utility.get_hash_value(

6694: l_d := v_wljdi_record_id.first;
6695: WHILE l_d <= v_wljdi_record_id.last
6696: LOOP
6697: if v_wljdi_process_status(l_d) <> WIP_CONSTANTS.ERROR then
6698: l_job_name_hash := dbms_utility.get_hash_value(
6699: v_wljdi_job_name(l_d) || v_wljdi_org_id(l_d),
6700: 37, 1073741824);
6701: if not l_v_job_gid.exists(l_job_name_hash) then -- a new job
6702: if mod(l_job_cnt, l_num_jobs_per) = 0 then

Line 8432: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);

8428: l_xst := WSMPLCVA.v_item.exists(v_wlji_item_id(v_idx));
8429: else -- mode flag 2
8430: hash_str := to_char(v_wlji_item_id(v_idx)) ||
8431: to_char(v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id);
8432: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8433:
8434: l_xst := WSMPLCVA.v_mode2_item.exists(hash_value) AND
8435: (WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8436: = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id) AND

Line 8630: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);

8626: l_stmt_num := 330.1;
8627: -- {{ validation of subinv begin
8628: hash_str := to_char(v_wlji_org_id(v_idx))
8629: ||v_wlji_compl_subinv(v_idx);
8630: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8631: if WSMPLCVA.v_subinv.exists(hash_value) then
8632: NULL;
8633: else
8634: l_aux_mesg := '';

Line 8838: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);

8834:
8835: ELSE
8836: hash_str := to_char(v_wlji_org_id(v_idx))
8837: ||v_wlji_class_code(v_idx);
8838: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8839: if WSMPLCVA.v_class_code.exists(hash_value) then
8840: NULL;
8841: else
8842: raise no_data_found;

Line 9253: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);

9249: v_wlji_compl_loc_id(v_idx) IS NULL THEN
9250:
9251: hash_str := to_char(v_wlji_org_id(v_idx))
9252: ||v_wlji_compl_subinv(v_idx);
9253: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
9254: if WSMPLCVA.v_subinv.exists(hash_value) then
9255: NULL;
9256: else
9257: l_aux_mesg := '';

Line 9442: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);

9438: v_wlji_compl_loc_id(v_idx) IS NULL THEN
9439:
9440: hash_str := to_char(v_wlji_org_id(v_idx))
9441: ||v_wlji_compl_subinv(v_idx);
9442: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
9443: if WSMPLCVA.v_subinv.exists(hash_value) then
9444: NULL;
9445: else
9446: l_aux_mesg := '';

Line 13522: l_hash_value := dbms_utility.get_hash_value(l_hash_str,35,1048576);

13518:
13519: if l_res_recommended = 'Y' then
13520: /* Ideally should check here if this resource is getting recommended...*/
13521: l_hash_str := to_char(p_wip_entity_id) || ':' || to_char(p_rtg_op_seq_num) || ':' || to_char(l_res_id);
13522: l_hash_value := dbms_utility.get_hash_value(l_hash_str,35,1048576);
13523:
13524: if (p_res_recom.exists(l_hash_value) and p_res_recom(l_hash_value) = 'N') then
13525: raise e_invalid_par_seq;
13526: end if;

Line 13532: l_hash_value := dbms_utility.get_hash_value(l_hash_str,35,1048576);

13528: elsif l_res_recommended = 'N' then
13529:
13530: /* Ideally should check here if this resource is getting recommended...*/
13531: l_hash_str := to_char(p_wip_entity_id) || ':' || to_char(p_rtg_op_seq_num) || ':' || to_char(l_res_id);
13532: l_hash_value := dbms_utility.get_hash_value(l_hash_str,35,1048576);
13533:
13534: if not(p_res_recom.exists(l_hash_value) and p_res_recom(l_hash_value) = 'Y') then
13535: raise e_invalid_par_seq;
13536: end if;

Line 18888: l_hash_value := dbms_utility.get_hash_value(l_hash_str,35,1048576); /* 2^20 */

18884: l_v_recoflag(l_out) := 'Y';
18885:
18886: /* here do it..... */
18887: l_hash_str := to_char(p_wip_entity_id) || ':' || to_char(l_rtg_op_seq_num) || ':' || to_char(l_resource_id);
18888: l_hash_value := dbms_utility.get_hash_value(l_hash_str,35,1048576); /* 2^20 */
18889: l_v_res_recom(l_hash_value) := 'Y';
18890: /* ........................... */
18891:
18892: l_resource_id := l_v_res.NEXT(l_resource_id);

Line 18972: l_hash_value := dbms_utility.get_hash_value(l_hash_str,35,1048576); -- 2^20

18968: This shouldnt be a problem only that we will still insert setup resources and then delete it here...
18969: */
18970:
18971: l_hash_str := to_char(p_wip_entity_id) || ':' || to_char(l_rtg_op_seq_num) || ':' || to_char(l_v_disco_res_ids(l_idx2));
18972: l_hash_value := dbms_utility.get_hash_value(l_hash_str,35,1048576); -- 2^20
18973: l_v_res_recom(l_hash_value) := 'N';
18974: /* ........................... */
18975: /* Add code here to delete the setup resource info.....*/
18976: p_error_code := 0;

Line 19501: l_hash_value := dbms_utility.get_hash_value(l_hash_str, 37, 1073741824);

19497: -- BA: bug 3373496 to filter duplicated resource usage records
19498: l_v_dup_usage.delete;
19499: l_hash_str := to_char(l_v_res_use(l_in).start_date, 'DD-MON-YYYY HH24:MI:SS') ||
19500: to_char(l_v_res_use(l_in).completion_date, 'DD-MON-YYYY HH24:MI:SS');
19501: l_hash_value := dbms_utility.get_hash_value(l_hash_str, 37, 1073741824);
19502: l_v_dup_usage(l_hash_value) := l_hash_value;
19503: -- EA: bug 3373496
19504:
19505: l_stmt_num := 410.2;

Line 19530: l_hash_value := dbms_utility.get_hash_value(l_hash_str, 37, 1073741824);

19526:
19527: -- BA: bug 3373496 to filter duplicated resource usage records
19528: l_hash_str := to_char(v_wljdi_start_date(l_d), 'DD-MON-YYYY HH24:MI:SS') ||
19529: to_char(v_wljdi_completion_date(l_d), 'DD-MON-YYYY HH24:MI:SS');
19530: l_hash_value := dbms_utility.get_hash_value(l_hash_str, 37, 1073741824);
19531: -- EA: bug 3373496
19532:
19533: -- BC: bug 3373496 to filter duplicated resource usage records
19534: -- only new value will be added

Line 19687: l_hash_value := dbms_utility.get_hash_value(l_hash_str, 37, 1073741824);

19683: -- BA: bug 3373496 to filter duplicated resource usage records
19684: l_v_dup_usage.delete;
19685: l_hash_str := to_char(l_v_res_use(l_in).start_date, 'DD-MON-YYYY HH24:MI:SS') ||
19686: to_char(l_v_res_use(l_in).completion_date, 'DD-MON-YYYY HH24:MI:SS');
19687: l_hash_value := dbms_utility.get_hash_value(l_hash_str, 37, 1073741824);
19688: l_v_dup_usage(l_hash_value) := l_hash_value;
19689: -- EA: bug 3373496
19690:
19691: l_stmt_num := 420.2;

Line 19716: l_hash_value := dbms_utility.get_hash_value(l_hash_str, 37, 1073741824);

19712:
19713: -- BA: bug 3373496 to filter duplicated resource usage records
19714: l_hash_str := to_char(v_wljdi_start_date(l_d), 'DD-MON-YYYY HH24:MI:SS') ||
19715: to_char(v_wljdi_completion_date(l_d), 'DD-MON-YYYY HH24:MI:SS');
19716: l_hash_value := dbms_utility.get_hash_value(l_hash_str, 37, 1073741824);
19717: -- EA: bug 3373496
19718:
19719: -- BC: bug 3373496 to filter duplicated resource usage records
19720: -- only new value will be added