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

595: ,p_commit IN VARCHAR2 := fnd_api.g_false
596: ,x_message_count OUT NOCOPY NUMBER
597: ,x_message_list OUT NOCOPY VARCHAR2
598: ,x_return_status OUT NOCOPY VARCHAR2
599: ,p_material_detail_rec IN gme_material_details%ROWTYPE
600: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
601: ,p_org_code IN VARCHAR2
602: ,p_batch_no IN VARCHAR2 DEFAULT NULL
603: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

Line 603: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

599: ,p_material_detail_rec IN gme_material_details%ROWTYPE
600: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
601: ,p_org_code IN VARCHAR2
602: ,p_batch_no IN VARCHAR2 DEFAULT NULL
603: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
604: ,p_validity_rule_id IN NUMBER
605: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
606: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
607: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

Line 613: l_material_detail gme_material_details%ROWTYPE;

609: IS
610: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM';
611: phantom_creation_failure EXCEPTION;
612: l_batch_header gme_batch_header%ROWTYPE;
613: l_material_detail gme_material_details%ROWTYPE;
614: BEGIN
615: IF (g_debug <> -1) THEN
616: gme_debug.log_initialize ('CreatePhantom');
617: END IF;

Line 2469: l_material_details_rec gme_material_details%ROWTYPE;

2465: ,x_return_status OUT NOCOPY VARCHAR2)
2466: IS
2467: l_api_name CONSTANT VARCHAR2 (30)
2468: := 'CREATE_LINE_RESERVATIONS';
2469: l_material_details_rec gme_material_details%ROWTYPE;
2470: l_material_details_rec_out gme_material_details%ROWTYPE;
2471: l_batch_header_rec gme_batch_header%ROWTYPE;
2472: BEGIN
2473: IF g_debug <= gme_debug.g_log_procedure THEN

Line 2470: l_material_details_rec_out gme_material_details%ROWTYPE;

2466: IS
2467: l_api_name CONSTANT VARCHAR2 (30)
2468: := 'CREATE_LINE_RESERVATIONS';
2469: l_material_details_rec gme_material_details%ROWTYPE;
2470: l_material_details_rec_out gme_material_details%ROWTYPE;
2471: l_batch_header_rec gme_batch_header%ROWTYPE;
2472: BEGIN
2473: IF g_debug <= gme_debug.g_log_procedure THEN
2474: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 3297: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3293: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3294: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3295: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3296: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3297: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3298: ,p_locator_code IN VARCHAR2
3299: ,p_org_code IN VARCHAR2
3300: ,p_batchstep_no IN NUMBER := NULL
3301: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

Line 3302: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

3298: ,p_locator_code IN VARCHAR2
3299: ,p_org_code IN VARCHAR2
3300: ,p_batchstep_no IN NUMBER := NULL
3301: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
3302: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3303: ,x_message_count OUT NOCOPY NUMBER
3304: ,x_message_list OUT NOCOPY VARCHAR2
3305: ,x_return_status OUT NOCOPY VARCHAR2 )
3306: IS

Line 3319: l_material_detail_rec gme_material_details%ROWTYPE;

3315: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_MATERIAL_LINE';
3316: l_batch_header_rec gme_batch_header%ROWTYPE;
3317: l_return_status VARCHAR2(1);
3318: l_batch_step_rec gme_batch_steps%ROWTYPE;
3319: l_material_detail_rec gme_material_details%ROWTYPE;
3320: p_trans_id NUMBER;
3321: l_locator_id NUMBER;
3322:
3323: x_transacted VARCHAR2(30);

Line 3523: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3519: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3520: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3521: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3522: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3523: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3524: ,p_locator_code IN VARCHAR2
3525: ,p_org_code IN VARCHAR2
3526: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
3527: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

Line 3528: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

3524: ,p_locator_code IN VARCHAR2
3525: ,p_org_code IN VARCHAR2
3526: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
3527: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
3528: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3529: ,x_message_count OUT NOCOPY NUMBER
3530: ,x_message_list OUT NOCOPY VARCHAR2
3531: ,x_return_status OUT NOCOPY VARCHAR2 )
3532: IS

Line 3550: l_material_detail_rec gme_material_details%ROWTYPE;

3546: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_LINE';
3547: l_batch_header_rec gme_batch_header%ROWTYPE;
3548: l_return_status VARCHAR2(1);
3549: l_batch_step_rec gme_batch_steps%ROWTYPE;
3550: l_material_detail_rec gme_material_details%ROWTYPE;
3551: l_stored_material_detail_rec gme_material_details%ROWTYPE;
3552: p_trans_id NUMBER;
3553: l_subinventory VARCHAR2(30);
3554: l_locator_id NUMBER;

Line 3551: l_stored_material_detail_rec gme_material_details%ROWTYPE;

3547: l_batch_header_rec gme_batch_header%ROWTYPE;
3548: l_return_status VARCHAR2(1);
3549: l_batch_step_rec gme_batch_steps%ROWTYPE;
3550: l_material_detail_rec gme_material_details%ROWTYPE;
3551: l_stored_material_detail_rec gme_material_details%ROWTYPE;
3552: p_trans_id NUMBER;
3553: l_subinventory VARCHAR2(30);
3554: l_locator_id NUMBER;
3555: l_batchstep_id NUMBER;

