DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on GME_BATCH_HEADER

Line 70: * @param p_batch_header_rec gme_batch_header rowtype

66: * @param x_message_count # of messages
67: * @param x_message_list List of messages
68: * @param x_return_status return status
69: * @param p_org_code Inventory Organization (Plant or Lab)
70: * @param p_batch_header_rec gme_batch_header rowtype
71: * @param x_batch_header_rec gme_batch_header rowtype
72: * @param p_batch_size batch size
73: * @param p_batch_size_uom batch size uom
74: * @param p_creation_mode creation mode

Line 71: * @param x_batch_header_rec gme_batch_header rowtype

67: * @param x_message_list List of messages
68: * @param x_return_status return status
69: * @param p_org_code Inventory Organization (Plant or Lab)
70: * @param p_batch_header_rec gme_batch_header rowtype
71: * @param x_batch_header_rec gme_batch_header rowtype
72: * @param p_batch_size batch size
73: * @param p_batch_size_uom batch size uom
74: * @param p_creation_mode creation mode
75: * @param p_recipe_id recipe id

Line 149: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

145: ,x_message_count OUT NOCOPY NUMBER
146: ,x_message_list OUT NOCOPY VARCHAR2
147: ,x_return_status OUT NOCOPY VARCHAR2
148: ,p_org_code IN VARCHAR2 := NULL
149: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
150: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
151: ,p_batch_size IN NUMBER := NULL
152: ,p_batch_size_uom IN VARCHAR2 := NULL
153: ,p_creation_mode IN VARCHAR2

Line 150: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

146: ,x_message_list OUT NOCOPY VARCHAR2
147: ,x_return_status OUT NOCOPY VARCHAR2
148: ,p_org_code IN VARCHAR2 := NULL
149: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
150: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
151: ,p_batch_size IN NUMBER := NULL
152: ,p_batch_size_uom IN VARCHAR2 := NULL
153: ,p_creation_mode IN VARCHAR2
154: ,p_recipe_id IN NUMBER := NULL

Line 225: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476

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
229: ,p_validity_rule_id IN NUMBER

Line 246: * @param p_batch_header_rec gme_batch_header rowtype

242: * @param p_commit commit flag - default is 'F'
243: * @param x_message_count # of messages
244: * @param x_message_list List of messages
245: * @param x_return_status return status
246: * @param p_batch_header_rec gme_batch_header rowtype
247: * @param p_org_code Inventory Organization (Plant or Lab)
248: * @param p_ignore_exception Ignore exceptions raised during Scale batch
249: * @param p_use_workday_cal use shop calendar flag
250: * @param p_contiguity_override contiguity override

Line 255: * @param x_batch_header_rec gme_batch_header rowtype

251: * @param p_recalc_dates recalculate dates vased on new resource usage
252: * @param p_scale_factor factor by which quantities should be scaled
253: * @param p_qty_type 1 - batch quantities, 0 - formula quantities
254: * @param p_primaries INPUT scale based in Ingredients, OUTPUT scale based on Products
255: * @param x_batch_header_rec gme_batch_header rowtype
256: * @param x_exception_material_tbl table of exception records
257: * @rep:scope public
258: * @rep:lifecycle active
259: * @rep:displayname reschedule_batch

Line 294: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

290: ,p_validation_level IN NUMBER
291: := gme_common_pvt.g_max_errors
292: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
293: ,p_commit IN VARCHAR2 := fnd_api.g_false
294: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
295: ,p_org_code IN VARCHAR2
296: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
297: ,p_scale_factor IN NUMBER
298: ,p_primaries IN VARCHAR2

Line 307: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

303: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
304: ,x_message_count OUT NOCOPY NUMBER
305: ,x_message_list OUT NOCOPY VARCHAR2
306: ,x_return_status OUT NOCOPY VARCHAR2
307: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
308:
309: /*#
310: * Theoretical Yield Batch Procedure
311: * This procedure calculates theoretical yield for the batch, and updates the

Line 321: * @param p_batch_header_rec gme_batch_header rowtype

317: * @param x_message_list List of messages
318: * @param p_commit commit flag - default is False
319: * @param x_return_status return status
320: * @param p_org_code Inventory Organization (Plant or Lab)
321: * @param p_batch_header_rec gme_batch_header rowtype
322: * @param p_scale_factor scale factor for theoretical yield
323: * @rep:scope public
324: * @rep:lifecycle active
325: * @rep:displayname theoretical_yield_batch

Line 354: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

350: ,p_validation_level IN NUMBER
351: := gme_common_pvt.g_max_errors
352: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
353: ,p_commit IN VARCHAR2 := fnd_api.g_false
354: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
355: ,p_org_code IN VARCHAR2
356: ,p_scale_factor IN NUMBER
357: ,x_message_count OUT NOCOPY NUMBER
358: ,x_message_list OUT NOCOPY VARCHAR2

Line 721: * @param p_batch_header_rec gme_batch_header rowtype

717: * @param x_message_count # of messages
718: * @param x_message_list List of messages
719: * @param x_return_status return status
720: * @param p_org_code Inventory Organization (Plant or Lab)
721: * @param p_batch_header_rec gme_batch_header rowtype
722: * @param p_use_workday_cal use shop calendar flag
723: * @param p_contiguity_override contiguity override
724: * @param x_batch_header_rec gme_batch_header rowtype
725: * @rep:scope public

Line 724: * @param x_batch_header_rec gme_batch_header rowtype

720: * @param p_org_code Inventory Organization (Plant or Lab)
721: * @param p_batch_header_rec gme_batch_header rowtype
722: * @param p_use_workday_cal use shop calendar flag
723: * @param p_contiguity_override contiguity override
724: * @param x_batch_header_rec gme_batch_header rowtype
725: * @rep:scope public
726: * @rep:lifecycle active
727: * @rep:displayname reschedule_batch
728: */

Line 758: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

754: ,p_validation_level IN NUMBER
755: := gme_common_pvt.g_max_errors
756: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
757: ,p_commit IN VARCHAR2 := fnd_api.g_false
758: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
759: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
760: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
761: ,p_org_code IN VARCHAR2
762: ,x_message_count OUT NOCOPY NUMBER

Line 765: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

761: ,p_org_code IN VARCHAR2
762: ,x_message_count OUT NOCOPY NUMBER
763: ,x_message_list OUT NOCOPY VARCHAR2
764: ,x_return_status OUT NOCOPY VARCHAR2
765: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
766:
767: /*#
768: * Reschedule Step Procedure
769: * This procedure reschedules a step and all the subsequent steps, if requested so.

Line 847: * @param p_batch_rec gme_batch_header rowtype

843: * @param x_message_count # of messages
844: * @param x_message_list List of messages
845: * @param x_return_status return status
846: * @param p_org_code Inventory Organization (Plant or Lab)
847: * @param p_batch_rec gme_batch_header rowtype
848: * @rep:scope public
849: * @rep:lifecycle active
850: * @rep:displayname create_batch_reservations
851: */

Line 887: ,p_batch_rec IN gme_batch_header%ROWTYPE

883: ,p_validation_level IN NUMBER
884: := gme_common_pvt.g_max_errors
885: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
886: ,p_commit IN VARCHAR2 := fnd_api.g_false
887: ,p_batch_rec IN gme_batch_header%ROWTYPE
888: ,p_org_code IN VARCHAR2
889: ,x_message_count OUT NOCOPY NUMBER
890: ,x_message_list OUT NOCOPY VARCHAR2
891: ,x_return_status OUT NOCOPY VARCHAR2);

Line 1144: * @param p_batch_header_rec gme_batch_header rowtype

1140: * @param p_org_code Inventory Organization (Plant or Lab)
1141: * @param p_validate_flexfields validate flex fields flag - default is False
1142: * @param p_oprn_no Operation Number
1143: * @param p_oprn_vers Operation Version
1144: * @param p_batch_header_rec gme_batch_header rowtype
1145: * @param p_batch_step_rec gme_batch_steps rowtype
1146: * @param x_batch_step_rec gme_batch_steps rowtype
1147: * @rep:scope public
1148: * @rep:lifecycle active

Line 1187: p_batch_header_rec IN gme_batch_header%ROWTYPE

1183: p_oprn_no IN VARCHAR2
1184: , /* The operation number for the step */
1185: p_oprn_vers IN NUMBER
1186: , /* The operation version for the step */
1187: p_batch_header_rec IN gme_batch_header%ROWTYPE
1188: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1189: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
1190: ,x_message_count OUT NOCOPY NUMBER
1191: ,x_message_list OUT NOCOPY VARCHAR2

Line 1204: * @param p_batch_header_rec gme_batch_header rowtype

1200: * @param p_commit commit flag - default is False
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

Line 1243: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1239: p_api_version IN NUMBER := 2.0
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

Line 1265: * @param p_batch_header_rec gme_batch_header rowtype

1261: * @param p_commit commit flag - default is False
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

Line 1305: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1301: p_api_version IN NUMBER := 2.0
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

Line 1327: * @param p_batch_header_rec gme_batch_header rowtype

1323: * @param p_commit commit flag - default is False
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

Line 1358: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1354: p_api_version IN NUMBER := 2.0
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

Line 1457: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1453: ,x_message_count OUT NOCOPY NUMBER
1454: ,x_message_list OUT NOCOPY VARCHAR2
1455: ,x_return_status OUT NOCOPY VARCHAR2
1456: ,p_org_code IN VARCHAR2
1457: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1458: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1459:
1460: /*#
1461: * Revert Batch Step Procedure

Line 1458: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

1454: ,x_message_list OUT NOCOPY VARCHAR2
1455: ,x_return_status OUT NOCOPY VARCHAR2
1456: ,p_org_code IN VARCHAR2
1457: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1458: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1459:
1460: /*#
1461: * Revert Batch Step Procedure
1462: * This procedure revert step.

Line 1557: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1553: ,p_commit IN VARCHAR2
1554: ,x_message_count OUT NOCOPY NUMBER
1555: ,x_message_list OUT NOCOPY VARCHAR2
1556: ,x_return_status OUT NOCOPY VARCHAR2
1557: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1558: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1559: ,p_org_code IN VARCHAR2);
1560:
1561: /*#

Line 1558: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

1554: ,x_message_count OUT NOCOPY NUMBER
1555: ,x_message_list OUT NOCOPY VARCHAR2
1556: ,x_return_status OUT NOCOPY VARCHAR2
1557: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1558: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1559: ,p_org_code IN VARCHAR2);
1560:
1561: /*#
1562: * Close Batch Step Procedure

Line 1632: * @param p_batch_header_rec gme_batch_header rowtype

1628: * @param x_message_count # of messages
1629: * @param x_message_list List of messages
1630: * @param x_return_status return status
1631: * @param p_org_code Inventory Organization (Plant or Lab)
1632: * @param p_batch_header_rec gme_batch_header rowtype
1633: * @param x_batch_header_rec gme_batch_header rowtype
1634: * @rep:scope public
1635: * @rep:lifecycle active
1636: * @rep:displayname cancel_batch

Line 1633: * @param x_batch_header_rec gme_batch_header rowtype

1629: * @param x_message_list List of messages
1630: * @param x_return_status return status
1631: * @param p_org_code Inventory Organization (Plant or Lab)
1632: * @param p_batch_header_rec gme_batch_header rowtype
1633: * @param x_batch_header_rec gme_batch_header rowtype
1634: * @rep:scope public
1635: * @rep:lifecycle active
1636: * @rep:displayname cancel_batch
1637: */

Line 1666: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1662: ,x_message_count OUT NOCOPY NUMBER
1663: ,x_message_list OUT NOCOPY VARCHAR2
1664: ,x_return_status OUT NOCOPY VARCHAR2
1665: ,p_org_code IN VARCHAR2
1666: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1667: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1668:
1669: /*#
1670: * Reopen Batch Procedure

Line 1667: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

1663: ,x_message_list OUT NOCOPY VARCHAR2
1664: ,x_return_status OUT NOCOPY VARCHAR2
1665: ,p_org_code IN VARCHAR2
1666: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1667: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1668:
1669: /*#
1670: * Reopen Batch Procedure
1671: * This procedure reopens a batch and all associated phantom batches.

Line 1681: * @param p_batch_header_rec gme_batch_header rowtype

1677: * @param x_message_count # of messages
1678: * @param x_message_list List of messages
1679: * @param x_return_status return status
1680: * @param p_org_code Inventory Organization (Plant or Lab)
1681: * @param p_batch_header_rec gme_batch_header rowtype
1682: * @param p_reopen_steps reopen steps flag - default is 'F'
1683: * @param x_batch_header_rec gme_batch_header rowtype
1684: * @rep:scope public
1685: * @rep:lifecycle active

Line 1683: * @param x_batch_header_rec gme_batch_header rowtype

1679: * @param x_return_status return status
1680: * @param p_org_code Inventory Organization (Plant or Lab)
1681: * @param p_batch_header_rec gme_batch_header rowtype
1682: * @param p_reopen_steps reopen steps flag - default is 'F'
1683: * @param x_batch_header_rec gme_batch_header rowtype
1684: * @rep:scope public
1685: * @rep:lifecycle active
1686: * @rep:displayname reopen_batch
1687: */

Line 1719: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1715: ,p_commit IN VARCHAR2
1716: ,x_message_count OUT NOCOPY NUMBER
1717: ,x_message_list OUT NOCOPY VARCHAR2
1718: ,x_return_status OUT NOCOPY VARCHAR2
1719: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1720: ,p_org_code IN VARCHAR2
1721: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
1722: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1723:

Line 1722: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

1718: ,x_return_status OUT NOCOPY VARCHAR2
1719: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1720: ,p_org_code IN VARCHAR2
1721: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
1722: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1723:
1724: /*#
1725: * Reopen Step Procedure
1726: * This procedure reopens a step.

Line 1735: * @param p_batch_header_rec gme_batch_header rowtype

1731: * @param x_message_count # of messages
1732: * @param x_message_list List of messages
1733: * @param x_return_status return status
1734: * @param p_org_code Inventory Organization (Plant or Lab)
1735: * @param p_batch_header_rec gme_batch_header rowtype
1736: * @param p_batch_step_rec gme_batch_steps rowtype
1737: * @param x_batch_step_rec gme_batch_steps rowtype
1738: * @rep:scope public
1739: * @rep:lifecycle active

Line 1773: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1769: ,x_message_count OUT NOCOPY NUMBER
1770: ,x_message_list OUT NOCOPY VARCHAR2
1771: ,x_return_status OUT NOCOPY VARCHAR2
1772: ,p_org_code IN VARCHAR2
1773: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1774: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1775: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
1776:
1777: /*#

Line 1787: * @param p_batch_header_rec gme_batch_header rowtype

1783: * @param p_commit commit flag - default is False
1784: * @param x_message_count # of messages
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)

Line 1816: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1812: ,p_commit IN VARCHAR2 := fnd_api.g_false
1813: ,x_message_count OUT NOCOPY NUMBER
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

Line 1987: * @param p_batch_header_rec gme_batch_header rowtype

1983: * @param p_commit commit flag - default is False
1984: * @param x_message_count # of messages
1985: * @param x_message_list List of messages
1986: * @param x_return_status return status
1987: * @param p_batch_header_rec gme_batch_header rowtype
1988: * @param p_validity_rule_id validity rule id
1989: * @param x_batch_header_rec gme_batch_header rowtype
1990: * @param p_org_code Inventory Organization (Plant or Lab)
1991: * @param p_use_workday_cal Whether workday calendar will be used for batch date calculations

Line 1989: * @param x_batch_header_rec gme_batch_header rowtype

1985: * @param x_message_list List of messages
1986: * @param x_return_status return status
1987: * @param p_batch_header_rec gme_batch_header rowtype
1988: * @param p_validity_rule_id validity rule id
1989: * @param x_batch_header_rec gme_batch_header rowtype
1990: * @param p_org_code Inventory Organization (Plant or Lab)
1991: * @param p_use_workday_cal Whether workday calendar will be used for batch date calculations
1992: * @param p_contiguity_override Whether indicates batch needs to be completed in one contiguous block of time
1993: * @rep:scope public

Line 2028: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2024: ,p_init_msg_list IN VARCHAR2
2025: DEFAULT fnd_api.g_false
2026: ,p_commit IN VARCHAR2
2027: DEFAULT fnd_api.g_false
2028: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2029: ,p_validity_rule_id IN NUMBER
2030: ,p_org_code IN VARCHAR2
2031: ,p_use_workday_cal IN VARCHAR2
2032: DEFAULT fnd_api.g_false

Line 2038: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

2034: DEFAULT fnd_api.g_false
2035: ,x_message_count OUT NOCOPY NUMBER
2036: ,x_message_list OUT NOCOPY VARCHAR2
2037: ,x_return_status OUT NOCOPY VARCHAR2
2038: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
2039:
2040:
2041: /*#
2042: * Terminate Batch Procedure

Line 2054: * @param p_batch_header_rec gme_batch_header rowtype

2050: * @param x_message_list List of messages
2051: * @param x_return_status return status
2052: * @param p_org_code Inventory Organization (Plant or Lab)
2053: * @param p_reason_name Reason Code for termination
2054: * @param p_batch_header_rec gme_batch_header rowtype
2055: * @param x_batch_header_rec gme_batch_header rowtype
2056: * @rep:scope public
2057: * @rep:lifecycle active
2058: * @rep:displayname terminate_batch

Line 2055: * @param x_batch_header_rec gme_batch_header rowtype

2051: * @param x_return_status return status
2052: * @param p_org_code Inventory Organization (Plant or Lab)
2053: * @param p_reason_name Reason Code for termination
2054: * @param p_batch_header_rec gme_batch_header rowtype
2055: * @param x_batch_header_rec gme_batch_header rowtype
2056: * @rep:scope public
2057: * @rep:lifecycle active
2058: * @rep:displayname terminate_batch
2059: */

Line 2091: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2087: ,x_message_list OUT NOCOPY VARCHAR2
2088: ,x_return_status OUT NOCOPY VARCHAR2
2089: ,p_org_code IN VARCHAR2
2090: ,p_reason_name IN VARCHAR2
2091: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2092: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
2093:
2094: /*#
2095: * Convert Detail Reservation Procedure

Line 2092: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

2088: ,x_return_status OUT NOCOPY VARCHAR2
2089: ,p_org_code IN VARCHAR2
2090: ,p_reason_name IN VARCHAR2
2091: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2092: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
2093:
2094: /*#
2095: * Convert Detail Reservation Procedure
2096: * This procedure converted detail level reservation into transaction

Line 2475: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE);

2471: ,x_message_count OUT NOCOPY NUMBER
2472: ,x_message_list OUT NOCOPY VARCHAR2
2473: ,x_return_status OUT NOCOPY VARCHAR2
2474: ,p_org_code IN VARCHAR2
2475: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE);
2476: /*#
2477: * Inserts an activity for a step.
2478: * @param p_api_version Version of the api
2479: * @param p_validation_level validation level

Line 2668: * @param p_batch_header gme_batch_header rowtype

2664: * @param x_message_list List of messages
2665: * @param p_enforce_vldt_check enforce validity check
2666: * @param x_return_status return status
2667: * @param p_org_code organization code
2668: * @param p_batch_header gme_batch_header rowtype
2669: * @param x_batch_header gme_batch_header rowtype
2670: * @param p_batch_size batch size
2671: * @param p_num_batches number of batches
2672: * @param p_validity_rule_id recipe_validity_rule_id Validity rule id

Line 2669: * @param x_batch_header gme_batch_header rowtype

2665: * @param p_enforce_vldt_check enforce validity check
2666: * @param x_return_status return status
2667: * @param p_org_code organization code
2668: * @param p_batch_header gme_batch_header rowtype
2669: * @param x_batch_header gme_batch_header rowtype
2670: * @param p_batch_size batch size
2671: * @param p_num_batches number of batches
2672: * @param p_validity_rule_id recipe_validity_rule_id Validity rule id
2673: * @param p_validity_rule_tab recipe_validity_rule_tab record type

Line 2736: ,p_batch_header IN gme_batch_header%ROWTYPE

2732: ,x_message_list OUT NOCOPY VARCHAR2
2733: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
2734: ,x_return_status OUT NOCOPY VARCHAR2
2735: ,p_org_code IN VARCHAR2 := NULL
2736: ,p_batch_header IN gme_batch_header%ROWTYPE
2737: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
2738: ,p_batch_size IN NUMBER
2739: ,p_num_batches IN NUMBER
2740: ,p_validity_rule_id IN NUMBER

Line 2737: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE

2733: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
2734: ,x_return_status OUT NOCOPY VARCHAR2
2735: ,p_org_code IN VARCHAR2 := NULL
2736: ,p_batch_header IN gme_batch_header%ROWTYPE
2737: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
2738: ,p_batch_size IN NUMBER
2739: ,p_num_batches IN NUMBER
2740: ,p_validity_rule_id IN NUMBER
2741: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab

Line 2745: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE

2741: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab
2742: ,p_leadtime IN NUMBER DEFAULT 0
2743: ,p_batch_offset IN NUMBER DEFAULT 0
2744: ,p_offset_type IN NUMBER DEFAULT 0
2745: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2746: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2747: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2748: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2749: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);

Line 2746: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE

2742: ,p_leadtime IN NUMBER DEFAULT 0
2743: ,p_batch_offset IN NUMBER DEFAULT 0
2744: ,p_offset_type IN NUMBER DEFAULT 0
2745: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2746: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2747: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2748: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2749: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
2750:

Line 2819: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2815: ,p_commit IN VARCHAR2 := fnd_api.g_false
2816: ,x_message_count OUT NOCOPY NUMBER
2817: ,x_message_list OUT NOCOPY VARCHAR2
2818: ,x_return_status OUT NOCOPY VARCHAR2
2819: ,p_batch_header_rec IN gme_batch_header%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

Line 2881: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2877: ,p_commit IN VARCHAR2 := fnd_api.g_false
2878: ,x_message_count OUT NOCOPY NUMBER
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);

Line 2937: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2933: ,p_commit IN VARCHAR2 := fnd_api.g_false
2934: ,x_message_count OUT NOCOPY NUMBER
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:

Line 2990: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2986: ,p_commit IN VARCHAR2 := fnd_api.g_false
2987: ,x_message_count OUT NOCOPY NUMBER
2988: ,x_message_list OUT NOCOPY VARCHAR2
2989: ,x_return_status OUT NOCOPY VARCHAR2
2990: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2991: ,p_org_code IN VARCHAR2
2992: ,p_create_resv_pend_lots IN NUMBER
2993: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
2994:

Line 2993: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

2989: ,x_return_status OUT NOCOPY VARCHAR2
2990: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2991: ,p_org_code IN VARCHAR2
2992: ,p_create_resv_pend_lots IN NUMBER
2993: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
2994:
2995: /*#
2996: * Unrelease a step. Note that identification is required:
2997: * p_batchstep_id or p_batch_id, p_batchstep_no or p_batch_no, p_org_code

Line 3108: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3104: ,p_commit IN VARCHAR2 := fnd_api.g_false
3105: ,x_message_count OUT NOCOPY NUMBER
3106: ,x_message_list OUT NOCOPY VARCHAR2
3107: ,x_return_status OUT NOCOPY VARCHAR2
3108: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3109: ,p_org_code IN VARCHAR2
3110: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3111: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3112: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 3112: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

3108: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3109: ,p_org_code IN VARCHAR2
3110: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3111: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3112: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3113: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3114:
3115: /*#
3116: * Complete a step. Note that identification is required:

Line 3237: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3233: ,p_commit IN VARCHAR2 := fnd_api.g_false
3234: ,x_message_count OUT NOCOPY NUMBER
3235: ,x_message_list OUT NOCOPY VARCHAR2
3236: ,x_return_status OUT NOCOPY VARCHAR2
3237: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3238: ,p_org_code IN VARCHAR2
3239: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3240: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3241: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 3241: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

3237: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3238: ,p_org_code IN VARCHAR2
3239: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3240: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3241: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3242: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3243:
3244: /*#
3245: * Release a step. Note that identification is required: