DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on GME_MATERIAL_DETAILS

Line 177: * @param p_material_detail_rec gme_material_details rowtype

173: * @param p_commit commit flag - default is 'F'
174: * @param x_message_count # of messages
175: * @param x_message_list List of messages
176: * @param x_return_status return status
177: * @param p_material_detail_rec gme_material_details rowtype
178: * @param p_org_code Inventory Organization (Plant or Lab)
179: * @param p_batch_no batch no
180: * @param x_material_detail_rec gme_material_details rowtype
181: * @param p_validity_rule_id validity rule id

Line 180: * @param x_material_detail_rec gme_material_details rowtype

176: * @param x_return_status return status
177: * @param p_material_detail_rec gme_material_details rowtype
178: * @param p_org_code Inventory Organization (Plant or Lab)
179: * @param p_batch_no batch no
180: * @param x_material_detail_rec gme_material_details rowtype
181: * @param p_validity_rule_id validity rule id
182: * @param p_use_workday_cal use shop calendar flag
183: * @param p_contiguity_override contiguity override flag
184: * @param p_use_least_cost_validity_rule use least cost validity rule

Line 224: ,p_material_detail_rec IN gme_material_details%ROWTYPE

220: ,p_commit IN VARCHAR2 := fnd_api.g_false
221: ,x_message_count OUT NOCOPY NUMBER
222: ,x_message_list OUT NOCOPY VARCHAR2
223: ,x_return_status OUT NOCOPY VARCHAR2
224: ,p_material_detail_rec IN gme_material_details%ROWTYPE
225: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
226: ,p_org_code IN VARCHAR2
227: ,p_batch_no IN VARCHAR2 DEFAULT NULL
228: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

Line 228: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

224: ,p_material_detail_rec IN gme_material_details%ROWTYPE
225: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
226: ,p_org_code IN VARCHAR2
227: ,p_batch_no IN VARCHAR2 DEFAULT NULL
228: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
229: ,p_validity_rule_id IN NUMBER
230: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
231: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
232: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

Line 1205: * @param p_material_detail_rec gme_material_details rowtype

1201: * @param x_message_count # of messages
1202: * @param x_message_list List of messages
1203: * @param x_return_status return status
1204: * @param p_batch_header_rec gme_batch_header rowtype
1205: * @param p_material_detail_rec gme_material_details rowtype
1206: * @param p_locator_code Default Consumption/Yield Locator Code
1207: * @param p_org_code Inventory Organization
1208: * @param p_batchstep_no Batch Step Number
1209: * @param p_validate_flexfields whether to validate flex fields value is 'T' or 'F'

Line 1210: * @param x_material_detail_rec gme_material_details rowtype

1206: * @param p_locator_code Default Consumption/Yield Locator Code
1207: * @param p_org_code Inventory Organization
1208: * @param p_batchstep_no Batch Step Number
1209: * @param p_validate_flexfields whether to validate flex fields value is 'T' or 'F'
1210: * @param x_material_detail_rec gme_material_details rowtype
1211: * @rep:scope public
1212: * @rep:lifecycle active
1213: * @rep:displayname insert_material_line
1214: */

Line 1244: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1240: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1241: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1242: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1243: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1244: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1245: ,p_locator_code IN VARCHAR2
1246: ,p_org_code IN VARCHAR2
1247: ,p_batchstep_no IN NUMBER := NULL
1248: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

Line 1249: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

1245: ,p_locator_code IN VARCHAR2
1246: ,p_org_code IN VARCHAR2
1247: ,p_batchstep_no IN NUMBER := NULL
1248: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1249: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1250: ,x_message_count OUT NOCOPY NUMBER
1251: ,x_message_list OUT NOCOPY VARCHAR2
1252: ,x_return_status OUT NOCOPY VARCHAR2);
1253:

Line 1266: * @param p_material_detail_rec gme_material_details rowtype

1262: * @param x_message_count # of messages
1263: * @param x_message_list List of messages
1264: * @param x_return_status return status
1265: * @param p_batch_header_rec gme_batch_header rowtype
1266: * @param p_material_detail_rec gme_material_details rowtype
1267: * @param p_locator_code Default Consumption/Yield Locator Code
1268: * @param p_org_code Inventory Organization
1269: * @param p_scale_phantom flag to indicate whether only phantom product to be scaled or complete phantom batch default is False
1270: * @param p_validate_flexfields whether to validate flex fields value is 'T' or 'F'

Line 1271: * @param x_material_detail_rec gme_material_details rowtype

1267: * @param p_locator_code Default Consumption/Yield Locator Code
1268: * @param p_org_code Inventory Organization
1269: * @param p_scale_phantom flag to indicate whether only phantom product to be scaled or complete phantom batch default is False
1270: * @param p_validate_flexfields whether to validate flex fields value is 'T' or 'F'
1271: * @param x_material_detail_rec gme_material_details rowtype
1272: * @rep:scope public
1273: * @rep:lifecycle active
1274: * @rep:displayname update_material_line
1275: */

Line 1306: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1302: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1303: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1304: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1305: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1306: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1307: ,p_locator_code IN VARCHAR2
1308: ,p_org_code IN VARCHAR2
1309: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
1310: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

Line 1311: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

1307: ,p_locator_code IN VARCHAR2
1308: ,p_org_code IN VARCHAR2
1309: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
1310: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1311: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1312: ,x_message_count OUT NOCOPY NUMBER
1313: ,x_message_list OUT NOCOPY VARCHAR2
1314: ,x_return_status OUT NOCOPY VARCHAR2 );
1315:

Line 1328: * @param p_material_detail_rec gme_material_details rowtype

1324: * @param x_message_count # of messages
1325: * @param x_message_list List of messages
1326: * @param x_return_status return status
1327: * @param p_batch_header_rec gme_batch_header rowtype
1328: * @param p_material_detail_rec gme_material_details rowtype
1329: * @param p_org_code Inventory Organization
1330: * @rep:scope public
1331: * @rep:lifecycle active
1332: * @rep:displayname delete_material_line

Line 1359: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1355: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1356: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1357: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1358: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1359: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1360: ,p_org_code IN VARCHAR2
1361: ,x_message_count OUT NOCOPY NUMBER
1362: ,x_message_list OUT NOCOPY VARCHAR2
1363: ,x_return_status OUT NOCOPY VARCHAR2);

Line 1789: * @param p_material_detail_rec gme_material_details rowtype

1785: * @param x_message_list List of messages
1786: * @param x_return_status return status
1787: * @param p_batch_header_rec gme_batch_header rowtype
1788: * @param p_org_code Organization code that the batch belongs to
1789: * @param p_material_detail_rec gme_material_details rowtype
1790: * @param p_qty Incremental Quantity
1791: * @param p_qty_type Supplied quantity type (incremental, actual, percentage)
1792: * @param p_trans_date Transaction Date for the incremental backflush
1793: * @param p_ignore_exception Ignore exceptions raised during Incremental Backflush

Line 1818: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1814: ,x_message_list OUT NOCOPY VARCHAR2
1815: ,x_return_status OUT NOCOPY VARCHAR2
1816: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1817: ,p_org_code IN VARCHAR2
1818: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1819: ,p_qty IN NUMBER
1820: ,p_qty_type IN NUMBER := 0
1821: ,p_trans_date IN DATE
1822: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

Line 2144: Reflects the UOM defined for gme_material_details.dtl_um

2140: reservation_id (R)
2141:
2142: p_qty_convert (O) The quantity to be converted to an inventory transaction
2143: This can be the full reservation quantity or part of it.
2144: Reflects the UOM defined for gme_material_details.dtl_um
2145: Default value is the full reservation quantity
2146: ================================================================================*/
2147: PROCEDURE convert_dtl_reservation (
2148: p_api_version IN NUMBER := 2.0

Line 2824: ,p_material_detail_rec IN gme_material_details%ROWTYPE

2820: ,p_org_code IN VARCHAR2
2821: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
2822: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
2823: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
2824: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2825: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
2826: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
2827: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
2828: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE);

Line 2883: ,p_material_detail_rec IN gme_material_details%ROWTYPE

2879: ,x_message_list OUT NOCOPY VARCHAR2
2880: ,x_return_status OUT NOCOPY VARCHAR2
2881: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2882: ,p_org_code IN VARCHAR2
2883: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2884: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
2885: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE);
2886:
2887: /*#

Line 2939: ,p_material_detail_rec IN gme_material_details%ROWTYPE

2935: ,x_message_list OUT NOCOPY VARCHAR2
2936: ,x_return_status OUT NOCOPY VARCHAR2
2937: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2938: ,p_org_code IN VARCHAR2
2939: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2940: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE);
2941:
2942: /*#
2943: * Unrelease a batch. Note that identification is required: