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_RESOURCE_TXNS

Line 53: FROM gme_resource_txns_gtmp

49:
50: CURSOR header_cursor
51: IS
52: SELECT DISTINCT doc_id batch_id
53: FROM gme_resource_txns_gtmp
54: ORDER BY batch_id;
55: BEGIN
56: IF g_debug <= gme_debug.g_log_procedure THEN
57: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1031: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1027: ,p_activity IN VARCHAR2 := NULL
1028: ,p_resource IN VARCHAR2 := NULL
1029: ,p_instance_no IN NUMBER := NULL
1030: ,p_reason_name IN VARCHAR2 := NULL
1031: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1032: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1033: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1034: ,x_message_count OUT NOCOPY NUMBER
1035: ,x_message_list OUT NOCOPY VARCHAR2

Line 1033: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1029: ,p_instance_no IN NUMBER := NULL
1030: ,p_reason_name IN VARCHAR2 := NULL
1031: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1032: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1033: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1034: ,x_message_count OUT NOCOPY NUMBER
1035: ,x_message_list OUT NOCOPY VARCHAR2
1036: ,x_return_status OUT NOCOPY VARCHAR2)
1037: IS

Line 1047: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1043: l_inv_trans_count NUMBER;
1044: l_rsrc_trans_count NUMBER;
1045: l_return_status VARCHAR2 (2);
1046: /*start, Punit Kumar*/
1047: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1048:
1049: /*end */
1050: CURSOR cur_get_trans_id (v_line_id NUMBER)
1051: IS

Line 1053: FROM gme_resource_txns_gtmp t, gme_resource_txns r

1049: /*end */
1050: CURSOR cur_get_trans_id (v_line_id NUMBER)
1051: IS
1052: SELECT r.*
1053: FROM gme_resource_txns_gtmp t, gme_resource_txns r
1054: WHERE action_code = 'NONE' AND t.line_id = v_line_id
1055: AND t.poc_trans_id = r.poc_trans_id;
1056:
1057: update_rsrc_usage EXCEPTION;

Line 1213: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1209: ,p_activity IN VARCHAR2 := NULL
1210: ,p_resource IN VARCHAR2 := NULL
1211: ,p_instance_no IN NUMBER := NULL
1212: ,p_reason_name IN VARCHAR2 := NULL
1213: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1214: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1215: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1216: ,x_message_count OUT NOCOPY NUMBER
1217: ,x_message_list OUT NOCOPY VARCHAR2

Line 1215: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1211: ,p_instance_no IN NUMBER := NULL
1212: ,p_reason_name IN VARCHAR2 := NULL
1213: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1214: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1215: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1216: ,x_message_count OUT NOCOPY NUMBER
1217: ,x_message_list OUT NOCOPY VARCHAR2
1218: ,x_return_status OUT NOCOPY VARCHAR2)
1219: IS

Line 1222: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1218: ,x_return_status OUT NOCOPY VARCHAR2)
1219: IS
1220: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_INCR_ACTUAL_RSRC_TXN';
1221: l_batch_header gme_batch_header%ROWTYPE;
1222: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1223: BEGIN
1224: /* Set the savepoint */
1225: SAVEPOINT insert_incr_actual_rsrc_txn;
1226:

Line 1352: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1348: ,p_activity IN VARCHAR2 := NULL
1349: ,p_resource IN VARCHAR2 := NULL
1350: ,p_instance_no IN NUMBER := NULL
1351: ,p_reason_name IN VARCHAR2 := NULL
1352: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1353: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1354: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1355: ,x_message_count OUT NOCOPY NUMBER
1356: ,x_message_list OUT NOCOPY VARCHAR2

Line 1354: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1350: ,p_instance_no IN NUMBER := NULL
1351: ,p_reason_name IN VARCHAR2 := NULL
1352: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1353: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1354: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1355: ,x_message_count OUT NOCOPY NUMBER
1356: ,x_message_list OUT NOCOPY VARCHAR2
1357: ,x_return_status OUT NOCOPY VARCHAR2)
1358: IS

Line 1361: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1357: ,x_return_status OUT NOCOPY VARCHAR2)
1358: IS
1359: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_TIMED_ACTUAL_RSRC_TXN';
1360: l_batch_header gme_batch_header%ROWTYPE;
1361: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1362:
1363: BEGIN
1364: /* Set the savepoint */
1365: SAVEPOINT insert_timed_actual_rsrc_txn;

Line 1500: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1496: ,p_activity IN VARCHAR2 := NULL
1497: ,p_resource IN VARCHAR2 := NULL
1498: ,p_instance_no IN NUMBER
1499: ,p_reason_name IN VARCHAR2 := NULL
1500: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1501: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1502: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1503: ,x_message_count OUT NOCOPY NUMBER
1504: ,x_message_list OUT NOCOPY VARCHAR2

Line 1502: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1498: ,p_instance_no IN NUMBER
1499: ,p_reason_name IN VARCHAR2 := NULL
1500: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1501: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1502: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1503: ,x_message_count OUT NOCOPY NUMBER
1504: ,x_message_list OUT NOCOPY VARCHAR2
1505: ,x_return_status OUT NOCOPY VARCHAR2)
1506: IS

Line 1509: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1505: ,x_return_status OUT NOCOPY VARCHAR2)
1506: IS
1507: l_api_name CONSTANT VARCHAR2(30) := 'START_CMPLT_ACTUAL_RSRC_TXN';
1508: l_batch_header gme_batch_header%ROWTYPE;
1509: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1510:
1511: BEGIN
1512: /* Set the savepoint */
1513: SAVEPOINT start_cmplt_actual_rsrc_txn;

Line 1633: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1629: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1630: ,p_commit IN VARCHAR2 := fnd_api.g_false
1631: ,p_instance_no IN NUMBER := NULL
1632: ,p_reason_name IN VARCHAR2 := NULL
1633: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1634: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1635: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1636: ,x_message_count OUT NOCOPY NUMBER
1637: ,x_message_list OUT NOCOPY VARCHAR2

Line 1635: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1631: ,p_instance_no IN NUMBER := NULL
1632: ,p_reason_name IN VARCHAR2 := NULL
1633: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1634: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1635: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1636: ,x_message_count OUT NOCOPY NUMBER
1637: ,x_message_list OUT NOCOPY VARCHAR2
1638: ,x_return_status OUT NOCOPY VARCHAR2)
1639: IS

Line 1642: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1638: ,x_return_status OUT NOCOPY VARCHAR2)
1639: IS
1640: l_api_name CONSTANT VARCHAR2(30) := 'END_CMPLT_ACTUAL_RSRC_TXN';
1641: l_batch_header gme_batch_header%ROWTYPE;
1642: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1643: BEGIN
1644: /* Set the savepoint */
1645: SAVEPOINT end_cmplt_actual_rsrc_txn;
1646: