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_B

Line 340: l_gmd_spec_rec gmd_specifications_b%ROWTYPE;

336: l_dummy_cnt NUMBER;
337: -- Define different table types
338: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
339: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
340: l_gmd_spec_rec gmd_specifications_b%ROWTYPE;
341: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
342: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
343: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
344: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;

Line 355: l_old_status gmd_specifications_b.spec_status%TYPE;

351: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
352: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
353: l_target_min VARCHAR2 (80);
354: l_target_max VARCHAR2 (80);
355: l_old_status gmd_specifications_b.spec_status%TYPE;
356: l_new_status gmd_specifications_b.spec_status%TYPE;
357: l_old_owner gmd_specifications_b.owner_id%TYPE;
358: l_new_owner gmd_specifications_b.owner_id%TYPE;
359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;

Line 356: l_new_status gmd_specifications_b.spec_status%TYPE;

352: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
353: l_target_min VARCHAR2 (80);
354: l_target_max VARCHAR2 (80);
355: l_old_status gmd_specifications_b.spec_status%TYPE;
356: l_new_status gmd_specifications_b.spec_status%TYPE;
357: l_old_owner gmd_specifications_b.owner_id%TYPE;
358: l_new_owner gmd_specifications_b.owner_id%TYPE;
359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
360: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074

Line 357: l_old_owner gmd_specifications_b.owner_id%TYPE;

353: l_target_min VARCHAR2 (80);
354: l_target_max VARCHAR2 (80);
355: l_old_status gmd_specifications_b.spec_status%TYPE;
356: l_new_status gmd_specifications_b.spec_status%TYPE;
357: l_old_owner gmd_specifications_b.owner_id%TYPE;
358: l_new_owner gmd_specifications_b.owner_id%TYPE;
359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
360: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
361: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074

Line 358: l_new_owner gmd_specifications_b.owner_id%TYPE;

354: l_target_max VARCHAR2 (80);
355: l_old_status gmd_specifications_b.spec_status%TYPE;
356: l_new_status gmd_specifications_b.spec_status%TYPE;
357: l_old_owner gmd_specifications_b.owner_id%TYPE;
358: l_new_owner gmd_specifications_b.owner_id%TYPE;
359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
360: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
361: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
362: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;

Line 359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;

355: l_old_status gmd_specifications_b.spec_status%TYPE;
356: l_new_status gmd_specifications_b.spec_status%TYPE;
357: l_old_owner gmd_specifications_b.owner_id%TYPE;
358: l_new_owner gmd_specifications_b.owner_id%TYPE;
359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
360: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
361: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
362: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
363: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;

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

356: l_new_status gmd_specifications_b.spec_status%TYPE;
357: l_old_owner gmd_specifications_b.owner_id%TYPE;
358: l_new_owner gmd_specifications_b.owner_id%TYPE;
359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
360: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
361: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
362: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
363: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;
364: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;

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

357: l_old_owner gmd_specifications_b.owner_id%TYPE;
358: l_new_owner gmd_specifications_b.owner_id%TYPE;
359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
360: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
361: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
362: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
363: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;
364: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
365: l_rep_test_values_rec gmd_qm_conc_replace_pkg.test_values;

Line 422: FROM gmd_specifications_b

418: WHERE test_id = p_test_id;
419:
420: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
421: SELECT *
422: FROM gmd_specifications_b
423: WHERE spec_id = p_spec_id;
424:
425: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_id IN NUMBER) IS
426: SELECT 1

Line 447: FROM mtl_system_items msi, gmd_specifications_b s

443:
444: -- Bug# 5882074 cursor definition to check for organization
445: CURSOR cur_check_item_org(p_org_id IN NUMBER, p_spec_id IN NUMBER) IS
446: SELECT msi.organization_id, msi.inventory_item_id, msi.revision_qty_control_code, s.revision
447: FROM mtl_system_items msi, gmd_specifications_b s
448: WHERE msi.organization_id = p_org_id
449: AND msi.inventory_item_id = s.inventory_item_id
450: AND s.spec_id = p_spec_id
451: AND msi.process_quality_enabled_flag = 'Y';

Line 621: l_from := ' from gmd_specifications_b spts ';

617: l_where := ' Where spts.spec_id = ' || get_object_rec.object_id;
618: END IF;
619:
620: IF preplace_type in ('REPOWNER','REPOWNERORG') THEN -- Bug#6152381 added this for spec owner and owner org changes
621: l_from := ' from gmd_specifications_b spts ';
622: l_where := ' Where spts.spec_id = ' || get_object_rec.object_id;
623: l_select := 'select spts.*';
624: END IF;
625:

Line 638: FROM gmd_specifications_b

634: SELECT spec_version_control_ind
635: INTO l_state
636: FROM gmd_quality_config
637: WHERE organization_id = (SELECT owner_organization_id
638: FROM gmd_specifications_b
639: WHERE spec_id = get_object_rec.object_id);
640:
641: l_spec_vers_ctl := gmd_spec_grp.version_control_state (
642: p_entity => l_state -- fnd_profile.value('GMD_SPEC_VERSION_CONTROL')

Line 674: UPDATE gmd_specifications_b -- 8281768 added WHO columns.

670: || l_old_status
671: || ' New Status :'
672: || l_new_status);
673:
674: UPDATE gmd_specifications_b -- 8281768 added WHO columns.
675: SET spec_status = l_new_status,
676: LAST_UPDATE_DATE = SYSDATE,
677: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
678: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 734: UPDATE gmd_specifications_b -- 8281768 added WHO columns

730: Into l_new_owner_id
731: From fnd_user
732: Where user_name = l_new_Owner;
733: */
734: UPDATE gmd_specifications_b -- 8281768 added WHO columns
735: SET owner_id = l_new_owner,
736: LAST_UPDATE_DATE = SYSDATE,
737: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
738: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 800: UPDATE gmd_specifications_b -- 8281768 added WHO columns

796: RAISE NO_UPDATE_EXCEPTION;
797: END IF;
798:
799: -- Bug# 5882074 Changed code to id
800: UPDATE gmd_specifications_b -- 8281768 added WHO columns
801: SET owner_organization_id = l_new_ownerorg,
802: LAST_UPDATE_DATE = SYSDATE,
803: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
804: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

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

2271: # create_new_specification
2272: # SYNOPSIS
2273: # create_new_specification
2274: # DESCRIPTION
2275: # Create a row in gmd_specifications_b with the default (input)
2276: # values
2277: # p_action_code can be
2278: # -- 'NEWVERS', new version
2279: ###############################################################*/

Line 2831: l_old_spec_rec gmd_specifications_b%ROWTYPE;

2827: , p_start_date IN DATE DEFAULT NULL
2828: , p_new_status IN NUMBER DEFAULT NULL
2829: , x_return_status OUT NOCOPY VARCHAR2
2830: ) IS
2831: l_old_spec_rec gmd_specifications_b%ROWTYPE;
2832: l_new_spec_rec gmd_specifications_b%ROWTYPE;
2833: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
2834: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
2835: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

Line 2832: l_new_spec_rec gmd_specifications_b%ROWTYPE;

2828: , p_new_status IN NUMBER DEFAULT NULL
2829: , x_return_status OUT NOCOPY VARCHAR2
2830: ) IS
2831: l_old_spec_rec gmd_specifications_b%ROWTYPE;
2832: l_new_spec_rec gmd_specifications_b%ROWTYPE;
2833: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
2834: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
2835: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
2836: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;

Line 2854: FROM gmd_specifications_b

2850: WHERE organization_id = p_orgn_id;
2851:
2852: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
2853: SELECT *
2854: FROM gmd_specifications_b
2855: WHERE spec_id = p_spec_id;
2856:
2857: -- Bug# 5882074 changed code to id
2858: CURSOR get_vrs_rec (p_spec_id IN NUMBER, p_spec_name IN VARCHAR2, p_orgn_id IN NUMBER) IS