APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SPECIFICATIONS

Line 737: FROM gmd_specifications_b

733: PROCEDURE put_spec_in_log(p_spec_id IN NUMBER,
734: x_return_status OUT NOCOPY VARCHAR2) IS
735: CURSOR c_get_spec(p_spec_id NUMBER) IS
736: SELECT spec_name,spec_vers
737: FROM gmd_specifications_b
738: WHERE spec_id = p_spec_id;
739:
740: l_spec_name gmd_specifications.spec_name%TYPE;
741: l_spec_vers gmd_specifications.spec_vers%TYPE;

Line 740: l_spec_name gmd_specifications.spec_name%TYPE;

736: SELECT spec_name,spec_vers
737: FROM gmd_specifications_b
738: WHERE spec_id = p_spec_id;
739:
740: l_spec_name gmd_specifications.spec_name%TYPE;
741: l_spec_vers gmd_specifications.spec_vers%TYPE;
742:
743: BEGIN
744: PrintLn('Begin Procedure put_spec_in_log');

Line 741: l_spec_vers gmd_specifications.spec_vers%TYPE;

737: FROM gmd_specifications_b
738: WHERE spec_id = p_spec_id;
739:
740: l_spec_name gmd_specifications.spec_name%TYPE;
741: l_spec_vers gmd_specifications.spec_vers%TYPE;
742:
743: BEGIN
744: PrintLn('Begin Procedure put_spec_in_log');
745: OPEN c_get_spec(p_spec_id);

Line 1204: FROM gmd_specifications

1200: where spec_vr_id = p_spec_vr_id;
1201:
1202: CURSOR cur_spec_hdr_text(l_spec_id IN NUMBER) IS -- Bug # 4260445 Declared Cursor to get the value of text_code
1203: SELECT text_code
1204: FROM gmd_specifications
1205: WHERE spec_id = l_spec_id;
1206:
1207: p_customer_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;
1208: p_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;