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.RCV_HXT_GRP dependencies on RCV_TRANSACTIONS

Line 40: , po_receipt_date RCV_TRANSACTIONS.transaction_date%TYPE

36: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE
37: , po_price_type PO_TEMP_LABOR_RATES_V.asg_rate_type%TYPE
38: , po_price_type_display PO_TEMP_LABOR_RATES_V.price_type_dsp%TYPE
39: , po_billable_amount PO_LINES_ALL.amount%TYPE
40: , po_receipt_date RCV_TRANSACTIONS.transaction_date%TYPE
41: , lpn_group_id RCV_TRANSACTIONS.lpn_group_id%TYPE
42:
43: -- save the transaction type so we know how to check for success
44: , transaction_type VARCHAR2(240)

Line 41: , lpn_group_id RCV_TRANSACTIONS.lpn_group_id%TYPE

37: , po_price_type PO_TEMP_LABOR_RATES_V.asg_rate_type%TYPE
38: , po_price_type_display PO_TEMP_LABOR_RATES_V.price_type_dsp%TYPE
39: , po_billable_amount PO_LINES_ALL.amount%TYPE
40: , po_receipt_date RCV_TRANSACTIONS.transaction_date%TYPE
41: , lpn_group_id RCV_TRANSACTIONS.lpn_group_id%TYPE
42:
43: -- save the transaction type so we know how to check for success
44: , transaction_type VARCHAR2(240)
45:

Line 47: , receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

43: -- save the transaction type so we know how to check for success
44: , transaction_type VARCHAR2(240)
45:
46: -- we need to reference two rti rows for corrections
47: , receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
48: , deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
49:
50: -- we need to reference four rti rows for delete+insert
51: , delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

Line 48: , deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

44: , transaction_type VARCHAR2(240)
45:
46: -- we need to reference two rti rows for corrections
47: , receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
48: , deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
49:
50: -- we need to reference four rti rows for delete+insert
51: , delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
52: , delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

Line 51: , delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

47: , receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
48: , deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
49:
50: -- we need to reference four rti rows for delete+insert
51: , delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
52: , delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
53:
54: -- parent txns exist when we have received against this po line before
55: , parent_receive_txn_id RCV_TRANSACTIONS.transaction_id%TYPE

Line 52: , delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

48: , deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
49:
50: -- we need to reference four rti rows for delete+insert
51: , delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
52: , delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
53:
54: -- parent txns exist when we have received against this po line before
55: , parent_receive_txn_id RCV_TRANSACTIONS.transaction_id%TYPE
56: , parent_deliver_txn_id RCV_TRANSACTIONS.transaction_id%TYPE

Line 55: , parent_receive_txn_id RCV_TRANSACTIONS.transaction_id%TYPE

51: , delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
52: , delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
53:
54: -- parent txns exist when we have received against this po line before
55: , parent_receive_txn_id RCV_TRANSACTIONS.transaction_id%TYPE
56: , parent_deliver_txn_id RCV_TRANSACTIONS.transaction_id%TYPE
57:
58: -- org_id of the PO/CWK
59: , org_id PO_HEADERS_ALL.org_id%TYPE

Line 56: , parent_deliver_txn_id RCV_TRANSACTIONS.transaction_id%TYPE

52: , delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
53:
54: -- parent txns exist when we have received against this po line before
55: , parent_receive_txn_id RCV_TRANSACTIONS.transaction_id%TYPE
56: , parent_deliver_txn_id RCV_TRANSACTIONS.transaction_id%TYPE
57:
58: -- org_id of the PO/CWK
59: , org_id PO_HEADERS_ALL.org_id%TYPE
60:

Line 78: TYPE rti_table IS TABLE OF RCV_TRANSACTIONS_INTERFACE%ROWTYPE INDEX BY BINARY_INTEGER;

74: -- temp tables for ROI data
75: -- We will create one rhi row per PO per timecard
76: -- and one rti row per PO line per timecard
77: TYPE rhi_table IS TABLE OF RCV_HEADERS_INTERFACE%ROWTYPE INDEX BY BINARY_INTEGER;
78: TYPE rti_table IS TABLE OF RCV_TRANSACTIONS_INTERFACE%ROWTYPE INDEX BY BINARY_INTEGER;
79:
80: -- store results of the above in a hash for quick lookup
81: TYPE rti_status_table IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
82:

Line 148: TYPE rcv_transactions_cr IS RECORD

144: , effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%TYPE
145: , effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%TYPE
146: );
147:
148: TYPE rcv_transactions_cr IS RECORD
149: ( receive_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE
150: , deliver_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE
151: , po_line_id RCV_TRANSACTIONS.po_line_id%TYPE
152: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE

Line 149: ( receive_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE

145: , effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%TYPE
146: );
147:
148: TYPE rcv_transactions_cr IS RECORD
149: ( receive_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE
150: , deliver_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE
151: , po_line_id RCV_TRANSACTIONS.po_line_id%TYPE
152: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
153: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE /* Bug 14609848 */

Line 150: , deliver_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE

146: );
147:
148: TYPE rcv_transactions_cr IS RECORD
149: ( receive_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE
150: , deliver_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE
151: , po_line_id RCV_TRANSACTIONS.po_line_id%TYPE
152: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
153: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE /* Bug 14609848 */
154: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE /* Bug 14609848 */

Line 151: , po_line_id RCV_TRANSACTIONS.po_line_id%TYPE

147:
148: TYPE rcv_transactions_cr IS RECORD
149: ( receive_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE
150: , deliver_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE
151: , po_line_id RCV_TRANSACTIONS.po_line_id%TYPE
152: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
153: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE /* Bug 14609848 */
154: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE /* Bug 14609848 */
155: , timecard_id RCV_TRANSACTIONS.timecard_id%TYPE

Line 155: , timecard_id RCV_TRANSACTIONS.timecard_id%TYPE

151: , po_line_id RCV_TRANSACTIONS.po_line_id%TYPE
152: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
153: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE /* Bug 14609848 */
154: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE /* Bug 14609848 */
155: , timecard_id RCV_TRANSACTIONS.timecard_id%TYPE
156: , timecard_ovn RCV_TRANSACTIONS.timecard_ovn%TYPE
157: );
158:
159: -- cache results of expensive OTL APIs and SQLs

Line 156: , timecard_ovn RCV_TRANSACTIONS.timecard_ovn%TYPE

152: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
153: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE /* Bug 14609848 */
154: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE /* Bug 14609848 */
155: , timecard_id RCV_TRANSACTIONS.timecard_id%TYPE
156: , timecard_ovn RCV_TRANSACTIONS.timecard_ovn%TYPE
157: );
158:
159: -- cache results of expensive OTL APIs and SQLs
160: TYPE build_block_cache IS TABLE OF HXC_USER_TYPE_DEFINITION_GRP.building_block_info INDEX BY BINARY_INTEGER;

Line 168: TYPE rcv_transactions_cache IS TABLE OF rcv_transactions_cr INDEX BY BINARY_INTEGER;

164: TYPE po_distribution_cache IS TABLE OF po_distribution_cr INDEX BY BINARY_INTEGER;
165: TYPE price_type_lookup_cache IS TABLE OF fnd_lookups_cr INDEX BY BINARY_INTEGER;
166: TYPE price_differentials_cache IS TABLE OF price_differentials_cr INDEX BY BINARY_INTEGER;
167: TYPE assignments_cache IS TABLE OF per_all_assignments_cr INDEX BY BINARY_INTEGER;
168: TYPE rcv_transactions_cache IS TABLE OF rcv_transactions_cr INDEX BY BINARY_INTEGER;
169:
170: -- package globals
171: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_HXT_GRP';
172: G_LOG_MODULE CONSTANT VARCHAR2(40) := 'po.plsql.' || G_PKG_NAME;

Line 197: g_rcv_transactions_cache rcv_transactions_cache;

193: g_po_distribution_cache po_distribution_cache;
194: g_price_type_lookup_cache price_type_lookup_cache;
195: g_price_differentials_cache price_differentials_cache;
196: g_assignments_cache assignments_cache;
197: g_rcv_transactions_cache rcv_transactions_cache;
198:
199: -- performance info
200: g_retrieval_start DATE;
201: g_retrieval_stop DATE;

Line 222: g_rcv_transactions_calls NUMBER;

218: g_po_distribution_calls NUMBER;
219: g_price_type_lookup_calls NUMBER;
220: g_price_differentials_calls NUMBER;
221: g_assignments_calls NUMBER;
222: g_rcv_transactions_calls NUMBER;
223:
224: g_build_block_misses NUMBER;
225: g_build_attribute_misses NUMBER;
226: g_po_header_misses NUMBER;

Line 232: g_rcv_transactions_misses NUMBER;

228: g_po_distribution_misses NUMBER;
229: g_price_type_lookup_misses NUMBER;
230: g_price_differentials_misses NUMBER;
231: g_assignments_misses NUMBER;
232: g_rcv_transactions_misses NUMBER;
233:
234: g_error_raised_flag NUMBER := 0;--Bug:5559915
235: /** Bug:5559915
236: * Above variable is introduced to prevent logging of same

Line 247: FROM rcv_transactions

243: CURSOR new_rt_rows( v_group_id VARCHAR2 ) IS
244: SELECT po_line_id
245: , timecard_id
246: , interface_transaction_id
247: FROM rcv_transactions
248: WHERE group_id = v_group_id;
249:
250: ISP_STORE_TIMECARD_FAILED EXCEPTION;
251: ISP_RECONCILE_ACTIONS_FAILED EXCEPTION;

Line 486: g_rcv_transactions_calls := 0;

482: g_po_distribution_calls := 0;
483: g_price_type_lookup_calls := 0;
484: g_price_differentials_calls := 0;
485: g_assignments_calls := 0;
486: g_rcv_transactions_calls := 0;
487:
488: g_build_block_misses := 0;
489: g_build_attribute_misses := 0;
490: g_po_header_misses := 0;

Line 496: g_rcv_transactions_misses := 0;

492: g_po_distribution_misses := 0;
493: g_price_type_lookup_misses := 0;
494: g_price_differentials_misses := 0;
495: g_assignments_misses := 0;
496: g_rcv_transactions_misses := 0;
497: END IF;
498: END initialize_cache_statistics;
499:
500: PROCEDURE initialize_timing_statistics IS

Line 558: ) RETURN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE IS

554:
555: FUNCTION get_rti_idx
556: ( p_attributes IN TimecardAttributesRec
557: , p_rti_rows IN rti_table
558: ) RETURN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE IS
559: BEGIN
560: -- projects case placed in separate loop so we only test once
561:
562: IF p_attributes.project_id IS NOT NULL AND

Line 589: ) RETURN RCV_TRANSACTIONS_INTERFACE.group_id%TYPE IS

585: END get_rti_idx;
586:
587: FUNCTION get_group_id
588: ( p_rti_rows IN rti_table
589: ) RETURN RCV_TRANSACTIONS_INTERFACE.group_id%TYPE IS
590: BEGIN
591: IF g_group_id = 0 THEN
592: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
593: INTO g_group_id

Line 934: ) RETURN rcv_transactions_cr IS

930:
931: FUNCTION get_rcv_transaction
932: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
933: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
934: ) RETURN rcv_transactions_cr IS
935: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';
936: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
937: BEGIN
938: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

Line 942: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;

938: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
939: , module => l_log_head
940: , message => 'Finding Parent Transcations , TimeCard ID: ' || p_timecard_bb_id || ' Po line Id: ' || p_po_line_id
941: );
942: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;
943:
944: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
945: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id <> p_po_line_id THEN
946: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;

Line 944: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR

940: , message => 'Finding Parent Transcations , TimeCard ID: ' || p_timecard_bb_id || ' Po line Id: ' || p_po_line_id
941: );
942: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;
943:
944: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
945: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id <> p_po_line_id THEN
946: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
947:
948: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id := p_po_line_id;

Line 945: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id <> p_po_line_id THEN

941: );
942: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;
943:
944: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
945: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id <> p_po_line_id THEN
946: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
947:
948: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id := p_po_line_id;
949: --Bug 5217532 START

Line 946: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;

942: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;
943:
944: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
945: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id <> p_po_line_id THEN
946: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
947:
948: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id := p_po_line_id;
949: --Bug 5217532 START
950: --Break the old SQL into 2 different SQL to avoid Merge Join Catesian

Line 948: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id := p_po_line_id;

944: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
945: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id <> p_po_line_id THEN
946: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
947:
948: g_rcv_transactions_cache(p_timecard_bb_id).po_line_id := p_po_line_id;
949: --Bug 5217532 START
950: --Break the old SQL into 2 different SQL to avoid Merge Join Catesian
951: BEGIN
952: SELECT receive.transaction_id

Line 953: INTO g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id

949: --Bug 5217532 START
950: --Break the old SQL into 2 different SQL to avoid Merge Join Catesian
951: BEGIN
952: SELECT receive.transaction_id
953: INTO g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id
954: FROM rcv_transactions receive
955: WHERE receive.timecard_id = p_timecard_bb_id
956: AND receive.po_line_id = p_po_line_id
957: AND receive.transaction_type = 'RECEIVE';

Line 954: FROM rcv_transactions receive

950: --Break the old SQL into 2 different SQL to avoid Merge Join Catesian
951: BEGIN
952: SELECT receive.transaction_id
953: INTO g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id
954: FROM rcv_transactions receive
955: WHERE receive.timecard_id = p_timecard_bb_id
956: AND receive.po_line_id = p_po_line_id
957: AND receive.transaction_type = 'RECEIVE';
958: EXCEPTION

Line 960: g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id := NULL;

956: AND receive.po_line_id = p_po_line_id
957: AND receive.transaction_type = 'RECEIVE';
958: EXCEPTION
959: WHEN NO_DATA_FOUND THEN
960: g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id := NULL;
961: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
962: , module => l_log_head
963: , message => 'Unable to find Parent Transcations ,TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id
964: );

Line 970: INTO g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id

966: END;
967:
968: BEGIN
969: SELECT deliver.transaction_id
970: INTO g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id
971: FROM rcv_transactions deliver
972: WHERE deliver.timecard_id = p_timecard_bb_id
973: AND deliver.po_line_id = p_po_line_id
974: AND deliver.transaction_type = 'DELIVER';

Line 971: FROM rcv_transactions deliver

967:
968: BEGIN
969: SELECT deliver.transaction_id
970: INTO g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id
971: FROM rcv_transactions deliver
972: WHERE deliver.timecard_id = p_timecard_bb_id
973: AND deliver.po_line_id = p_po_line_id
974: AND deliver.transaction_type = 'DELIVER';
975: EXCEPTION

Line 977: g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id := NULL;

973: AND deliver.po_line_id = p_po_line_id
974: AND deliver.transaction_type = 'DELIVER';
975: EXCEPTION
976: WHEN NO_DATA_FOUND THEN
977: g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id := NULL;
978: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
979: , module => l_log_head
980: , message => 'Unable to find Parent Transcations ,TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id
981: );

Line 987: RETURN g_rcv_transactions_cache(p_timecard_bb_id);

983: END;
984: --Bug 5217532 END
985: END IF;
986:
987: RETURN g_rcv_transactions_cache(p_timecard_bb_id);
988: END get_rcv_transaction;
989:
990: FUNCTION get_rcv_transaction
991: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

Line 996: ) RETURN rcv_transactions_cr IS

992: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
993: , p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
994: , p_project_id IN PO_DISTRIBUTIONS_ALL.project_id%TYPE /* Bug 14609848 */
995: , p_task_id IN PO_DISTRIBUTIONS_ALL.task_id%TYPE /* Bug 14609848 */
996: ) RETURN rcv_transactions_cr IS
997: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';
998: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
999: BEGIN
1000: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

Line 1008: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;

1004: IF p_po_distribution_id IS NULL THEN
1005: RETURN get_rcv_transaction( p_timecard_bb_id, p_po_line_id );
1006: END IF;
1007:
1008: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;
1009:
1010: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
1011: g_rcv_transactions_cache(p_timecard_bb_id).project_id <> p_project_id OR /* Bug 14609848 */
1012: g_rcv_transactions_cache(p_timecard_bb_id).task_id <> p_task_id OR /* Bug 14609848 */

Line 1010: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR

1006: END IF;
1007:
1008: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;
1009:
1010: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
1011: g_rcv_transactions_cache(p_timecard_bb_id).project_id <> p_project_id OR /* Bug 14609848 */
1012: g_rcv_transactions_cache(p_timecard_bb_id).task_id <> p_task_id OR /* Bug 14609848 */
1013: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id <> p_po_distribution_id THEN
1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;

Line 1011: g_rcv_transactions_cache(p_timecard_bb_id).project_id <> p_project_id OR /* Bug 14609848 */

1007:
1008: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;
1009:
1010: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
1011: g_rcv_transactions_cache(p_timecard_bb_id).project_id <> p_project_id OR /* Bug 14609848 */
1012: g_rcv_transactions_cache(p_timecard_bb_id).task_id <> p_task_id OR /* Bug 14609848 */
1013: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id <> p_po_distribution_id THEN
1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
1015:

Line 1012: g_rcv_transactions_cache(p_timecard_bb_id).task_id <> p_task_id OR /* Bug 14609848 */

1008: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;
1009:
1010: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
1011: g_rcv_transactions_cache(p_timecard_bb_id).project_id <> p_project_id OR /* Bug 14609848 */
1012: g_rcv_transactions_cache(p_timecard_bb_id).task_id <> p_task_id OR /* Bug 14609848 */
1013: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id <> p_po_distribution_id THEN
1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
1015:
1016: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id := p_po_distribution_id;

Line 1013: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id <> p_po_distribution_id THEN

1009:
1010: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
1011: g_rcv_transactions_cache(p_timecard_bb_id).project_id <> p_project_id OR /* Bug 14609848 */
1012: g_rcv_transactions_cache(p_timecard_bb_id).task_id <> p_task_id OR /* Bug 14609848 */
1013: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id <> p_po_distribution_id THEN
1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
1015:
1016: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id := p_po_distribution_id;
1017: g_rcv_transactions_cache(p_timecard_bb_id).project_id := p_project_id; /* Bug 14609848 */

Line 1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;

1010: IF NOT g_rcv_transactions_cache.EXISTS(p_timecard_bb_id) OR
1011: g_rcv_transactions_cache(p_timecard_bb_id).project_id <> p_project_id OR /* Bug 14609848 */
1012: g_rcv_transactions_cache(p_timecard_bb_id).task_id <> p_task_id OR /* Bug 14609848 */
1013: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id <> p_po_distribution_id THEN
1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
1015:
1016: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id := p_po_distribution_id;
1017: g_rcv_transactions_cache(p_timecard_bb_id).project_id := p_project_id; /* Bug 14609848 */
1018: g_rcv_transactions_cache(p_timecard_bb_id).task_id := p_task_id; /* Bug 14609848 */

Line 1016: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id := p_po_distribution_id;

1012: g_rcv_transactions_cache(p_timecard_bb_id).task_id <> p_task_id OR /* Bug 14609848 */
1013: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id <> p_po_distribution_id THEN
1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
1015:
1016: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id := p_po_distribution_id;
1017: g_rcv_transactions_cache(p_timecard_bb_id).project_id := p_project_id; /* Bug 14609848 */
1018: g_rcv_transactions_cache(p_timecard_bb_id).task_id := p_task_id; /* Bug 14609848 */
1019:
1020: --Bug 5217532 START

Line 1017: g_rcv_transactions_cache(p_timecard_bb_id).project_id := p_project_id; /* Bug 14609848 */

1013: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id <> p_po_distribution_id THEN
1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
1015:
1016: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id := p_po_distribution_id;
1017: g_rcv_transactions_cache(p_timecard_bb_id).project_id := p_project_id; /* Bug 14609848 */
1018: g_rcv_transactions_cache(p_timecard_bb_id).task_id := p_task_id; /* Bug 14609848 */
1019:
1020: --Bug 5217532 START
1021: --Break the old SQL into 2 different SQL to avoid Merge Join Catesian

Line 1018: g_rcv_transactions_cache(p_timecard_bb_id).task_id := p_task_id; /* Bug 14609848 */

1014: g_rcv_transactions_misses := g_rcv_transactions_misses + 1;
1015:
1016: g_rcv_transactions_cache(p_timecard_bb_id).po_distribution_id := p_po_distribution_id;
1017: g_rcv_transactions_cache(p_timecard_bb_id).project_id := p_project_id; /* Bug 14609848 */
1018: g_rcv_transactions_cache(p_timecard_bb_id).task_id := p_task_id; /* Bug 14609848 */
1019:
1020: --Bug 5217532 START
1021: --Break the old SQL into 2 different SQL to avoid Merge Join Catesian
1022: BEGIN

Line 1024: INTO g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id

1020: --Bug 5217532 START
1021: --Break the old SQL into 2 different SQL to avoid Merge Join Catesian
1022: BEGIN
1023: SELECT receive.transaction_id
1024: INTO g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id
1025: FROM rcv_transactions receive
1026: WHERE receive.timecard_id = p_timecard_bb_id
1027: AND receive.po_distribution_id = p_po_distribution_id
1028: AND receive.project_id = p_project_id /* Bug 14609848 */

Line 1025: FROM rcv_transactions receive

1021: --Break the old SQL into 2 different SQL to avoid Merge Join Catesian
1022: BEGIN
1023: SELECT receive.transaction_id
1024: INTO g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id
1025: FROM rcv_transactions receive
1026: WHERE receive.timecard_id = p_timecard_bb_id
1027: AND receive.po_distribution_id = p_po_distribution_id
1028: AND receive.project_id = p_project_id /* Bug 14609848 */
1029: AND receive.task_id = p_task_id /* Bug 14609848 */

Line 1033: g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id := NULL;

1029: AND receive.task_id = p_task_id /* Bug 14609848 */
1030: AND receive.transaction_type = 'RECEIVE';
1031: EXCEPTION
1032: WHEN NO_DATA_FOUND THEN
1033: g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id := NULL;
1034: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1035: , module => l_log_head
1036: , message => 'Unable to find Parent Transcations ,TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id || ' po_distribution_id: ' || p_po_distribution_id
1037: );

Line 1042: INTO g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id

1038: END;
1039:
1040: BEGIN
1041: SELECT deliver.transaction_id
1042: INTO g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id
1043: FROM rcv_transactions deliver
1044: WHERE deliver.timecard_id = p_timecard_bb_id
1045: AND deliver.po_distribution_id = p_po_distribution_id
1046: AND deliver.project_id = p_project_id /* Bug 14609848 */

Line 1043: FROM rcv_transactions deliver

1039:
1040: BEGIN
1041: SELECT deliver.transaction_id
1042: INTO g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id
1043: FROM rcv_transactions deliver
1044: WHERE deliver.timecard_id = p_timecard_bb_id
1045: AND deliver.po_distribution_id = p_po_distribution_id
1046: AND deliver.project_id = p_project_id /* Bug 14609848 */
1047: AND deliver.task_id = p_task_id /* Bug 14609848 */

Line 1051: g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id := NULL;

1047: AND deliver.task_id = p_task_id /* Bug 14609848 */
1048: AND deliver.transaction_type = 'DELIVER';
1049: EXCEPTION
1050: WHEN NO_DATA_FOUND THEN
1051: g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id := NULL;
1052: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1053: , module => l_log_head
1054: , message => 'Unable to find Parent Transcations ,TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id || ' po_distribution_id: ' || p_po_distribution_id
1055: );

Line 1060: RETURN g_rcv_transactions_cache(p_timecard_bb_id);

1056: END;
1057: --Bug 5217532 END
1058: END IF;
1059:
1060: RETURN g_rcv_transactions_cache(p_timecard_bb_id);
1061: END get_rcv_transaction;
1062:
1063: -- cached wrapper for build_block
1064: FUNCTION build_block

Line 1932: PROCEDURE Derive_Common_RTI_Values( p_rti_row IN OUT NOCOPY RCV_TRANSACTIONS_INTERFACE%ROWTYPE

1928: , p_message_extent => HXC_USER_TYPE_DEFINITION_GRP.c_blk_children_extent
1929: );
1930: END Validate_Amount_Tolerances;
1931:
1932: PROCEDURE Derive_Common_RTI_Values( p_rti_row IN OUT NOCOPY RCV_TRANSACTIONS_INTERFACE%ROWTYPE
1933: , p_attributes IN TimecardAttributesRec
1934: ) IS
1935: l_api_name CONSTANT varchar2(30) := 'Derive_Common_RTI_Values';
1936: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 1939: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

1935: l_api_name CONSTANT varchar2(30) := 'Derive_Common_RTI_Values';
1936: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1937: BEGIN
1938: -- interface_transaction_id
1939: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
1940: INTO p_rti_row.interface_transaction_id
1941: FROM dual;
1942:
1943: -- job_id

Line 1997: l_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;

1993: , p_rti_rows IN OUT NOCOPY rti_table
1994: , p_attributes IN OUT NOCOPY TimecardAttributesRec
1995: ) IS
1996: l_rhi_row RCV_HEADERS_INTERFACE%ROWTYPE;
1997: l_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
1998: l_rhi_row_idx BINARY_INTEGER;
1999: l_rti_row_idx BINARY_INTEGER;
2000: l_api_name CONSTANT varchar2(30) := 'Derive_Receive_Values';
2001: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 2185: l_swap rcv_transactions_interface.interface_transaction_id%TYPE; /Bug 6031665/

2181: , p_old_attributes IN OUT NOCOPY TimecardAttributesRec
2182: ) IS
2183: l_correction_amount po_lines_all.amount%TYPE;
2184: l_old_correction_amount po_lines_all.amount%TYPE;
2185: l_swap rcv_transactions_interface.interface_transaction_id%TYPE; /*Bug 6031665*/
2186: -- we need one correction for each parent transaction
2187: l_rcv_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
2188: l_del_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
2189: l_rti_row_idx BINARY_INTEGER;

Line 2187: l_rcv_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;

2183: l_correction_amount po_lines_all.amount%TYPE;
2184: l_old_correction_amount po_lines_all.amount%TYPE;
2185: l_swap rcv_transactions_interface.interface_transaction_id%TYPE; /*Bug 6031665*/
2186: -- we need one correction for each parent transaction
2187: l_rcv_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
2188: l_del_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
2189: l_rti_row_idx BINARY_INTEGER;
2190: l_api_name CONSTANT varchar2(30) := 'Derive_Correction_Values';
2191: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 2188: l_del_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;

2184: l_old_correction_amount po_lines_all.amount%TYPE;
2185: l_swap rcv_transactions_interface.interface_transaction_id%TYPE; /*Bug 6031665*/
2186: -- we need one correction for each parent transaction
2187: l_rcv_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
2188: l_del_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
2189: l_rti_row_idx BINARY_INTEGER;
2190: l_api_name CONSTANT varchar2(30) := 'Derive_Correction_Values';
2191: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
2192: BEGIN

Line 2351: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

2347: IF l_correction_amount < 0 THEN
2348: -- for negative corrections, we correct the deliver first
2349:
2350: -- get the next rti id for the receive transaction
2351: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
2352: INTO l_rcv_rti_row.interface_transaction_id
2353: FROM dual;
2354:
2355: -- insert into rti table

Line 2362: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

2358: ELSE
2359: -- for positive corrections, we correct the receive first
2360:
2361: -- get the next rti id for the deliver transaction
2362: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
2363: INTO l_del_rti_row.interface_transaction_id
2364: FROM dual;
2365:
2366: -- insert into rti table

Line 2683: l_rti_row rcv_transactions_interface%ROWTYPE;

2679:
2680: l_rhi_idx BINARY_INTEGER;
2681: l_rti_idx BINARY_INTEGER;
2682: l_rhi_row rcv_headers_interface%ROWTYPE;
2683: l_rti_row rcv_transactions_interface%ROWTYPE;
2684: BEGIN
2685: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2686: , module => l_log_head
2687: , message => 'Finding ROI rows: p_rhi_rows.COUNT=' || p_rhi_rows.COUNT || ' p_rti_rows.COUNT=' || p_rti_rows.COUNT || ' p_attributes.po_distribution_id=' || p_attributes.po_distribution_id

Line 2844: TYPE interface_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE INDEX BY BINARY_INTEGER;

2840: TYPE expected_receipt_date_tbl IS TABLE OF RCV_HEADERS_INTERFACE.expected_receipt_date%TYPE INDEX BY BINARY_INTEGER;
2841: TYPE employee_id_tbl IS TABLE OF RCV_HEADERS_INTERFACE.employee_id%TYPE INDEX BY BINARY_INTEGER;
2842: TYPE validation_flag_tbl IS TABLE OF RCV_HEADERS_INTERFACE.validation_flag%TYPE INDEX BY BINARY_INTEGER;
2843:
2844: TYPE interface_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2845: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;
2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;

Line 2845: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;

2841: TYPE employee_id_tbl IS TABLE OF RCV_HEADERS_INTERFACE.employee_id%TYPE INDEX BY BINARY_INTEGER;
2842: TYPE validation_flag_tbl IS TABLE OF RCV_HEADERS_INTERFACE.validation_flag%TYPE INDEX BY BINARY_INTEGER;
2843:
2844: TYPE interface_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2845: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;
2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;

Line 2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;

2842: TYPE validation_flag_tbl IS TABLE OF RCV_HEADERS_INTERFACE.validation_flag%TYPE INDEX BY BINARY_INTEGER;
2843:
2844: TYPE interface_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2845: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;
2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;

Line 2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;

2843:
2844: TYPE interface_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2845: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;
2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;

Line 2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;

2844: TYPE interface_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2845: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;
2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;

Line 2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;

2845: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;
2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;

Line 2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;

2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;
2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;

Line 2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;

2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;
2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;

Line 2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;

2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;
2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;
2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;

Line 2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;

2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;
2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;
2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;
2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;

Line 2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;

2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;
2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;
2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;
2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;
2858: TYPE job_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.job_id%TYPE INDEX BY BINARY_INTEGER;

Line 2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;

2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;
2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;
2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;
2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;
2858: TYPE job_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.job_id%TYPE INDEX BY BINARY_INTEGER;
2859: TYPE timecard_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_id%TYPE INDEX BY BINARY_INTEGER;

Line 2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;

2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;
2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;
2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;
2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;
2858: TYPE job_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.job_id%TYPE INDEX BY BINARY_INTEGER;
2859: TYPE timecard_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_id%TYPE INDEX BY BINARY_INTEGER;
2860: TYPE timecard_ovn_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_ovn%TYPE INDEX BY BINARY_INTEGER;

Line 2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;

2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;
2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;
2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;
2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;
2858: TYPE job_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.job_id%TYPE INDEX BY BINARY_INTEGER;
2859: TYPE timecard_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_id%TYPE INDEX BY BINARY_INTEGER;
2860: TYPE timecard_ovn_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_ovn%TYPE INDEX BY BINARY_INTEGER;
2861: --Bug6395858

Line 2858: TYPE job_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.job_id%TYPE INDEX BY BINARY_INTEGER;

