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.

[Home] [Help]

APPS.GME_API_PUB dependencies on GME_RESOURCE_TXNS

Line 75: FROM gme_resource_txns_gtmp

71:
72: CURSOR header_cursor
73: IS
74: SELECT DISTINCT doc_id batch_id
75: FROM gme_resource_txns_gtmp
76: ORDER BY batch_id;
77: BEGIN
78: IF g_debug <= gme_debug.g_log_procedure THEN
79: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 120: delete from gme_resource_txns_gtmp

116: END IF;
117:
118: -- Bug 14685438 - Remove processed data.
119: IF p_commit = fnd_api.g_false THEN
120: delete from gme_resource_txns_gtmp
121: where doc_id = header_row.batch_id;
122: END IF;
123:
124: END LOOP;

Line 1071: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1067: ,p_activity IN VARCHAR2 := NULL
1068: ,p_resource IN VARCHAR2 := NULL
1069: ,p_instance_no IN NUMBER := NULL
1070: ,p_reason_name IN VARCHAR2 := NULL
1071: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1072: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1073: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1074: ,x_message_count OUT NOCOPY NUMBER
1075: ,x_message_list OUT NOCOPY VARCHAR2

Line 1073: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1069: ,p_instance_no IN NUMBER := NULL
1070: ,p_reason_name IN VARCHAR2 := NULL
1071: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1072: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1073: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1074: ,x_message_count OUT NOCOPY NUMBER
1075: ,x_message_list OUT NOCOPY VARCHAR2
1076: ,x_return_status OUT NOCOPY VARCHAR2)
1077: IS

Line 1087: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1083: l_inv_trans_count NUMBER;
1084: l_rsrc_trans_count NUMBER;
1085: l_return_status VARCHAR2 (2);
1086: /*start, Punit Kumar*/
1087: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1088:
1089: /*end */
1090: CURSOR cur_get_trans_id (v_line_id NUMBER)
1091: IS

Line 1093: FROM gme_resource_txns_gtmp t, gme_resource_txns r

1089: /*end */
1090: CURSOR cur_get_trans_id (v_line_id NUMBER)
1091: IS
1092: SELECT r.*
1093: FROM gme_resource_txns_gtmp t, gme_resource_txns r
1094: WHERE action_code = 'NONE' AND t.line_id = v_line_id
1095: AND t.poc_trans_id = r.poc_trans_id;
1096:
1097: update_rsrc_usage EXCEPTION;

Line 1253: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1249: ,p_activity IN VARCHAR2 := NULL
1250: ,p_resource IN VARCHAR2 := NULL
1251: ,p_instance_no IN NUMBER := NULL
1252: ,p_reason_name IN VARCHAR2 := NULL
1253: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1254: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1255: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1256: ,x_message_count OUT NOCOPY NUMBER
1257: ,x_message_list OUT NOCOPY VARCHAR2

Line 1255: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1251: ,p_instance_no IN NUMBER := NULL
1252: ,p_reason_name IN VARCHAR2 := NULL
1253: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1254: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1255: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1256: ,x_message_count OUT NOCOPY NUMBER
1257: ,x_message_list OUT NOCOPY VARCHAR2
1258: ,x_return_status OUT NOCOPY VARCHAR2)
1259: IS

Line 1262: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1258: ,x_return_status OUT NOCOPY VARCHAR2)
1259: IS
1260: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_INCR_ACTUAL_RSRC_TXN';
1261: l_batch_header gme_batch_header%ROWTYPE;
1262: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1263: BEGIN
1264: /* Set the savepoint */
1265: SAVEPOINT insert_incr_actual_rsrc_txn;
1266:

Line 1392: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1388: ,p_activity IN VARCHAR2 := NULL
1389: ,p_resource IN VARCHAR2 := NULL
1390: ,p_instance_no IN NUMBER := NULL
1391: ,p_reason_name IN VARCHAR2 := NULL
1392: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1393: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1394: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1395: ,x_message_count OUT NOCOPY NUMBER
1396: ,x_message_list OUT NOCOPY VARCHAR2

Line 1394: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1390: ,p_instance_no IN NUMBER := NULL
1391: ,p_reason_name IN VARCHAR2 := NULL
1392: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1393: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1394: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1395: ,x_message_count OUT NOCOPY NUMBER
1396: ,x_message_list OUT NOCOPY VARCHAR2
1397: ,x_return_status OUT NOCOPY VARCHAR2)
1398: IS

Line 1401: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1397: ,x_return_status OUT NOCOPY VARCHAR2)
1398: IS
1399: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_TIMED_ACTUAL_RSRC_TXN';
1400: l_batch_header gme_batch_header%ROWTYPE;
1401: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1402:
1403: BEGIN
1404: /* Set the savepoint */
1405: SAVEPOINT insert_timed_actual_rsrc_txn;

Line 1540: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1536: ,p_activity IN VARCHAR2 := NULL
1537: ,p_resource IN VARCHAR2 := NULL
1538: ,p_instance_no IN NUMBER
1539: ,p_reason_name IN VARCHAR2 := NULL
1540: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1541: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1542: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1543: ,x_message_count OUT NOCOPY NUMBER
1544: ,x_message_list OUT NOCOPY VARCHAR2

Line 1542: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1538: ,p_instance_no IN NUMBER
1539: ,p_reason_name IN VARCHAR2 := NULL
1540: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1541: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1542: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1543: ,x_message_count OUT NOCOPY NUMBER
1544: ,x_message_list OUT NOCOPY VARCHAR2
1545: ,x_return_status OUT NOCOPY VARCHAR2)
1546: IS

Line 1549: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1545: ,x_return_status OUT NOCOPY VARCHAR2)
1546: IS
1547: l_api_name CONSTANT VARCHAR2(30) := 'START_CMPLT_ACTUAL_RSRC_TXN';
1548: l_batch_header gme_batch_header%ROWTYPE;
1549: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1550:
1551: BEGIN
1552: /* Set the savepoint */
1553: SAVEPOINT start_cmplt_actual_rsrc_txn;

Line 1673: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

1669: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1670: ,p_commit IN VARCHAR2 := fnd_api.g_false
1671: ,p_instance_no IN NUMBER := NULL
1672: ,p_reason_name IN VARCHAR2 := NULL
1673: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1674: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1675: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1676: ,x_message_count OUT NOCOPY NUMBER
1677: ,x_message_list OUT NOCOPY VARCHAR2

Line 1675: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

1671: ,p_instance_no IN NUMBER := NULL
1672: ,p_reason_name IN VARCHAR2 := NULL
1673: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
1674: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1675: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
1676: ,x_message_count OUT NOCOPY NUMBER
1677: ,x_message_list OUT NOCOPY VARCHAR2
1678: ,x_return_status OUT NOCOPY VARCHAR2)
1679: IS

Line 1682: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

1678: ,x_return_status OUT NOCOPY VARCHAR2)
1679: IS
1680: l_api_name CONSTANT VARCHAR2(30) := 'END_CMPLT_ACTUAL_RSRC_TXN';
1681: l_batch_header gme_batch_header%ROWTYPE;
1682: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1683: BEGIN
1684: /* Set the savepoint */
1685: SAVEPOINT end_cmplt_actual_rsrc_txn;
1686: