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 639: ,p_material_detail_rec IN gme_material_details%ROWTYPE

635: ,p_commit IN VARCHAR2 := fnd_api.g_false
636: ,x_message_count OUT NOCOPY NUMBER
637: ,x_message_list OUT NOCOPY VARCHAR2
638: ,x_return_status OUT NOCOPY VARCHAR2
639: ,p_material_detail_rec IN gme_material_details%ROWTYPE
640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
641: ,p_org_code IN VARCHAR2
642: ,p_batch_no IN VARCHAR2 DEFAULT NULL
643: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

Line 643: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

639: ,p_material_detail_rec IN gme_material_details%ROWTYPE
640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
641: ,p_org_code IN VARCHAR2
642: ,p_batch_no IN VARCHAR2 DEFAULT NULL
643: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
644: ,p_validity_rule_id IN NUMBER
645: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
646: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
647: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

Line 653: l_material_detail gme_material_details%ROWTYPE;

649: IS
650: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM';
651: phantom_creation_failure EXCEPTION;
652: l_batch_header gme_batch_header%ROWTYPE;
653: l_material_detail gme_material_details%ROWTYPE;
654: BEGIN
655: IF (g_debug <> -1) THEN
656: gme_debug.log_initialize ('CreatePhantom');
657: END IF;

Line 2538: l_material_details_rec gme_material_details%ROWTYPE;

2534: ,x_return_status OUT NOCOPY VARCHAR2)
2535: IS
2536: l_api_name CONSTANT VARCHAR2 (30)
2537: := 'CREATE_LINE_RESERVATIONS';
2538: l_material_details_rec gme_material_details%ROWTYPE;
2539: l_material_details_rec_out gme_material_details%ROWTYPE;
2540: l_batch_header_rec gme_batch_header%ROWTYPE;
2541: BEGIN
2542: IF g_debug <= gme_debug.g_log_procedure THEN

Line 2539: l_material_details_rec_out gme_material_details%ROWTYPE;

2535: IS
2536: l_api_name CONSTANT VARCHAR2 (30)
2537: := 'CREATE_LINE_RESERVATIONS';
2538: l_material_details_rec gme_material_details%ROWTYPE;
2539: l_material_details_rec_out gme_material_details%ROWTYPE;
2540: l_batch_header_rec gme_batch_header%ROWTYPE;
2541: BEGIN
2542: IF g_debug <= gme_debug.g_log_procedure THEN
2543: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 3382: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3378: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3379: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3380: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3381: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3382: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3383: ,p_locator_code IN VARCHAR2
3384: ,p_org_code IN VARCHAR2
3385: ,p_batchstep_no IN NUMBER := NULL
3386: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

Line 3387: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

3383: ,p_locator_code IN VARCHAR2
3384: ,p_org_code IN VARCHAR2
3385: ,p_batchstep_no IN NUMBER := NULL
3386: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
3387: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3388: ,x_message_count OUT NOCOPY NUMBER
3389: ,x_message_list OUT NOCOPY VARCHAR2
3390: ,x_return_status OUT NOCOPY VARCHAR2 )
3391: IS

Line 3404: l_material_detail_rec gme_material_details%ROWTYPE;

3400: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_MATERIAL_LINE';
3401: l_batch_header_rec gme_batch_header%ROWTYPE;
3402: l_return_status VARCHAR2(1);
3403: l_batch_step_rec gme_batch_steps%ROWTYPE;
3404: l_material_detail_rec gme_material_details%ROWTYPE;
3405: p_trans_id NUMBER;
3406: l_locator_id NUMBER;
3407:
3408: x_transacted VARCHAR2(30);

Line 3610: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3606: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3607: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3608: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3609: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3610: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3611: ,p_locator_code IN VARCHAR2
3612: ,p_org_code IN VARCHAR2
3613: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
3614: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

Line 3615: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

3611: ,p_locator_code IN VARCHAR2
3612: ,p_org_code IN VARCHAR2
3613: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
3614: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
3615: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3616: ,x_message_count OUT NOCOPY NUMBER
3617: ,x_message_list OUT NOCOPY VARCHAR2
3618: ,x_return_status OUT NOCOPY VARCHAR2 )
3619: IS

Line 3637: l_material_detail_rec gme_material_details%ROWTYPE;

3633: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_LINE';
3634: l_batch_header_rec gme_batch_header%ROWTYPE;
3635: l_return_status VARCHAR2(1);
3636: l_batch_step_rec gme_batch_steps%ROWTYPE;
3637: l_material_detail_rec gme_material_details%ROWTYPE;
3638: l_stored_material_detail_rec gme_material_details%ROWTYPE;
3639: p_trans_id NUMBER;
3640: l_subinventory VARCHAR2(30);
3641: l_locator_id NUMBER;

Line 3638: l_stored_material_detail_rec gme_material_details%ROWTYPE;

3634: l_batch_header_rec gme_batch_header%ROWTYPE;
3635: l_return_status VARCHAR2(1);
3636: l_batch_step_rec gme_batch_steps%ROWTYPE;
3637: l_material_detail_rec gme_material_details%ROWTYPE;
3638: l_stored_material_detail_rec gme_material_details%ROWTYPE;
3639: p_trans_id NUMBER;
3640: l_subinventory VARCHAR2(30);
3641: l_locator_id NUMBER;
3642: l_batchstep_id NUMBER;

Line 3858: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3854: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3855: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3856: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3857: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3858: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3859: ,p_org_code IN VARCHAR2
3860: ,x_message_count OUT NOCOPY NUMBER
3861: ,x_message_list OUT NOCOPY VARCHAR2
3862: ,x_return_status OUT NOCOPY VARCHAR2 )

Line 3873: l_material_detail_rec gme_material_details%ROWTYPE;

3869: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_LINE';
3870: l_batch_header_rec gme_batch_header%ROWTYPE;
3871: l_return_status VARCHAR2(1);
3872: l_batch_step_rec gme_batch_steps%ROWTYPE;
3873: l_material_detail_rec gme_material_details%ROWTYPE;
3874:
3875: l_batchstep_id NUMBER;
3876: x_transacted VARCHAR2(30);
3877: x_batch_header_rec gme_batch_header%ROWTYPE;

Line 4030: FROM mtl_material_transactions mmt, gme_material_details mtl

4026: x_lpn_txns NUMBER;
4027: l_continue_lpn_txn VARCHAR2(1);
4028: CURSOR get_lpn_txns(p_batch_id IN NUMBER) IS
4029: SELECT COUNT(1)
4030: FROM mtl_material_transactions mmt, gme_material_details mtl
4031: WHERE NVL(transfer_lpn_id,0) > 0
4032: AND TRANSACTION_SOURCE_ID = p_batch_id
4033: AND transaction_action_id = 31
4034: AND transaction_type_id IN (44, 1002)

Line 4872: ,p_material_detail_rec IN gme_material_details%ROWTYPE

4868: ,x_message_list OUT NOCOPY VARCHAR2
4869: ,x_return_status OUT NOCOPY VARCHAR2
4870: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4871: ,p_org_code IN VARCHAR2
4872: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4873: ,p_qty IN NUMBER
4874: ,p_qty_type IN NUMBER
4875: ,p_trans_date IN DATE
4876: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

Line 4881: l_material_detail_rec gme_material_details%ROWTYPE;

4877: ,p_adjust_cmplt IN VARCHAR2 := fnd_api.g_true
4878: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
4879: IS
4880: l_api_name CONSTANT VARCHAR2 (30) := 'INCREMENTAL_BACKFLUSH';
4881: l_material_detail_rec gme_material_details%ROWTYPE;
4882: l_batch_header_rec gme_batch_header%ROWTYPE;
4883: l_exception_material_tbl gme_common_pvt.exceptions_tab;
4884:
4885: error_incr_backflush EXCEPTION;

Line 5068: l_mat_dtl_rec gme_material_details%ROWTYPE;

5064:
5065: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
5066: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5067: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5068: l_mat_dtl_rec gme_material_details%ROWTYPE;
5069: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
5070: l_batch_header_rec gme_batch_header%ROWTYPE;
5071: l_item_rec mtl_system_items_b%ROWTYPE;
5072: l_lot_rec mtl_lot_numbers%ROWTYPE;

