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.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_SPECIFICATIONS

Line 109: p_spec_rec IN gmd_specifications%ROWTYPE

105: , x_return_status OUT NOCOPY VARCHAR2
106: );
107:
108: PROCEDURE insert_new_spec_rec (
109: p_spec_rec IN gmd_specifications%ROWTYPE
110: , x_new_spec_id OUT NOCOPY NUMBER
111: , x_return_status OUT NOCOPY VARCHAR2
112: );
113:

Line 332: l_gmd_spec_rec gmd_specifications_b%ROWTYPE;

328: l_dummy_cnt NUMBER;
329: -- Define different table types
330: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
331: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
332: l_gmd_spec_rec gmd_specifications_b%ROWTYPE;
333: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
334: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
335: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;

Line 347: l_old_status gmd_specifications_b.spec_status%TYPE;

343: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
344: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
345: l_target_min VARCHAR2 (80);
346: l_target_max VARCHAR2 (80);
347: l_old_status gmd_specifications_b.spec_status%TYPE;
348: l_new_status gmd_specifications_b.spec_status%TYPE;
349: l_old_owner gmd_specifications_b.owner_id%TYPE;
350: l_new_owner gmd_specifications_b.owner_id%TYPE;
351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;

Line 348: l_new_status gmd_specifications_b.spec_status%TYPE;

344: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
345: l_target_min VARCHAR2 (80);
346: l_target_max VARCHAR2 (80);
347: l_old_status gmd_specifications_b.spec_status%TYPE;
348: l_new_status gmd_specifications_b.spec_status%TYPE;
349: l_old_owner gmd_specifications_b.owner_id%TYPE;
350: l_new_owner gmd_specifications_b.owner_id%TYPE;
351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074

Line 349: l_old_owner gmd_specifications_b.owner_id%TYPE;

345: l_target_min VARCHAR2 (80);
346: l_target_max VARCHAR2 (80);
347: l_old_status gmd_specifications_b.spec_status%TYPE;
348: l_new_status gmd_specifications_b.spec_status%TYPE;
349: l_old_owner gmd_specifications_b.owner_id%TYPE;
350: l_new_owner gmd_specifications_b.owner_id%TYPE;
351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
353: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074

Line 350: l_new_owner gmd_specifications_b.owner_id%TYPE;

346: l_target_max VARCHAR2 (80);
347: l_old_status gmd_specifications_b.spec_status%TYPE;
348: l_new_status gmd_specifications_b.spec_status%TYPE;
349: l_old_owner gmd_specifications_b.owner_id%TYPE;
350: l_new_owner gmd_specifications_b.owner_id%TYPE;
351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
353: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
354: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;

Line 351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;

347: l_old_status gmd_specifications_b.spec_status%TYPE;
348: l_new_status gmd_specifications_b.spec_status%TYPE;
349: l_old_owner gmd_specifications_b.owner_id%TYPE;
350: l_new_owner gmd_specifications_b.owner_id%TYPE;
351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
353: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
354: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
355: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;

Line 352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074

348: l_new_status gmd_specifications_b.spec_status%TYPE;
349: l_old_owner gmd_specifications_b.owner_id%TYPE;
350: l_new_owner gmd_specifications_b.owner_id%TYPE;
351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
353: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
354: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
355: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;
356: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;

Line 353: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074

349: l_old_owner gmd_specifications_b.owner_id%TYPE;
350: l_new_owner gmd_specifications_b.owner_id%TYPE;
351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
353: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
354: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
355: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;
356: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
357: l_rep_test_values_rec gmd_qm_conc_replace_pkg.test_values;

Line 413: FROM gmd_specifications_b

409: WHERE test_id = p_test_id;
410:
411: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
412: SELECT *
413: FROM gmd_specifications_b
414: WHERE spec_id = p_spec_id;
415:
416: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_id IN NUMBER) IS
417: SELECT 1

Line 438: FROM mtl_system_items msi, gmd_specifications_b s

434:
435: -- Bug# 5882074 cursor definition to check for organization
436: CURSOR cur_check_item_org(p_org_id IN NUMBER, p_spec_id IN NUMBER) IS
437: SELECT msi.organization_id, msi.inventory_item_id, msi.revision_qty_control_code, s.revision
438: FROM mtl_system_items msi, gmd_specifications_b s
439: WHERE msi.organization_id = p_org_id
440: AND msi.inventory_item_id = s.inventory_item_id
441: AND s.spec_id = p_spec_id
442: AND msi.process_quality_enabled_flag = 'Y';

Line 610: FROM gmd_specifications_b

606: SELECT spec_version_control_ind
607: INTO l_state
608: FROM gmd_quality_config
609: WHERE organization_id = (SELECT owner_organization_id
610: FROM gmd_specifications_b
611: WHERE spec_id = get_object_rec.object_id);
612:
613: l_spec_vers_ctl := gmd_spec_grp.version_control_state (
614: p_entity => l_state -- fnd_profile.value('GMD_SPEC_VERSION_CONTROL')

Line 646: UPDATE gmd_specifications_b

642: || l_old_status
643: || ' New Status :'
644: || l_new_status);
645:
646: UPDATE gmd_specifications_b
647: SET spec_status = l_new_status
648: WHERE spec_id = get_object_rec.object_id;
649:
650: default_log (' Update Specification Succesful');

Line 678: UPDATE gmd_specifications_b

674: Into l_new_owner_id
675: From fnd_user
676: Where user_name = l_new_Owner;
677: */
678: UPDATE gmd_specifications_b
679: SET owner_id = l_new_owner
680: WHERE spec_id = get_object_rec.object_id;
681: default_log (' Update Specification Succesful');
682: else

Line 728: UPDATE gmd_specifications_b

724: RAISE NO_UPDATE_EXCEPTION;
725: END IF;
726:
727: -- Bug# 5882074 Changed code to id
728: UPDATE gmd_specifications_b
729: SET owner_organization_id = l_new_ownerorg
730: WHERE spec_id = get_object_rec.object_id;
731:
732: default_log ( ' Replace Spec OwnerOrganization, Spec Name: '

Line 2166: # Create a row in gmd_specifications_b with the default (input)

2162: # create_new_specification
2163: # SYNOPSIS
2164: # create_new_specification
2165: # DESCRIPTION
2166: # Create a row in gmd_specifications_b with the default (input)
2167: # values
2168: # p_action_code can be
2169: # -- 'NEWVERS', new version
2170: ###############################################################*/

Line 2178: l_old_spec_rec gmd_specifications%ROWTYPE;

2174: , x_new_spec_id OUT NOCOPY NUMBER
2175: , x_new_spec_vers OUT NOCOPY NUMBER
2176: , x_return_status OUT NOCOPY VARCHAR2
2177: ) IS
2178: l_old_spec_rec gmd_specifications%ROWTYPE;
2179: l_new_spec_rec gmd_specifications%ROWTYPE;
2180: l_version gmd_specifications.spec_vers%TYPE;
2181: l_spec_id gmd_specifications.spec_id%TYPE;
2182: l_default_spec_sts gmd_specifications.spec_status%TYPE;

Line 2179: l_new_spec_rec gmd_specifications%ROWTYPE;

2175: , x_new_spec_vers OUT NOCOPY NUMBER
2176: , x_return_status OUT NOCOPY VARCHAR2
2177: ) IS
2178: l_old_spec_rec gmd_specifications%ROWTYPE;
2179: l_new_spec_rec gmd_specifications%ROWTYPE;
2180: l_version gmd_specifications.spec_vers%TYPE;
2181: l_spec_id gmd_specifications.spec_id%TYPE;
2182: l_default_spec_sts gmd_specifications.spec_status%TYPE;
2183: l_manage_vr_ind VARCHAR2 (1);

Line 2180: l_version gmd_specifications.spec_vers%TYPE;

2176: , x_return_status OUT NOCOPY VARCHAR2
2177: ) IS
2178: l_old_spec_rec gmd_specifications%ROWTYPE;
2179: l_new_spec_rec gmd_specifications%ROWTYPE;
2180: l_version gmd_specifications.spec_vers%TYPE;
2181: l_spec_id gmd_specifications.spec_id%TYPE;
2182: l_default_spec_sts gmd_specifications.spec_status%TYPE;
2183: l_manage_vr_ind VARCHAR2 (1);
2184: l_row_id VARCHAR2 (200);

Line 2181: l_spec_id gmd_specifications.spec_id%TYPE;

2177: ) IS
2178: l_old_spec_rec gmd_specifications%ROWTYPE;
2179: l_new_spec_rec gmd_specifications%ROWTYPE;
2180: l_version gmd_specifications.spec_vers%TYPE;
2181: l_spec_id gmd_specifications.spec_id%TYPE;
2182: l_default_spec_sts gmd_specifications.spec_status%TYPE;
2183: l_manage_vr_ind VARCHAR2 (1);
2184: l_row_id VARCHAR2 (200);
2185:

Line 2182: l_default_spec_sts gmd_specifications.spec_status%TYPE;

2178: l_old_spec_rec gmd_specifications%ROWTYPE;
2179: l_new_spec_rec gmd_specifications%ROWTYPE;
2180: l_version gmd_specifications.spec_vers%TYPE;
2181: l_spec_id gmd_specifications.spec_id%TYPE;
2182: l_default_spec_sts gmd_specifications.spec_status%TYPE;
2183: l_manage_vr_ind VARCHAR2 (1);
2184: l_row_id VARCHAR2 (200);
2185:
2186: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS

Line 2188: FROM gmd_specifications

2184: l_row_id VARCHAR2 (200);
2185:
2186: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
2187: SELECT *
2188: FROM gmd_specifications
2189: WHERE spec_id = p_spec_id;
2190:
2191: -- Bug# 5882074 Changed orgn_code to orgn_id
2192: CURSOR get_default_status (p_orgn_id IN NUMBER) IS

Line 2249: FROM gmd_specifications

2245:
2246: IF (p_action_code = 'NEWVERS') THEN -- create a new version
2247: SELECT MAX (spec_vers) + 1
2248: INTO l_new_spec_rec.spec_vers
2249: FROM gmd_specifications
2250: WHERE spec_name = l_old_spec_rec.spec_name;
2251: ELSE
2252: NULL;
2253: END IF;

Line 2283: p_spec_rec IN gmd_specifications%ROWTYPE

2279: default_log ('Create New Specification result in Error');
2280: END create_new_specification;
2281:
2282: PROCEDURE insert_new_spec_rec (
2283: p_spec_rec IN gmd_specifications%ROWTYPE
2284: , x_new_spec_id OUT NOCOPY NUMBER
2285: , x_return_status OUT NOCOPY VARCHAR2
2286: ) IS
2287: l_new_spec_rec gmd_specifications%ROWTYPE;

Line 2287: l_new_spec_rec gmd_specifications%ROWTYPE;

2283: p_spec_rec IN gmd_specifications%ROWTYPE
2284: , x_new_spec_id OUT NOCOPY NUMBER
2285: , x_return_status OUT NOCOPY VARCHAR2
2286: ) IS
2287: l_new_spec_rec gmd_specifications%ROWTYPE;
2288: l_spec_id gmd_specifications.spec_id%TYPE;
2289: l_row_id VARCHAR2 (200);
2290: BEGIN
2291: x_return_status := fnd_api.g_ret_sts_success;

Line 2288: l_spec_id gmd_specifications.spec_id%TYPE;

2284: , x_new_spec_id OUT NOCOPY NUMBER
2285: , x_return_status OUT NOCOPY VARCHAR2
2286: ) IS
2287: l_new_spec_rec gmd_specifications%ROWTYPE;
2288: l_spec_id gmd_specifications.spec_id%TYPE;
2289: l_row_id VARCHAR2 (200);
2290: BEGIN
2291: x_return_status := fnd_api.g_ret_sts_success;
2292: l_new_spec_rec := p_spec_rec;

Line 2296: GMD_SPECIFICATIONS_PVT.INSERT_ROW

2292: l_new_spec_rec := p_spec_rec;
2293: DEBUG ('Inserting new version of the spec: ' || l_new_spec_rec.spec_name);
2294: DEBUG ('Inserting new version of the spec ver: ' || l_new_spec_rec.spec_vers);
2295:
2296: GMD_SPECIFICATIONS_PVT.INSERT_ROW
2297: ( x_rowid => l_row_id
2298: , x_spec_id => l_spec_id
2299: , x_spec_name => l_new_spec_rec.spec_name
2300: , x_spec_vers => l_new_spec_rec.spec_vers

Line 2719: l_old_spec_rec gmd_specifications_b%ROWTYPE;

2715: , p_start_date IN DATE DEFAULT NULL
2716: , p_new_status IN NUMBER DEFAULT NULL
2717: , x_return_status OUT NOCOPY VARCHAR2
2718: ) IS
2719: l_old_spec_rec gmd_specifications_b%ROWTYPE;
2720: l_new_spec_rec gmd_specifications_b%ROWTYPE;
2721: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
2722: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
2723: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

Line 2720: l_new_spec_rec gmd_specifications_b%ROWTYPE;

2716: , p_new_status IN NUMBER DEFAULT NULL
2717: , x_return_status OUT NOCOPY VARCHAR2
2718: ) IS
2719: l_old_spec_rec gmd_specifications_b%ROWTYPE;
2720: l_new_spec_rec gmd_specifications_b%ROWTYPE;
2721: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
2722: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
2723: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
2724: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;

Line 2742: FROM gmd_specifications_b

2738: WHERE organization_id = p_orgn_id;
2739:
2740: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
2741: SELECT *
2742: FROM gmd_specifications_b
2743: WHERE spec_id = p_spec_id;
2744:
2745: -- Bug# 5882074 changed code to id
2746: CURSOR get_vrs_rec (p_spec_id IN NUMBER, p_spec_name IN VARCHAR2, p_orgn_id IN NUMBER) IS