2854: TYPE po_distribution_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;
2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;
2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;
2858: TYPE job_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.job_id%TYPE INDEX BY BINARY_INTEGER;
2859: TYPE timecard_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_id%TYPE INDEX BY BINARY_INTEGER;
2860: TYPE timecard_ovn_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_ovn%TYPE INDEX BY BINARY_INTEGER;
2861: --Bug6395858
2862: -- A temp table l_rhi_stat is taken to mark those timecards for

Line 2859: TYPE timecard_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_id%TYPE INDEX BY BINARY_INTEGER;

2855: TYPE project_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.project_id%TYPE INDEX BY BINARY_INTEGER;
2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;
2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;
2858: TYPE job_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.job_id%TYPE INDEX BY BINARY_INTEGER;
2859: TYPE timecard_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_id%TYPE INDEX BY BINARY_INTEGER;
2860: TYPE timecard_ovn_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_ovn%TYPE INDEX BY BINARY_INTEGER;
2861: --Bug6395858
2862: -- A temp table l_rhi_stat is taken to mark those timecards for
2863: -- which RHI got in error while processing and corrosponding RTI

Line 2860: TYPE timecard_ovn_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_ovn%TYPE INDEX BY BINARY_INTEGER;

2856: TYPE task_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.task_id%TYPE INDEX BY BINARY_INTEGER;
2857: TYPE amount_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.amount%TYPE INDEX BY BINARY_INTEGER;
2858: TYPE job_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.job_id%TYPE INDEX BY BINARY_INTEGER;
2859: TYPE timecard_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_id%TYPE INDEX BY BINARY_INTEGER;
2860: TYPE timecard_ovn_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.timecard_ovn%TYPE INDEX BY BINARY_INTEGER;
2861: --Bug6395858
2862: -- A temp table l_rhi_stat is taken to mark those timecards for
2863: -- which RHI got in error while processing and corrosponding RTI
2864: -- has to maked error.

Line 3126: INSERT INTO rcv_transactions_interface( interface_transaction_id

3122: );
3123:
3124: -- insert into db from arrays
3125: FORALL i IN 1..rti_interface_transaction_id.COUNT
3126: INSERT INTO rcv_transactions_interface( interface_transaction_id
3127: , header_interface_id
3128: , group_id
3129: , lpn_group_id
3130: , last_update_date

Line 3851: UPDATE rcv_transactions_interface

3847:
3848: ROLLBACK;
3849:
3850: --
3851: UPDATE rcv_transactions_interface
3852: SET transaction_status_code = 'ERROR'
3853: WHERE group_id = g_group_id
3854: AND transaction_status_code = 'RUNNING';
3855:

Line 3897: l_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;

3893:
3894: DECLARE
3895: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3896: l_transaction_type VARCHAR2(100);
3897: l_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3898: l_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3899: l_delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3900: l_delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3901: l_message VARCHAR2(1000);

Line 3898: l_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;

3894: DECLARE
3895: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3896: l_transaction_type VARCHAR2(100);
3897: l_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3898: l_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3899: l_delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3900: l_delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3901: l_message VARCHAR2(1000);
3902: DETAIL_NOT_PROCESSED EXCEPTION;

Line 3899: l_delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;

3895: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3896: l_transaction_type VARCHAR2(100);
3897: l_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3898: l_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3899: l_delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3900: l_delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3901: l_message VARCHAR2(1000);
3902: DETAIL_NOT_PROCESSED EXCEPTION;
3903: BEGIN

Line 3900: l_delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;

3896: l_transaction_type VARCHAR2(100);
3897: l_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3898: l_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3899: l_delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3900: l_delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3901: l_message VARCHAR2(1000);
3902: DETAIL_NOT_PROCESSED EXCEPTION;
3903: BEGIN
3904: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

Line 3973: AND table_name = 'RCV_TRANSACTIONS_INTERFACE') LOOP

3969: FOR rec IN (SELECT error_message_name ||' : '|| error_message msg
3970: FROM po_interface_errors
3971: WHERE interface_line_id IN (l_receive_rti_id,l_deliver_rti_id,
3972: l_delete_receive_rti_id,l_delete_deliver_rti_id)
3973: AND table_name = 'RCV_TRANSACTIONS_INTERFACE') LOOP
3974:
3975: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3976: , module => l_log_head
3977: , message => 'RTP errors : ' || rec.msg

Line 4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)

4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4588: || FND_GLOBAL.local_chr(10)
4589: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4590: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4591: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

Line 4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)

4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)
4831: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4832: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4833: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)