DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on GMD_SPEC_MATCH_GRP

Line 1015: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;

1011:
1012:
1013: RETURN BOOLEAN
1014: IS
1015: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1016: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1017: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1018: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1019: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;

Line 1016: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;

1012:
1013: RETURN BOOLEAN
1014: IS
1015: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1016: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1017: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1018: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1019: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1020: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;

Line 1017: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;

1013: RETURN BOOLEAN
1014: IS
1015: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1016: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1017: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1018: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1019: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1020: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;
1021:

Line 1018: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;

1014: IS
1015: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1016: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1017: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1018: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1019: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1020: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;
1021:
1022: BEGIN

Line 1019: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;

1015: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
1016: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1017: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1018: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1019: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1020: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;
1021:
1022: BEGIN
1023:

Line 1020: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;

1016: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
1017: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
1018: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1019: l_location_spec GMD_SPEC_MATCH_GRP.LOCATION_SPEC_REC_TYPE;
1020: l_resource_spec GMD_SPEC_MATCH_GRP.RESOURCE_SPEC_REC_TYPE;
1021:
1022: BEGIN
1023:
1024:

Line 1048: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(

1044:
1045: -- Find Inventory Spec.
1046:
1047:
1048: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(
1049: p_inventory_spec_rec => l_inv_spec,
1050: x_spec_id => x_spec_id,
1051: x_spec_vr_id => x_spec_vr_id,
1052: x_return_status => x_return_status,

Line 1083: IF GMD_SPEC_MATCH_GRP.FIND_CUST_OR_INV_SPEC(

1079: l_cust_spec.date_effective := NVL(p_samples_rec.date_drawn,SYSDATE);
1080:
1081: -- Find Cust Spec.
1082:
1083: IF GMD_SPEC_MATCH_GRP.FIND_CUST_OR_INV_SPEC(
1084: p_customer_spec_rec => l_cust_spec,
1085: x_spec_id => x_spec_id,
1086: x_spec_vr_id => x_spec_vr_id,
1087: x_spec_type => x_spec_type,

Line 1126: IF GMD_SPEC_MATCH_GRP.FIND_WIP_OR_INV_SPEC(

1122:
1123:
1124: -- Find WIP Spec.
1125:
1126: IF GMD_SPEC_MATCH_GRP.FIND_WIP_OR_INV_SPEC(
1127: p_wip_spec_rec => l_wip_spec,
1128: x_spec_id => x_spec_id,
1129: x_spec_vr_id => x_spec_vr_id,
1130: x_spec_type => x_spec_type,

Line 1171: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(

1167:
1168:
1169: -- Find Supplier Spec.
1170:
1171: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(
1172: p_supplier_spec_rec => l_supp_spec,
1173: x_spec_id => x_spec_id,
1174: x_spec_vr_id => x_spec_vr_id,
1175: x_spec_type => x_spec_type,

Line 1190: IF GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC(

1186: l_location_spec.locator_id := p_samples_rec.locator_id;
1187: l_location_spec.locator_organization_id := p_samples_rec.organization_id;
1188: l_location_spec.date_effective := NVL(p_samples_rec.date_drawn,sysdate);
1189:
1190: IF GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC(
1191: p_location_spec_rec => l_location_spec,
1192: x_spec_id => x_spec_id,
1193: x_spec_vr_id => x_spec_vr_id,
1194: x_return_status => x_return_status,

Line 1207: IF GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC(

1203: l_resource_spec.resource_organization_id := p_samples_rec.organization_id;
1204: l_resource_spec.date_effective := nvl(p_samples_rec.date_drawn,sysdate);
1205:
1206:
1207: IF GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC(
1208: p_resource_spec_rec => l_resource_spec,
1209: x_spec_id => x_spec_id,
1210: x_spec_vr_id => x_spec_vr_id,
1211: x_return_status => x_return_status,