eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_API_PUB dependencies on GME_MATERIAL_DETAILS

Line 180: * @param p_material_detail_rec gme_material_details rowtype

176: * @param p_commit commit flag - default is 'F'
177: * @param x_message_count # of messages
178: * @param x_message_list List of messages
179: * @param x_return_status return status
180: * @param p_material_detail_rec gme_material_details rowtype
181: * @param p_org_code Inventory Organization (Plant or Lab)
182: * @param p_batch_no batch no
183: * @param x_material_detail_rec gme_material_details rowtype
184: * @param p_batch_header_rec gme_batch_header row to pass Flexfields

Line 183: * @param x_material_detail_rec gme_material_details rowtype

179: * @param x_return_status return status
180: * @param p_material_detail_rec gme_material_details rowtype
181: * @param p_org_code Inventory Organization (Plant or Lab)
182: * @param p_batch_no batch no
183: * @param x_material_detail_rec gme_material_details rowtype
184: * @param p_batch_header_rec gme_batch_header row to pass Flexfields
185: * @param p_validity_rule_id validity rule id
186: * @param p_use_workday_cal use shop calendar flag
187: * @param p_contiguity_override contiguity override flag

Line 228: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 232: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

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

Line 1209: * @param p_material_detail_rec gme_material_details rowtype

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

Line 1214: * @param x_material_detail_rec gme_material_details rowtype

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

Line 1248: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1244: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1245: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1246: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1247: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1248: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1249: ,p_locator_code IN VARCHAR2
1250: ,p_org_code IN VARCHAR2
1251: ,p_batchstep_no IN NUMBER := NULL
1252: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

Line 1253: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

1249: ,p_locator_code IN VARCHAR2
1250: ,p_org_code IN VARCHAR2
1251: ,p_batchstep_no IN NUMBER := NULL
1252: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1253: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1254: ,x_message_count OUT NOCOPY NUMBER
1255: ,x_message_list OUT NOCOPY VARCHAR2
1256: ,x_return_status OUT NOCOPY VARCHAR2);
1257:

Line 1270: * @param p_material_detail_rec gme_material_details rowtype

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

Line 1275: * @param x_material_detail_rec gme_material_details rowtype

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

Line 1310: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1306: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1307: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1308: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1309: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1310: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1311: ,p_locator_code IN VARCHAR2
1312: ,p_org_code IN VARCHAR2
1313: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
1314: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

Line 1315: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

1311: ,p_locator_code IN VARCHAR2
1312: ,p_org_code IN VARCHAR2
1313: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
1314: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1315: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1316: ,x_message_count OUT NOCOPY NUMBER
1317: ,x_message_list OUT NOCOPY VARCHAR2
1318: ,x_return_status OUT NOCOPY VARCHAR2 );
1319:

Line 1332: * @param p_material_detail_rec gme_material_details rowtype

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

Line 1363: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 1795: * @param p_material_detail_rec gme_material_details rowtype

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

Line 1824: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1820: ,x_message_list OUT NOCOPY VARCHAR2
1821: ,x_return_status OUT NOCOPY VARCHAR2
1822: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1823: ,p_org_code IN VARCHAR2
1824: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1825: ,p_qty IN NUMBER
1826: ,p_qty_type IN NUMBER := 0
1827: ,p_trans_date IN DATE
1828: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

Line 2156: Reflects the UOM defined for gme_material_details.dtl_um

2152: will default to sysdate.
2153:
2154: p_qty_convert (O) The quantity to be converted to an inventory transaction
2155: This can be the full reservation quantity or part of it.
2156: Reflects the UOM defined for gme_material_details.dtl_um
2157: Default value is the full reservation quantity
2158: Clarification of how p_qty_convert is used from bug 6778968 going forward.
2159: If p_qty_convert passes a negative value, it will result in an error.
2160: When p_qty_convert is equal to or greater than reservation, qty converts the reservation

Line 2848: ,p_material_detail_rec IN gme_material_details%ROWTYPE

2844: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
2845: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
2846: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
2847: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
2848: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2849: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
2850: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
2851: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
2852: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE);

Line 2907: ,p_material_detail_rec IN gme_material_details%ROWTYPE

2903: ,x_message_list OUT NOCOPY VARCHAR2
2904: ,x_return_status OUT NOCOPY VARCHAR2
2905: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2906: ,p_org_code IN VARCHAR2
2907: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2908: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
2909: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE);
2910:
2911: /*#

Line 2963: ,p_material_detail_rec IN gme_material_details%ROWTYPE

2959: ,x_message_list OUT NOCOPY VARCHAR2
2960: ,x_return_status OUT NOCOPY VARCHAR2
2961: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2962: ,p_org_code IN VARCHAR2
2963: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2964: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE);
2965:
2966: /*#
2967: * Unrelease a batch. Note that identification is required: