APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SPECIFICATIONS

Line 780: FROM gmd_specifications_b

776: PROCEDURE put_spec_in_log(p_spec_id IN NUMBER,
777: x_return_status OUT NOCOPY VARCHAR2) IS
778: CURSOR c_get_spec(p_spec_id NUMBER) IS
779: SELECT spec_name,spec_vers
780: FROM gmd_specifications_b
781: WHERE spec_id = p_spec_id;
782:
783: l_spec_name gmd_specifications.spec_name%TYPE;
784: l_spec_vers gmd_specifications.spec_vers%TYPE;

Line 783: l_spec_name gmd_specifications.spec_name%TYPE;

779: SELECT spec_name,spec_vers
780: FROM gmd_specifications_b
781: WHERE spec_id = p_spec_id;
782:
783: l_spec_name gmd_specifications.spec_name%TYPE;
784: l_spec_vers gmd_specifications.spec_vers%TYPE;
785:
786: BEGIN
787: PrintLn('Begin Procedure put_spec_in_log');

Line 784: l_spec_vers gmd_specifications.spec_vers%TYPE;

780: FROM gmd_specifications_b
781: WHERE spec_id = p_spec_id;
782:
783: l_spec_name gmd_specifications.spec_name%TYPE;
784: l_spec_vers gmd_specifications.spec_vers%TYPE;
785:
786: BEGIN
787: PrintLn('Begin Procedure put_spec_in_log');
788: OPEN c_get_spec(p_spec_id);

Line 1275: FROM gmd_specifications

1271: where spec_vr_id = p_spec_vr_id;
1272:
1273: CURSOR cur_spec_hdr_text(l_spec_id IN NUMBER) IS -- Bug # 4260445 Declared Cursor to get the value of text_code
1274: SELECT text_code
1275: FROM gmd_specifications
1276: WHERE spec_id = l_spec_id;
1277:
1278: -- new cursor to get parent_lot_number bug 9655426
1279: CURSOR cur_get_parent_lot is