776: * @param x_return_status return status
777: * @param p_org_code Inventory Organization (Plant or Lab)
778: * @param p_batch_no batch number
779: * @param p_batch_type NUMBER (0,10) Batch, FPO
780: * @param p_batch_step_rec gme_batch_steps rowtype
781: * @param p_reschedule_preceding reschedule preceding steps flag - default is 'T'
782: * @param p_reschedule_succeeding reschedule succeeding steps flag - default is 'T'
783: * @param p_use_workday_cal use shop calendar flag
784: * @param p_contiguity_override contiguity override
781: * @param p_reschedule_preceding reschedule preceding steps flag - default is 'T'
782: * @param p_reschedule_succeeding reschedule succeeding steps flag - default is 'T'
783: * @param p_use_workday_cal use shop calendar flag
784: * @param p_contiguity_override contiguity override
785: * @param x_batch_step_rec gme_batch_steps rowtype
786: * @rep:scope public
787: * @rep:lifecycle active
788: * @rep:displayname reschedule_step
789: */
818: ,p_validation_level IN NUMBER
819: := gme_common_pvt.g_max_errors
820: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
821: ,p_commit IN VARCHAR2 := fnd_api.g_false
822: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
823: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
824: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
825: ,p_org_code IN VARCHAR2
826: ,p_batch_no IN VARCHAR2
829: ,p_reschedule_succeeding IN VARCHAR2 := fnd_api.g_true
830: ,x_message_count OUT NOCOPY NUMBER
831: ,x_message_list OUT NOCOPY VARCHAR2
832: ,x_return_status OUT NOCOPY VARCHAR2
833: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
834:
835: /*#
836: * Create Batch Reservations Procedure
837: * This procedure Creaates high level reservations for all the ingredients
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
1149: * @rep:displayname insert_step
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
1149: * @rep:displayname insert_step
1150: */
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
1192: ,x_return_status OUT NOCOPY VARCHAR2);
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
1192: ,x_return_status OUT NOCOPY VARCHAR2);
1193:
1374: * @param x_message_list List of messages
1375: * @param x_return_status return status
1376: * @param p_org_code Inventory Organization (Plant or Lab)
1377: * @param p_batch_no Batch Number
1378: * @param p_batch_step_rec gme_batch_steps rowtype
1379: * @rep:scope public
1380: * @rep:lifecycle active
1381: * @rep:displayname delete_step
1382: */
1406: ,p_batch_no IN VARCHAR2
1407: ,x_message_count OUT NOCOPY NUMBER
1408: ,x_message_list OUT NOCOPY VARCHAR2
1409: ,x_return_status OUT NOCOPY VARCHAR2
1410: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE);
1411: /*#
1412: * Revert Batch Procedure
1413: * This procedure closes batch.
1414: * @param p_api_version Version of the api
1417: * @param p_commit commit flag - default is False
1418: * @param x_message_count # of messages
1419: * @param x_message_list List of messages
1420: * @param x_return_status return status
1421: * @param p_batch_header_rec gme_batch_steps rowtype
1422: * @param p_org_code Inventory Organization (Plant or Lab)
1423: * @param x_batch_header_rec gme_batch_steps rowtype
1424: * @rep:scope public
1425: * @rep:lifecycle active
1419: * @param x_message_list List of messages
1420: * @param x_return_status return status
1421: * @param p_batch_header_rec gme_batch_steps rowtype
1422: * @param p_org_code Inventory Organization (Plant or Lab)
1423: * @param x_batch_header_rec gme_batch_steps rowtype
1424: * @rep:scope public
1425: * @rep:lifecycle active
1426: * @rep:displayname revert_batch
1427: */
1468: * @param x_message_list List of messages
1469: * @param x_return_status return status
1470: * @param p_org_code Inventory Organization (Plant or Lab)
1471: * @param p_batch_no Batch Number
1472: * @param p_batch_step_rec gme_batch_steps rowtype
1473: * @param x_batch_step_rec gme_batch_steps rowtype
1474: * @rep:scope public
1475: * @rep:lifecycle active
1476: * @rep:displayname revert_step
1469: * @param x_return_status return status
1470: * @param p_org_code Inventory Organization (Plant or Lab)
1471: * @param p_batch_no Batch Number
1472: * @param p_batch_step_rec gme_batch_steps rowtype
1473: * @param x_batch_step_rec gme_batch_steps rowtype
1474: * @rep:scope public
1475: * @rep:lifecycle active
1476: * @rep:displayname revert_step
1477: */
1504: ,x_message_list OUT NOCOPY VARCHAR2
1505: ,x_return_status OUT NOCOPY VARCHAR2
1506: ,p_org_code IN VARCHAR2
1507: ,p_batch_no IN VARCHAR2
1508: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1509: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
1510:
1511:
1512: /*#
1505: ,x_return_status OUT NOCOPY VARCHAR2
1506: ,p_org_code IN VARCHAR2
1507: ,p_batch_no IN VARCHAR2
1508: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1509: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
1510:
1511:
1512: /*#
1513: * Close Batch Procedure
1518: * @param p_commit commit flag - default is False
1519: * @param x_message_count # of messages
1520: * @param x_message_list List of messages
1521: * @param x_return_status return status
1522: * @param p_batch_header_rec gme_batch_steps rowtype
1523: * @param p_org_code Inventory Organization (Plant or Lab)
1524: * @param x_batch_header_rec gme_batch_steps rowtype
1525: * @rep:scope public
1526: * @rep:lifecycle active
1520: * @param x_message_list List of messages
1521: * @param x_return_status return status
1522: * @param p_batch_header_rec gme_batch_steps rowtype
1523: * @param p_org_code Inventory Organization (Plant or Lab)
1524: * @param x_batch_header_rec gme_batch_steps rowtype
1525: * @rep:scope public
1526: * @rep:lifecycle active
1527: * @rep:displayname close_batch
1528: */
1569: * @param x_message_list List of messages
1570: * @param x_return_status return status
1571: * @param p_org_code Inventory Organization (Plant or Lab)
1572: * @param p_batch_no Batch Number
1573: * @param p_batch_step_rec gme_batch_steps rowtype
1574: * @param p_delete_pending delete pending flag - default is 'F'
1575: * @param x_batch_step_rec gme_batch_steps rowtype
1576: * @rep:scope public
1577: * @rep:lifecycle active
1571: * @param p_org_code Inventory Organization (Plant or Lab)
1572: * @param p_batch_no Batch Number
1573: * @param p_batch_step_rec gme_batch_steps rowtype
1574: * @param p_delete_pending delete pending flag - default is 'F'
1575: * @param x_batch_step_rec gme_batch_steps rowtype
1576: * @rep:scope public
1577: * @rep:lifecycle active
1578: * @rep:displayname close_step
1579: */
1610: ,p_commit IN VARCHAR2
1611: ,x_message_count OUT NOCOPY NUMBER
1612: ,x_message_list OUT NOCOPY VARCHAR2
1613: ,x_return_status OUT NOCOPY VARCHAR2
1614: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1615: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
1616: ,p_org_code IN VARCHAR2
1617: ,p_batch_no IN VARCHAR2
1618: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
1614: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1615: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
1616: ,p_org_code IN VARCHAR2
1617: ,p_batch_no IN VARCHAR2
1618: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
1619:
1620: /*#
1621: * Cancel Batch Procedure
1622: * This procedure cancels a batch and all associated phantom batches.
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
1740: * @rep:displayname reopen_step
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
1740: * @rep:displayname reopen_step
1741: */
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: /*#
1778: * Incremental Backflush Procedure
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: /*#
1778: * Incremental Backflush Procedure
1779: * This particular procedure is used to delete a parameter for a given resource
3043: ,p_commit IN VARCHAR2 := fnd_api.g_false
3044: ,x_message_count OUT NOCOPY NUMBER
3045: ,x_message_list OUT NOCOPY VARCHAR2
3046: ,x_return_status OUT NOCOPY VARCHAR2
3047: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3048: ,p_batch_no IN VARCHAR2
3049: ,p_org_code IN VARCHAR2
3050: ,p_create_resv_pend_lots IN NUMBER
3051: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
3047: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3048: ,p_batch_no IN VARCHAR2
3049: ,p_org_code IN VARCHAR2
3050: ,p_create_resv_pend_lots IN NUMBER
3051: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
3052:
3053: /*#
3054: * Complete a batch. Note that identification is required:
3055: * batch_id or batch_no and p_org_code (batch_type is assumed to be batch)
3171: ,p_commit IN VARCHAR2 := fnd_api.g_false
3172: ,x_message_count OUT NOCOPY NUMBER
3173: ,x_message_list OUT NOCOPY VARCHAR2
3174: ,x_return_status OUT NOCOPY VARCHAR2
3175: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3176: ,p_batch_no IN VARCHAR2
3177: ,p_org_code IN VARCHAR2
3178: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3179: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
3177: ,p_org_code IN VARCHAR2
3178: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3179: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
3180: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3181: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3182: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3183:
3184: /*#
3185: * Release a batch. Note that identification is required:
3297: ,p_commit IN VARCHAR2 := fnd_api.g_false
3298: ,x_message_count OUT NOCOPY NUMBER
3299: ,x_message_list OUT NOCOPY VARCHAR2
3300: ,x_return_status OUT NOCOPY VARCHAR2
3301: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3302: ,p_batch_no IN VARCHAR2
3303: ,p_org_code IN VARCHAR2
3304: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3305: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3302: ,p_batch_no IN VARCHAR2
3303: ,p_org_code IN VARCHAR2
3304: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3305: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3306: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3307: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3308:
3309: /*#
3310: * Process a Group.