Line 5069: l_mat_dtl_rec_out gme_material_details%ROWTYPE;

5065: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
5066: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5067: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5068: l_mat_dtl_rec gme_material_details%ROWTYPE;
5069: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
5070: l_batch_header_rec gme_batch_header%ROWTYPE;
5071: l_item_rec mtl_system_items_b%ROWTYPE;
5072: l_lot_rec mtl_lot_numbers%ROWTYPE;
5073: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;

Line 5629: l_mat_dtl_rec gme_material_details%ROWTYPE;

5625: l_mmt_rec mtl_material_transactions%ROWTYPE;
5626: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
5627: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5628: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5629: l_mat_dtl_rec gme_material_details%ROWTYPE;
5630: l_item_rec mtl_system_items_b%ROWTYPE;
5631: l_msg_count NUMBER;
5632: l_msg_data VARCHAR2 (2000);
5633: l_msg_index NUMBER (5);

Line 5702: IF NOT gme_material_details_dbl.fetch_row

5698:
5699: gme_common_pvt.set_timestamp;
5700: l_mat_dtl_rec.material_detail_id := l_mmti_rec.trx_source_line_id;
5701:
5702: IF NOT gme_material_details_dbl.fetch_row
5703: (p_material_detail => l_mat_dtl_rec
5704: ,x_material_detail => l_mat_dtl_rec) THEN
5705: RAISE fnd_api.g_exc_error;
5706: END IF;

Line 6770: l_material_details_rec gme_material_details%ROWTYPE;

6766: ,p_trans_date IN DATE DEFAULT NULL -- Bug 13532998
6767: ,p_qty_convert IN NUMBER := NULL)
6768: IS
6769: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_DTL_RESERVATION';
6770: l_material_details_rec gme_material_details%ROWTYPE;
6771: l_reservation_rec mtl_reservations%ROWTYPE;
6772: l_valid_status VARCHAR2(1);
6773:
6774: l_batch_header_rec gme_batch_header%ROWTYPE; -- Bug 13532998

Line 6864: /* Verify that we have a valid row in gme_material_details */

6860: RAISE fnd_api.g_exc_error;
6861: END IF;
6862:
6863: gme_common_pvt.set_timestamp;
6864: /* Verify that we have a valid row in gme_material_details */
6865: l_material_details_rec.material_detail_id :=
6866: l_reservation_rec.demand_source_line_id;
6867:
6868: IF NOT (gme_material_details_dbl.fetch_row (l_material_details_rec

Line 6868: IF NOT (gme_material_details_dbl.fetch_row (l_material_details_rec

6864: /* Verify that we have a valid row in gme_material_details */
6865: l_material_details_rec.material_detail_id :=
6866: l_reservation_rec.demand_source_line_id;
6867:
6868: IF NOT (gme_material_details_dbl.fetch_row (l_material_details_rec
6869: ,l_material_details_rec) ) THEN
6870: RAISE fnd_api.g_exc_error;
6871: END IF;
6872:

Line 8099: l_material_details_rec gme_material_details%ROWTYPE;

8095: ,p_batch_no IN VARCHAR2
8096: ,p_line_no IN NUMBER)
8097: IS
8098: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
8099: l_material_details_rec gme_material_details%ROWTYPE;
8100: l_material_details_rec_out gme_material_details%ROWTYPE;
8101: l_reservation_rec mtl_reservations%ROWTYPE;
8102: l_batch_header_rec gme_batch_header%ROWTYPE;
8103: l_valid_status VARCHAR2(1);

Line 8100: l_material_details_rec_out gme_material_details%ROWTYPE;

8096: ,p_line_no IN NUMBER)
8097: IS
8098: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
8099: l_material_details_rec gme_material_details%ROWTYPE;
8100: l_material_details_rec_out gme_material_details%ROWTYPE;
8101: l_reservation_rec mtl_reservations%ROWTYPE;
8102: l_batch_header_rec gme_batch_header%ROWTYPE;
8103: l_valid_status VARCHAR2(1);
8104:

Line 9134: ,p_material_detail_rec IN gme_material_details%ROWTYPE

9130: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
9131: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
9132: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
9133: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
9134: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9135: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
9136: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
9137: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
9138: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

Line 9143: l_material_detail_rec gme_material_details%ROWTYPE;

9139: IS
9140: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
9141:
9142: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9143: l_material_detail_rec gme_material_details%ROWTYPE;
9144: l_in_material_detail_rec gme_material_details%ROWTYPE;
9145: l_batch_header_rec gme_batch_header%ROWTYPE;
9146: l_batch_id NUMBER;
9147: l_matl_dtl_id NUMBER;

Line 9144: l_in_material_detail_rec gme_material_details%ROWTYPE;

9140: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
9141:
9142: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9143: l_material_detail_rec gme_material_details%ROWTYPE;
9144: l_in_material_detail_rec gme_material_details%ROWTYPE;
9145: l_batch_header_rec gme_batch_header%ROWTYPE;
9146: l_batch_id NUMBER;
9147: l_matl_dtl_id NUMBER;
9148:

Line 9339: ,p_material_detail_rec IN gme_material_details%ROWTYPE

9335: ,x_message_list OUT NOCOPY VARCHAR2
9336: ,x_return_status OUT NOCOPY VARCHAR2
9337: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9338: ,p_org_code IN VARCHAR2
9339: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9340: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
9341: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
9342: IS
9343: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';

Line 9347: l_in_material_detail_rec gme_material_details%ROWTYPE;

9343: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
9344:
9345: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9346: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9347: l_in_material_detail_rec gme_material_details%ROWTYPE;
9348: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9349: l_material_detail_rec gme_material_details%ROWTYPE;
9350: l_batch_header_rec gme_batch_header%ROWTYPE;
9351: l_batch_id NUMBER;

Line 9349: l_material_detail_rec gme_material_details%ROWTYPE;

9345: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9346: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9347: l_in_material_detail_rec gme_material_details%ROWTYPE;
9348: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9349: l_material_detail_rec gme_material_details%ROWTYPE;
9350: l_batch_header_rec gme_batch_header%ROWTYPE;
9351: l_batch_id NUMBER;
9352: l_matl_dtl_id NUMBER;
9353:

Line 9577: ,p_material_detail_rec IN gme_material_details%ROWTYPE

9573: ,x_message_list OUT NOCOPY VARCHAR2
9574: ,x_return_status OUT NOCOPY VARCHAR2
9575: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9576: ,p_org_code IN VARCHAR2
9577: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9578: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
9579: IS
9580: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9581:

Line 9584: l_in_material_detail_rec gme_material_details%ROWTYPE;

9580: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9581:
9582: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9583: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9584: l_in_material_detail_rec gme_material_details%ROWTYPE;
9585: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9586: l_material_detail_rec gme_material_details%ROWTYPE;
9587: l_batch_header_rec gme_batch_header%ROWTYPE;
9588: l_batch_id NUMBER;

Line 9586: l_material_detail_rec gme_material_details%ROWTYPE;

9582: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9583: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9584: l_in_material_detail_rec gme_material_details%ROWTYPE;
9585: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9586: l_material_detail_rec gme_material_details%ROWTYPE;
9587: l_batch_header_rec gme_batch_header%ROWTYPE;
9588: l_batch_id NUMBER;
9589: l_matl_dtl_id NUMBER;
9590:

Line 9835: FROM mtl_material_transactions mmt, gme_material_details mtl

9831: x_lpn_txns NUMBER;
9832: l_continue_lpn_txn VARCHAR2(1);
9833: CURSOR get_lpn_txns(p_batch_id IN NUMBER) IS
9834: SELECT COUNT(1)
9835: FROM mtl_material_transactions mmt, gme_material_details mtl
9836: WHERE NVL(transfer_lpn_id,0) > 0
9837: AND TRANSACTION_SOURCE_ID = p_batch_id
9838: AND transaction_action_id = 31
9839: AND transaction_type_id IN (44, 1002)