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 151: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 152: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

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

Line 184: * @param p_batch_header_rec gme_batch_header row to pass Flexfields

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
188: * @param p_use_least_cost_validity_rule use least cost validity rule

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

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

Line 250: * @param p_batch_header_rec gme_batch_header rowtype

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

Line 259: * @param x_batch_header_rec gme_batch_header rowtype

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

Line 298: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

294: ,p_validation_level IN NUMBER
295: := gme_common_pvt.g_max_errors
296: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
297: ,p_commit IN VARCHAR2 := fnd_api.g_false
298: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
299: ,p_org_code IN VARCHAR2
300: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
301: ,p_scale_factor IN NUMBER
302: ,p_primaries IN VARCHAR2

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

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

Line 325: * @param p_batch_header_rec gme_batch_header rowtype

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

Line 358: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

354: ,p_validation_level IN NUMBER
355: := gme_common_pvt.g_max_errors
356: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
357: ,p_commit IN VARCHAR2 := fnd_api.g_false
358: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
359: ,p_org_code IN VARCHAR2
360: ,p_scale_factor IN NUMBER
361: ,x_message_count OUT NOCOPY NUMBER
362: ,x_message_list OUT NOCOPY VARCHAR2

Line 725: * @param p_batch_header_rec gme_batch_header rowtype

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

Line 728: * @param x_batch_header_rec gme_batch_header rowtype

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

Line 762: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

758: ,p_validation_level IN NUMBER
759: := gme_common_pvt.g_max_errors
760: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
761: ,p_commit IN VARCHAR2 := fnd_api.g_false
762: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
763: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
764: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
765: ,p_org_code IN VARCHAR2
766: ,x_message_count OUT NOCOPY NUMBER

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

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

Line 851: * @param p_batch_rec gme_batch_header rowtype

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

Line 891: ,p_batch_rec IN gme_batch_header%ROWTYPE

887: ,p_validation_level IN NUMBER
888: := gme_common_pvt.g_max_errors
889: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
890: ,p_commit IN VARCHAR2 := fnd_api.g_false
891: ,p_batch_rec IN gme_batch_header%ROWTYPE
892: ,p_org_code IN VARCHAR2
893: ,x_message_count OUT NOCOPY NUMBER
894: ,x_message_list OUT NOCOPY VARCHAR2
895: ,x_return_status OUT NOCOPY VARCHAR2);

Line 1148: * @param p_batch_header_rec gme_batch_header rowtype

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

Line 1191: p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 1208: * @param p_batch_header_rec gme_batch_header rowtype

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

Line 1247: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 1269: * @param p_batch_header_rec gme_batch_header rowtype

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

Line 1309: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 1331: * @param p_batch_header_rec gme_batch_header rowtype

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

Line 1362: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 1463: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1459: ,x_message_count OUT NOCOPY NUMBER
1460: ,x_message_list OUT NOCOPY VARCHAR2
1461: ,x_return_status OUT NOCOPY VARCHAR2
1462: ,p_org_code IN VARCHAR2
1463: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1464: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1465:
1466: /*#
1467: * Revert Batch Step Procedure

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

1460: ,x_message_list OUT NOCOPY VARCHAR2
1461: ,x_return_status OUT NOCOPY VARCHAR2
1462: ,p_org_code IN VARCHAR2
1463: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1464: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1465:
1466: /*#
1467: * Revert Batch Step Procedure
1468: * This procedure revert step.

Line 1563: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1559: ,p_commit IN VARCHAR2
1560: ,x_message_count OUT NOCOPY NUMBER
1561: ,x_message_list OUT NOCOPY VARCHAR2
1562: ,x_return_status OUT NOCOPY VARCHAR2
1563: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1564: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1565: ,p_org_code IN VARCHAR2);
1566:
1567: /*#

Line 1564: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

1560: ,x_message_count OUT NOCOPY NUMBER
1561: ,x_message_list OUT NOCOPY VARCHAR2
1562: ,x_return_status OUT NOCOPY VARCHAR2
1563: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1564: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1565: ,p_org_code IN VARCHAR2);
1566:
1567: /*#
1568: * Close Batch Step Procedure

Line 1638: * @param p_batch_header_rec gme_batch_header rowtype

1634: * @param x_message_count # of messages
1635: * @param x_message_list List of messages
1636: * @param x_return_status return status
1637: * @param p_org_code Inventory Organization (Plant or Lab)
1638: * @param p_batch_header_rec gme_batch_header rowtype
1639: * @param x_batch_header_rec gme_batch_header rowtype
1640: * @rep:scope public
1641: * @rep:lifecycle active
1642: * @rep:displayname cancel_batch

Line 1639: * @param x_batch_header_rec gme_batch_header rowtype

1635: * @param x_message_list List of messages
1636: * @param x_return_status return status
1637: * @param p_org_code Inventory Organization (Plant or Lab)
1638: * @param p_batch_header_rec gme_batch_header rowtype
1639: * @param x_batch_header_rec gme_batch_header rowtype
1640: * @rep:scope public
1641: * @rep:lifecycle active
1642: * @rep:displayname cancel_batch
1643: */

Line 1672: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1668: ,x_message_count OUT NOCOPY NUMBER
1669: ,x_message_list OUT NOCOPY VARCHAR2
1670: ,x_return_status OUT NOCOPY VARCHAR2
1671: ,p_org_code IN VARCHAR2
1672: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1673: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1674:
1675: /*#
1676: * Reopen Batch Procedure

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

1669: ,x_message_list OUT NOCOPY VARCHAR2
1670: ,x_return_status OUT NOCOPY VARCHAR2
1671: ,p_org_code IN VARCHAR2
1672: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1673: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1674:
1675: /*#
1676: * Reopen Batch Procedure
1677: * This procedure reopens a batch and all associated phantom batches.

Line 1687: * @param p_batch_header_rec gme_batch_header rowtype

1683: * @param x_message_count # of messages
1684: * @param x_message_list List of messages
1685: * @param x_return_status return status
1686: * @param p_org_code Inventory Organization (Plant or Lab)
1687: * @param p_batch_header_rec gme_batch_header rowtype
1688: * @param p_reopen_steps reopen steps flag - default is 'F'
1689: * @param x_batch_header_rec gme_batch_header rowtype
1690: * @rep:scope public
1691: * @rep:lifecycle active

Line 1689: * @param x_batch_header_rec gme_batch_header rowtype

1685: * @param x_return_status return status
1686: * @param p_org_code Inventory Organization (Plant or Lab)
1687: * @param p_batch_header_rec gme_batch_header rowtype
1688: * @param p_reopen_steps reopen steps flag - default is 'F'
1689: * @param x_batch_header_rec gme_batch_header rowtype
1690: * @rep:scope public
1691: * @rep:lifecycle active
1692: * @rep:displayname reopen_batch
1693: */

Line 1725: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1721: ,p_commit IN VARCHAR2
1722: ,x_message_count OUT NOCOPY NUMBER
1723: ,x_message_list OUT NOCOPY VARCHAR2
1724: ,x_return_status OUT NOCOPY VARCHAR2
1725: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1726: ,p_org_code IN VARCHAR2
1727: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
1728: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1729:

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

1724: ,x_return_status OUT NOCOPY VARCHAR2
1725: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1726: ,p_org_code IN VARCHAR2
1727: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
1728: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1729:
1730: /*#
1731: * Reopen Step Procedure
1732: * This procedure reopens a step.

Line 1741: * @param p_batch_header_rec gme_batch_header rowtype

1737: * @param x_message_count # of messages
1738: * @param x_message_list List of messages
1739: * @param x_return_status return status
1740: * @param p_org_code Inventory Organization (Plant or Lab)
1741: * @param p_batch_header_rec gme_batch_header rowtype
1742: * @param p_batch_step_rec gme_batch_steps rowtype
1743: * @param x_batch_step_rec gme_batch_steps rowtype
1744: * @rep:scope public
1745: * @rep:lifecycle active

Line 1779: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1775: ,x_message_count OUT NOCOPY NUMBER
1776: ,x_message_list OUT NOCOPY VARCHAR2
1777: ,x_return_status OUT NOCOPY VARCHAR2
1778: ,p_org_code IN VARCHAR2
1779: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1780: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1781: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
1782:
1783: /*#

Line 1793: * @param p_batch_header_rec gme_batch_header rowtype

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

Line 1822: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 1995: * @param p_batch_header_rec gme_batch_header rowtype

1991: * @param p_commit commit flag - default is False
1992: * @param x_message_count # of messages
1993: * @param x_message_list List of messages
1994: * @param x_return_status return status
1995: * @param p_batch_header_rec gme_batch_header rowtype
1996: * @param p_validity_rule_id validity rule id
1997: * @param x_batch_header_rec gme_batch_header rowtype
1998: * @param p_org_code Inventory Organization (Plant or Lab)
1999: * @param p_use_workday_cal Whether workday calendar will be used for batch date calculations

Line 1997: * @param x_batch_header_rec gme_batch_header rowtype

1993: * @param x_message_list List of messages
1994: * @param x_return_status return status
1995: * @param p_batch_header_rec gme_batch_header rowtype
1996: * @param p_validity_rule_id validity rule id
1997: * @param x_batch_header_rec gme_batch_header rowtype
1998: * @param p_org_code Inventory Organization (Plant or Lab)
1999: * @param p_use_workday_cal Whether workday calendar will be used for batch date calculations
2000: * @param p_contiguity_override Whether indicates batch needs to be completed in one contiguous block of time
2001: * @rep:scope public

Line 2036: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2032: ,p_init_msg_list IN VARCHAR2
2033: DEFAULT fnd_api.g_false
2034: ,p_commit IN VARCHAR2
2035: DEFAULT fnd_api.g_false
2036: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2037: ,p_validity_rule_id IN NUMBER
2038: ,p_org_code IN VARCHAR2
2039: ,p_use_workday_cal IN VARCHAR2
2040: DEFAULT fnd_api.g_false

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

2042: DEFAULT fnd_api.g_false
2043: ,x_message_count OUT NOCOPY NUMBER
2044: ,x_message_list OUT NOCOPY VARCHAR2
2045: ,x_return_status OUT NOCOPY VARCHAR2
2046: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
2047:
2048:
2049: /*#
2050: * Terminate Batch Procedure

Line 2062: * @param p_batch_header_rec gme_batch_header rowtype

2058: * @param x_message_list List of messages
2059: * @param x_return_status return status
2060: * @param p_org_code Inventory Organization (Plant or Lab)
2061: * @param p_reason_name Reason Code for termination
2062: * @param p_batch_header_rec gme_batch_header rowtype
2063: * @param x_batch_header_rec gme_batch_header rowtype
2064: * @rep:scope public
2065: * @rep:lifecycle active
2066: * @rep:displayname terminate_batch

Line 2063: * @param x_batch_header_rec gme_batch_header rowtype

2059: * @param x_return_status return status
2060: * @param p_org_code Inventory Organization (Plant or Lab)
2061: * @param p_reason_name Reason Code for termination
2062: * @param p_batch_header_rec gme_batch_header rowtype
2063: * @param x_batch_header_rec gme_batch_header rowtype
2064: * @rep:scope public
2065: * @rep:lifecycle active
2066: * @rep:displayname terminate_batch
2067: */

Line 2099: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2095: ,x_message_list OUT NOCOPY VARCHAR2
2096: ,x_return_status OUT NOCOPY VARCHAR2
2097: ,p_org_code IN VARCHAR2
2098: ,p_reason_name IN VARCHAR2
2099: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2100: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
2101:
2102: /*#
2103: * Convert Detail Reservation Procedure

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

2096: ,x_return_status OUT NOCOPY VARCHAR2
2097: ,p_org_code IN VARCHAR2
2098: ,p_reason_name IN VARCHAR2
2099: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2100: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
2101:
2102: /*#
2103: * Convert Detail Reservation Procedure
2104: * This procedure converted detail level reservation into transaction

Line 2493: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE);

2489: ,x_message_count OUT NOCOPY NUMBER
2490: ,x_message_list OUT NOCOPY VARCHAR2
2491: ,x_return_status OUT NOCOPY VARCHAR2
2492: ,p_org_code IN VARCHAR2
2493: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE);
2494: /*#
2495: * Inserts an activity for a step.
2496: * @param p_api_version Version of the api
2497: * @param p_validation_level validation level

Line 2686: * @param p_batch_header gme_batch_header rowtype

2682: * @param x_message_list List of messages
2683: * @param p_enforce_vldt_check enforce validity check
2684: * @param x_return_status return status
2685: * @param p_org_code organization code
2686: * @param p_batch_header gme_batch_header rowtype
2687: * @param x_batch_header gme_batch_header rowtype
2688: * @param p_batch_size batch size
2689: * @param p_num_batches number of batches
2690: * @param p_validity_rule_id recipe_validity_rule_id Validity rule id

Line 2687: * @param x_batch_header gme_batch_header rowtype

2683: * @param p_enforce_vldt_check enforce validity check
2684: * @param x_return_status return status
2685: * @param p_org_code organization code
2686: * @param p_batch_header gme_batch_header rowtype
2687: * @param x_batch_header gme_batch_header rowtype
2688: * @param p_batch_size batch size
2689: * @param p_num_batches number of batches
2690: * @param p_validity_rule_id recipe_validity_rule_id Validity rule id
2691: * @param p_validity_rule_tab recipe_validity_rule_tab record type

Line 2754: ,p_batch_header IN gme_batch_header%ROWTYPE

2750: ,x_message_list OUT NOCOPY VARCHAR2
2751: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
2752: ,x_return_status OUT NOCOPY VARCHAR2
2753: ,p_org_code IN VARCHAR2 := NULL
2754: ,p_batch_header IN gme_batch_header%ROWTYPE
2755: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
2756: ,p_batch_size IN NUMBER
2757: ,p_num_batches IN NUMBER
2758: ,p_validity_rule_id IN NUMBER

Line 2755: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE

2751: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
2752: ,x_return_status OUT NOCOPY VARCHAR2
2753: ,p_org_code IN VARCHAR2 := NULL
2754: ,p_batch_header IN gme_batch_header%ROWTYPE
2755: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
2756: ,p_batch_size IN NUMBER
2757: ,p_num_batches IN NUMBER
2758: ,p_validity_rule_id IN NUMBER
2759: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab

Line 2763: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE

2759: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab
2760: ,p_leadtime IN NUMBER DEFAULT 0
2761: ,p_batch_offset IN NUMBER DEFAULT 0
2762: ,p_offset_type IN NUMBER DEFAULT 0
2763: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2764: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2765: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2766: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2767: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);

Line 2764: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE

2760: ,p_leadtime IN NUMBER DEFAULT 0
2761: ,p_batch_offset IN NUMBER DEFAULT 0
2762: ,p_offset_type IN NUMBER DEFAULT 0
2763: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2764: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2765: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2766: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2767: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
2768:

Line 2842: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2838: ,p_commit IN VARCHAR2 := fnd_api.g_false
2839: ,x_message_count OUT NOCOPY NUMBER
2840: ,x_message_list OUT NOCOPY VARCHAR2
2841: ,x_return_status OUT NOCOPY VARCHAR2
2842: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2843: ,p_org_code IN VARCHAR2
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

Line 2905: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 2961: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 3016: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3012: ,p_commit IN VARCHAR2 := fnd_api.g_false
3013: ,x_message_count OUT NOCOPY NUMBER
3014: ,x_message_list OUT NOCOPY VARCHAR2
3015: ,x_return_status OUT NOCOPY VARCHAR2
3016: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3017: ,p_org_code IN VARCHAR2
3018: ,p_create_resv_pend_lots IN NUMBER
3019: ,p_continue_lpn_txn IN VARCHAR2 := 'N'
3020: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

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

3016: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3017: ,p_org_code IN VARCHAR2
3018: ,p_create_resv_pend_lots IN NUMBER
3019: ,p_continue_lpn_txn IN VARCHAR2 := 'N'
3020: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
3021:
3022: /*#
3023: * Unrelease a step. Note that identification is required:
3024: * p_batchstep_id or p_batch_id, p_batchstep_no or p_batch_no, p_org_code

Line 3135: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3131: ,p_commit IN VARCHAR2 := fnd_api.g_false
3132: ,x_message_count OUT NOCOPY NUMBER
3133: ,x_message_list OUT NOCOPY VARCHAR2
3134: ,x_return_status OUT NOCOPY VARCHAR2
3135: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3136: ,p_org_code IN VARCHAR2
3137: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3138: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3139: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 3139: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

3135: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3136: ,p_org_code IN VARCHAR2
3137: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3138: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3139: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3140: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3141:
3142: /*#
3143: * Complete a step. Note that identification is required:

Line 3266: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3262: ,p_commit IN VARCHAR2 := fnd_api.g_false
3263: ,x_message_count OUT NOCOPY NUMBER
3264: ,x_message_list OUT NOCOPY VARCHAR2
3265: ,x_return_status OUT NOCOPY VARCHAR2
3266: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3267: ,p_org_code IN VARCHAR2
3268: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3269: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3270: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 3270: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

3266: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3267: ,p_org_code IN VARCHAR2
3268: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3269: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3270: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3271: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3272:
3273: /*#
3274: * Release a step. Note that identification is required: