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 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 2287: l_old_spec_rec gmd_specifications%ROWTYPE;

2283: , x_new_spec_id OUT NOCOPY NUMBER
2284: , x_new_spec_vers OUT NOCOPY NUMBER
2285: , x_return_status OUT NOCOPY VARCHAR2
2286: ) IS
2287: l_old_spec_rec gmd_specifications%ROWTYPE;
2288: l_new_spec_rec gmd_specifications%ROWTYPE;
2289: l_version gmd_specifications.spec_vers%TYPE;
2290: l_spec_id gmd_specifications.spec_id%TYPE;
2291: l_default_spec_sts gmd_specifications.spec_status%TYPE;

Line 2288: l_new_spec_rec gmd_specifications%ROWTYPE;

2284: , x_new_spec_vers OUT NOCOPY NUMBER
2285: , x_return_status OUT NOCOPY VARCHAR2
2286: ) IS
2287: l_old_spec_rec gmd_specifications%ROWTYPE;
2288: l_new_spec_rec gmd_specifications%ROWTYPE;
2289: l_version gmd_specifications.spec_vers%TYPE;
2290: l_spec_id gmd_specifications.spec_id%TYPE;
2291: l_default_spec_sts gmd_specifications.spec_status%TYPE;
2292: l_manage_vr_ind VARCHAR2 (1);

Line 2289: l_version gmd_specifications.spec_vers%TYPE;

2285: , x_return_status OUT NOCOPY VARCHAR2
2286: ) IS
2287: l_old_spec_rec gmd_specifications%ROWTYPE;
2288: l_new_spec_rec gmd_specifications%ROWTYPE;
2289: l_version gmd_specifications.spec_vers%TYPE;
2290: l_spec_id gmd_specifications.spec_id%TYPE;
2291: l_default_spec_sts gmd_specifications.spec_status%TYPE;
2292: l_manage_vr_ind VARCHAR2 (1);
2293: l_row_id VARCHAR2 (200);

Line 2290: l_spec_id gmd_specifications.spec_id%TYPE;

2286: ) IS
2287: l_old_spec_rec gmd_specifications%ROWTYPE;
2288: l_new_spec_rec gmd_specifications%ROWTYPE;
2289: l_version gmd_specifications.spec_vers%TYPE;
2290: l_spec_id gmd_specifications.spec_id%TYPE;
2291: l_default_spec_sts gmd_specifications.spec_status%TYPE;
2292: l_manage_vr_ind VARCHAR2 (1);
2293: l_row_id VARCHAR2 (200);
2294:

Line 2291: l_default_spec_sts gmd_specifications.spec_status%TYPE;

2287: l_old_spec_rec gmd_specifications%ROWTYPE;
2288: l_new_spec_rec gmd_specifications%ROWTYPE;
2289: l_version gmd_specifications.spec_vers%TYPE;
2290: l_spec_id gmd_specifications.spec_id%TYPE;
2291: l_default_spec_sts gmd_specifications.spec_status%TYPE;
2292: l_manage_vr_ind VARCHAR2 (1);
2293: l_row_id VARCHAR2 (200);
2294:
2295: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS

Line 2297: FROM gmd_specifications

2293: l_row_id VARCHAR2 (200);
2294:
2295: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
2296: SELECT *
2297: FROM gmd_specifications
2298: WHERE spec_id = p_spec_id;
2299:
2300: -- Bug# 5882074 Changed orgn_code to orgn_id
2301: CURSOR get_default_status (p_orgn_id IN NUMBER) IS

Line 2358: FROM gmd_specifications

2354:
2355: IF (p_action_code = 'NEWVERS') THEN -- create a new version
2356: SELECT MAX (spec_vers) + 1
2357: INTO l_new_spec_rec.spec_vers
2358: FROM gmd_specifications
2359: WHERE spec_name = l_old_spec_rec.spec_name;
2360: ELSE
2361: NULL;
2362: END IF;

Line 2392: p_spec_rec IN gmd_specifications%ROWTYPE

2388: default_log ('Create New Specification result in Error');
2389: END create_new_specification;
2390:
2391: PROCEDURE insert_new_spec_rec (
2392: p_spec_rec IN gmd_specifications%ROWTYPE
2393: , x_new_spec_id OUT NOCOPY NUMBER
2394: , x_return_status OUT NOCOPY VARCHAR2
2395: ) IS
2396: l_new_spec_rec gmd_specifications%ROWTYPE;

Line 2396: l_new_spec_rec gmd_specifications%ROWTYPE;

2392: p_spec_rec IN gmd_specifications%ROWTYPE
2393: , x_new_spec_id OUT NOCOPY NUMBER
2394: , x_return_status OUT NOCOPY VARCHAR2
2395: ) IS
2396: l_new_spec_rec gmd_specifications%ROWTYPE;
2397: l_spec_id gmd_specifications.spec_id%TYPE;
2398: l_row_id VARCHAR2 (200);
2399: BEGIN
2400: x_return_status := fnd_api.g_ret_sts_success;

Line 2397: l_spec_id gmd_specifications.spec_id%TYPE;

2393: , x_new_spec_id OUT NOCOPY NUMBER
2394: , x_return_status OUT NOCOPY VARCHAR2
2395: ) IS
2396: l_new_spec_rec gmd_specifications%ROWTYPE;
2397: l_spec_id gmd_specifications.spec_id%TYPE;
2398: l_row_id VARCHAR2 (200);
2399: BEGIN
2400: x_return_status := fnd_api.g_ret_sts_success;
2401: l_new_spec_rec := p_spec_rec;

Line 2405: GMD_SPECIFICATIONS_PVT.INSERT_ROW

2401: l_new_spec_rec := p_spec_rec;
2402: DEBUG ('Inserting new version of the spec: ' || l_new_spec_rec.spec_name);
2403: DEBUG ('Inserting new version of the spec ver: ' || l_new_spec_rec.spec_vers);
2404:
2405: GMD_SPECIFICATIONS_PVT.INSERT_ROW
2406: ( x_rowid => l_row_id
2407: , x_spec_id => l_spec_id
2408: , x_spec_name => l_new_spec_rec.spec_name
2409: , x_spec_vers => l_new_spec_rec.spec_vers

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