Line 3771: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3767: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3768: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3769: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3770: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3771: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3772: ,p_org_code IN VARCHAR2
3773: ,x_message_count OUT NOCOPY NUMBER
3774: ,x_message_list OUT NOCOPY VARCHAR2
3775: ,x_return_status OUT NOCOPY VARCHAR2 )

Line 3786: l_material_detail_rec gme_material_details%ROWTYPE;

3782: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_LINE';
3783: l_batch_header_rec gme_batch_header%ROWTYPE;
3784: l_return_status VARCHAR2(1);
3785: l_batch_step_rec gme_batch_steps%ROWTYPE;
3786: l_material_detail_rec gme_material_details%ROWTYPE;
3787:
3788: l_batchstep_id NUMBER;
3789: x_transacted VARCHAR2(30);
3790: x_batch_header_rec gme_batch_header%ROWTYPE;

Line 4735: ,p_material_detail_rec IN gme_material_details%ROWTYPE

4731: ,x_message_list OUT NOCOPY VARCHAR2
4732: ,x_return_status OUT NOCOPY VARCHAR2
4733: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4734: ,p_org_code IN VARCHAR2
4735: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4736: ,p_qty IN NUMBER
4737: ,p_qty_type IN NUMBER
4738: ,p_trans_date IN DATE
4739: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

Line 4744: l_material_detail_rec gme_material_details%ROWTYPE;

4740: ,p_adjust_cmplt IN VARCHAR2 := fnd_api.g_true
4741: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
4742: IS
4743: l_api_name CONSTANT VARCHAR2 (30) := 'INCREMENTAL_BACKFLUSH';
4744: l_material_detail_rec gme_material_details%ROWTYPE;
4745: l_batch_header_rec gme_batch_header%ROWTYPE;
4746: l_exception_material_tbl gme_common_pvt.exceptions_tab;
4747:
4748: error_incr_backflush EXCEPTION;

Line 4930: l_mat_dtl_rec gme_material_details%ROWTYPE;

4926:
4927: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
4928: l_mmti_rec mtl_transactions_interface%ROWTYPE;
4929: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
4930: l_mat_dtl_rec gme_material_details%ROWTYPE;
4931: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
4932: l_batch_header_rec gme_batch_header%ROWTYPE;
4933: l_item_rec mtl_system_items_b%ROWTYPE;
4934: l_lot_rec mtl_lot_numbers%ROWTYPE;

Line 4931: l_mat_dtl_rec_out gme_material_details%ROWTYPE;

4927: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
4928: l_mmti_rec mtl_transactions_interface%ROWTYPE;
4929: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
4930: l_mat_dtl_rec gme_material_details%ROWTYPE;
4931: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
4932: l_batch_header_rec gme_batch_header%ROWTYPE;
4933: l_item_rec mtl_system_items_b%ROWTYPE;
4934: l_lot_rec mtl_lot_numbers%ROWTYPE;
4935: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;

Line 5298: l_mat_dtl_rec gme_material_details%ROWTYPE;

5294: l_mmt_rec mtl_material_transactions%ROWTYPE;
5295: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
5296: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5297: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5298: l_mat_dtl_rec gme_material_details%ROWTYPE;
5299: l_item_rec mtl_system_items_b%ROWTYPE;
5300: l_msg_count NUMBER;
5301: l_msg_data VARCHAR2 (2000);
5302: l_msg_index NUMBER (5);

Line 5371: IF NOT gme_material_details_dbl.fetch_row

5367:
5368: gme_common_pvt.set_timestamp;
5369: l_mat_dtl_rec.material_detail_id := l_mmti_rec.trx_source_line_id;
5370:
5371: IF NOT gme_material_details_dbl.fetch_row
5372: (p_material_detail => l_mat_dtl_rec
5373: ,x_material_detail => l_mat_dtl_rec) THEN
5374: RAISE fnd_api.g_exc_error;
5375: END IF;

Line 6354: l_material_details_rec gme_material_details%ROWTYPE;

6350: ,p_reservation_rec IN mtl_reservations%ROWTYPE
6351: ,p_qty_convert IN NUMBER := NULL)
6352: IS
6353: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_DTL_RESERVATION';
6354: l_material_details_rec gme_material_details%ROWTYPE;
6355: l_reservation_rec mtl_reservations%ROWTYPE;
6356: l_valid_status VARCHAR2(1);
6357:
6358: detail_reservation_error EXCEPTION;

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

6426: RAISE fnd_api.g_exc_error;
6427: END IF;
6428:
6429: gme_common_pvt.set_timestamp;
6430: /* Verify that we have a valid row in gme_material_details */
6431: l_material_details_rec.material_detail_id :=
6432: l_reservation_rec.demand_source_line_id;
6433:
6434: IF NOT (gme_material_details_dbl.fetch_row (l_material_details_rec

Line 6434: IF NOT (gme_material_details_dbl.fetch_row (l_material_details_rec

6430: /* Verify that we have a valid row in gme_material_details */
6431: l_material_details_rec.material_detail_id :=
6432: l_reservation_rec.demand_source_line_id;
6433:
6434: IF NOT (gme_material_details_dbl.fetch_row (l_material_details_rec
6435: ,l_material_details_rec) ) THEN
6436: RAISE fnd_api.g_exc_error;
6437: END IF;
6438:

Line 7620: l_material_details_rec gme_material_details%ROWTYPE;

7616: ,p_batch_no IN VARCHAR2
7617: ,p_line_no IN NUMBER)
7618: IS
7619: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
7620: l_material_details_rec gme_material_details%ROWTYPE;
7621: l_material_details_rec_out gme_material_details%ROWTYPE;
7622: l_reservation_rec mtl_reservations%ROWTYPE;
7623: l_batch_header_rec gme_batch_header%ROWTYPE;
7624: l_valid_status VARCHAR2(1);

Line 7621: l_material_details_rec_out gme_material_details%ROWTYPE;

7617: ,p_line_no IN NUMBER)
7618: IS
7619: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
7620: l_material_details_rec gme_material_details%ROWTYPE;
7621: l_material_details_rec_out gme_material_details%ROWTYPE;
7622: l_reservation_rec mtl_reservations%ROWTYPE;
7623: l_batch_header_rec gme_batch_header%ROWTYPE;
7624: l_valid_status VARCHAR2(1);
7625:

Line 8609: ,p_material_detail_rec IN gme_material_details%ROWTYPE

8605: ,p_org_code IN VARCHAR2
8606: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
8607: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
8608: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
8609: ,p_material_detail_rec IN gme_material_details%ROWTYPE
8610: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
8611: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
8612: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
8613: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

Line 8618: l_material_detail_rec gme_material_details%ROWTYPE;

8614: IS
8615: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
8616:
8617: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8618: l_material_detail_rec gme_material_details%ROWTYPE;
8619: l_in_material_detail_rec gme_material_details%ROWTYPE;
8620: l_batch_header_rec gme_batch_header%ROWTYPE;
8621: l_batch_id NUMBER;
8622: l_matl_dtl_id NUMBER;

Line 8619: l_in_material_detail_rec gme_material_details%ROWTYPE;

8615: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
8616:
8617: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8618: l_material_detail_rec gme_material_details%ROWTYPE;
8619: l_in_material_detail_rec gme_material_details%ROWTYPE;
8620: l_batch_header_rec gme_batch_header%ROWTYPE;
8621: l_batch_id NUMBER;
8622: l_matl_dtl_id NUMBER;
8623:

Line 8809: ,p_material_detail_rec IN gme_material_details%ROWTYPE

8805: ,x_message_list OUT NOCOPY VARCHAR2
8806: ,x_return_status OUT NOCOPY VARCHAR2
8807: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
8808: ,p_org_code IN VARCHAR2
8809: ,p_material_detail_rec IN gme_material_details%ROWTYPE
8810: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
8811: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
8812: IS
8813: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';

Line 8817: l_in_material_detail_rec gme_material_details%ROWTYPE;

8813: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
8814:
8815: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8816: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8817: l_in_material_detail_rec gme_material_details%ROWTYPE;
8818: l_in_batch_header_rec gme_batch_header%ROWTYPE;
8819: l_material_detail_rec gme_material_details%ROWTYPE;
8820: l_batch_header_rec gme_batch_header%ROWTYPE;
8821: l_batch_id NUMBER;

Line 8819: l_material_detail_rec gme_material_details%ROWTYPE;

8815: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8816: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8817: l_in_material_detail_rec gme_material_details%ROWTYPE;
8818: l_in_batch_header_rec gme_batch_header%ROWTYPE;
8819: l_material_detail_rec gme_material_details%ROWTYPE;
8820: l_batch_header_rec gme_batch_header%ROWTYPE;
8821: l_batch_id NUMBER;
8822: l_matl_dtl_id NUMBER;
8823:

Line 9047: ,p_material_detail_rec IN gme_material_details%ROWTYPE

9043: ,x_message_list OUT NOCOPY VARCHAR2
9044: ,x_return_status OUT NOCOPY VARCHAR2
9045: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9046: ,p_org_code IN VARCHAR2
9047: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9048: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
9049: IS
9050: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9051:

Line 9054: l_in_material_detail_rec gme_material_details%ROWTYPE;

9050: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9051:
9052: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9053: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9054: l_in_material_detail_rec gme_material_details%ROWTYPE;
9055: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9056: l_material_detail_rec gme_material_details%ROWTYPE;
9057: l_batch_header_rec gme_batch_header%ROWTYPE;
9058: l_batch_id NUMBER;

Line 9056: l_material_detail_rec gme_material_details%ROWTYPE;

9052: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9053: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9054: l_in_material_detail_rec gme_material_details%ROWTYPE;
9055: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9056: l_material_detail_rec gme_material_details%ROWTYPE;
9057: l_batch_header_rec gme_batch_header%ROWTYPE;
9058: l_batch_id NUMBER;
9059: l_matl_dtl_id NUMBER;
9060: