DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on GMD_SPEC_MATCH_GRP

Line 1099: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;

1095:
1096:
1097: RETURN BOOLEAN
1098: IS
1099: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1100: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1101: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1102: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1103: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;

Line 1100: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;

1096:
1097: RETURN BOOLEAN
1098: IS
1099: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1100: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1101: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1102: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1103: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1104: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;

Line 1101: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;

1097: RETURN BOOLEAN
1098: IS
1099: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1100: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1101: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1102: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1103: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1104: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;
1105:

Line 1102: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;

1098: IS
1099: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1100: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1101: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1102: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1103: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1104: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;
1105:
1106: BEGIN

Line 1103: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;

1099: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1100: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1101: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1102: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1103: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1104: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;
1105:
1106: BEGIN
1107:

Line 1104: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;

1100: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1101: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1102: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1103: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1104: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;
1105:
1106: BEGIN
1107:
1108:

Line 1132: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(

1128:
1129: -- Find Inventory Spec.
1130:
1131:
1132: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(
1133: p_inventory_spec_rec => l_inv_spec,
1134: x_spec_id => x_spec_id,
1135: x_spec_vr_id => x_spec_vr_id,
1136: x_return_status => x_return_status,

Line 1167: IF GMD_SPEC_MATCH_GRP.FIND_CUST_OR_INV_SPEC(

1163: l_cust_spec.date_effective := NVL(p_samples_rec.date_drawn,SYSDATE);
1164:
1165: -- Find Cust Spec.
1166:
1167: IF GMD_SPEC_MATCH_GRP.FIND_CUST_OR_INV_SPEC(
1168: p_customer_spec_rec => l_cust_spec,
1169: x_spec_id => x_spec_id,
1170: x_spec_vr_id => x_spec_vr_id,
1171: x_spec_type => x_spec_type,

Line 1210: IF GMD_SPEC_MATCH_GRP.FIND_WIP_OR_INV_SPEC(

1206:
1207:
1208: -- Find WIP Spec.
1209:
1210: IF GMD_SPEC_MATCH_GRP.FIND_WIP_OR_INV_SPEC(
1211: p_wip_spec_rec => l_wip_spec,
1212: x_spec_id => x_spec_id,
1213: x_spec_vr_id => x_spec_vr_id,
1214: x_spec_type => x_spec_type,

Line 1255: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(

1251:
1252:
1253: -- Find Supplier Spec.
1254:
1255: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(
1256: p_supplier_spec_rec => l_supp_spec,
1257: x_spec_id => x_spec_id,
1258: x_spec_vr_id => x_spec_vr_id,
1259: x_spec_type => x_spec_type,

Line 1274: IF GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC(

1270: l_location_spec.locator_id := p_samples_rec.locator_id;
1271: l_location_spec.locator_organization_id := p_samples_rec.organization_id;
1272: l_location_spec.date_effective := NVL(p_samples_rec.date_drawn,sysdate);
1273:
1274: IF GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC(
1275: p_location_spec_rec => l_location_spec,
1276: x_spec_id => x_spec_id,
1277: x_spec_vr_id => x_spec_vr_id,
1278: x_return_status => x_return_status,

Line 1291: IF GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC(

1287: l_resource_spec.resource_organization_id := p_samples_rec.organization_id;
1288: l_resource_spec.date_effective := nvl(p_samples_rec.date_drawn,sysdate);
1289:
1290:
1291: IF GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC(
1292: p_resource_spec_rec => l_resource_spec,
1293: x_spec_id => x_spec_id,
1294: x_spec_vr_id => x_spec_vr_id,
1295: x_return_status => x_return_status,