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 PO_LINES_ALL

Line 31: , po_line PO_LINES_ALL.line_num%TYPE

27: , detail_date_to HXC_TIME_BUILDING_BLOCKS.date_to%TYPE
28: , resource_id HXC_TIME_BUILDING_BLOCKS.resource_id%TYPE
29: , po_number PO_HEADERS_ALL.segment1%TYPE
30: , po_header_id PO_HEADERS_ALL.po_header_id%TYPE
31: , po_line PO_LINES_ALL.line_num%TYPE
32: , po_line_id PO_LINES_ALL.po_line_id%TYPE
33: , po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
34: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
35: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE

Line 32: , po_line_id PO_LINES_ALL.po_line_id%TYPE

28: , resource_id HXC_TIME_BUILDING_BLOCKS.resource_id%TYPE
29: , po_number PO_HEADERS_ALL.segment1%TYPE
30: , po_header_id PO_HEADERS_ALL.po_header_id%TYPE
31: , po_line PO_LINES_ALL.line_num%TYPE
32: , po_line_id PO_LINES_ALL.po_line_id%TYPE
33: , po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
34: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
35: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE
36: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE

Line 39: , po_billable_amount PO_LINES_ALL.amount%TYPE

35: , project_id PO_DISTRIBUTIONS_ALL.project_id%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

Line 98: ( po_line_id PO_LINES_ALL.po_line_id%TYPE

94: -- Combine PO line/shipment info into a single record because
95: -- there is a 1-1 mapping between line and shipment for
96: -- Rate-Based Temp Labor
97: TYPE po_line_cr IS RECORD
98: ( po_line_id PO_LINES_ALL.po_line_id%TYPE
99: , po_header_id PO_LINES_ALL.po_header_id%TYPE
100: , line_num PO_LINES_ALL.line_num%TYPE
101: , unit_price PO_LINES_ALL.unit_price%TYPE
102: , matching_basis PO_LINES_ALL.matching_basis%TYPE

Line 99: , po_header_id PO_LINES_ALL.po_header_id%TYPE

95: -- there is a 1-1 mapping between line and shipment for
96: -- Rate-Based Temp Labor
97: TYPE po_line_cr IS RECORD
98: ( po_line_id PO_LINES_ALL.po_line_id%TYPE
99: , po_header_id PO_LINES_ALL.po_header_id%TYPE
100: , line_num PO_LINES_ALL.line_num%TYPE
101: , unit_price PO_LINES_ALL.unit_price%TYPE
102: , matching_basis PO_LINES_ALL.matching_basis%TYPE
103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE

Line 100: , line_num PO_LINES_ALL.line_num%TYPE

96: -- Rate-Based Temp Labor
97: TYPE po_line_cr IS RECORD
98: ( po_line_id PO_LINES_ALL.po_line_id%TYPE
99: , po_header_id PO_LINES_ALL.po_header_id%TYPE
100: , line_num PO_LINES_ALL.line_num%TYPE
101: , unit_price PO_LINES_ALL.unit_price%TYPE
102: , matching_basis PO_LINES_ALL.matching_basis%TYPE
103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE
104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE

Line 101: , unit_price PO_LINES_ALL.unit_price%TYPE

97: TYPE po_line_cr IS RECORD
98: ( po_line_id PO_LINES_ALL.po_line_id%TYPE
99: , po_header_id PO_LINES_ALL.po_header_id%TYPE
100: , line_num PO_LINES_ALL.line_num%TYPE
101: , unit_price PO_LINES_ALL.unit_price%TYPE
102: , matching_basis PO_LINES_ALL.matching_basis%TYPE
103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE
104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE
105: , start_date PO_LINES_ALL.start_date%TYPE

Line 102: , matching_basis PO_LINES_ALL.matching_basis%TYPE

98: ( po_line_id PO_LINES_ALL.po_line_id%TYPE
99: , po_header_id PO_LINES_ALL.po_header_id%TYPE
100: , line_num PO_LINES_ALL.line_num%TYPE
101: , unit_price PO_LINES_ALL.unit_price%TYPE
102: , matching_basis PO_LINES_ALL.matching_basis%TYPE
103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE
104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE
105: , start_date PO_LINES_ALL.start_date%TYPE
106: , expiration_date PO_LINES_ALL.expiration_date%TYPE

Line 103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE

99: , po_header_id PO_LINES_ALL.po_header_id%TYPE
100: , line_num PO_LINES_ALL.line_num%TYPE
101: , unit_price PO_LINES_ALL.unit_price%TYPE
102: , matching_basis PO_LINES_ALL.matching_basis%TYPE
103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE
104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE
105: , start_date PO_LINES_ALL.start_date%TYPE
106: , expiration_date PO_LINES_ALL.expiration_date%TYPE
107: , job_id PO_LINES_ALL.job_id%TYPE

Line 104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE

100: , line_num PO_LINES_ALL.line_num%TYPE
101: , unit_price PO_LINES_ALL.unit_price%TYPE
102: , matching_basis PO_LINES_ALL.matching_basis%TYPE
103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE
104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE
105: , start_date PO_LINES_ALL.start_date%TYPE
106: , expiration_date PO_LINES_ALL.expiration_date%TYPE
107: , job_id PO_LINES_ALL.job_id%TYPE
108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE

Line 105: , start_date PO_LINES_ALL.start_date%TYPE

101: , unit_price PO_LINES_ALL.unit_price%TYPE
102: , matching_basis PO_LINES_ALL.matching_basis%TYPE
103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE
104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE
105: , start_date PO_LINES_ALL.start_date%TYPE
106: , expiration_date PO_LINES_ALL.expiration_date%TYPE
107: , job_id PO_LINES_ALL.job_id%TYPE
108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE

Line 106: , expiration_date PO_LINES_ALL.expiration_date%TYPE

102: , matching_basis PO_LINES_ALL.matching_basis%TYPE
103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE
104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE
105: , start_date PO_LINES_ALL.start_date%TYPE
106: , expiration_date PO_LINES_ALL.expiration_date%TYPE
107: , job_id PO_LINES_ALL.job_id%TYPE
108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE
110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE

Line 107: , job_id PO_LINES_ALL.job_id%TYPE

103: , purchase_basis PO_LINES_ALL.purchase_basis%TYPE
104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE
105: , start_date PO_LINES_ALL.start_date%TYPE
106: , expiration_date PO_LINES_ALL.expiration_date%TYPE
107: , job_id PO_LINES_ALL.job_id%TYPE
108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE
110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE
111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE

Line 136: , price PO_LINES_ALL.unit_price%TYPE

132: ( entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE
133: , price_type PO_PRICE_DIFFERENTIALS.price_type%TYPE
134: , enabled_flag PO_PRICE_DIFFERENTIALS.enabled_flag%TYPE
135: , multiplier PO_PRICE_DIFFERENTIALS.multiplier%TYPE
136: , price PO_LINES_ALL.unit_price%TYPE
137: );
138:
139: -- The PO information is new to 11.5.10 so do not introduce
140: -- compile-time dependency on those fields

Line 143: , po_line_id PO_LINES_ALL.po_line_id%TYPE

139: -- The PO information is new to 11.5.10 so do not introduce
140: -- compile-time dependency on those fields
141: TYPE per_all_assignments_cr IS RECORD
142: ( person_id PER_ALL_ASSIGNMENTS_F.person_id%TYPE
143: , po_line_id PO_LINES_ALL.po_line_id%TYPE
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:

Line 515: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;

511: -- This procedure is called by the update process
512: -- to reset state of the caches for each timecard
513: -- submission without actually clearing the caches
514: PROCEDURE initialize_caches IS
515: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
516: BEGIN
517: l_po_line_id := g_po_line_cache.FIRST;
518: WHILE l_po_line_id IS NOT NULL LOOP
519: -- Reset the amounts in case the user tries

Line 629: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

625: RETURN g_po_header_cache(p_po_header_id);
626: END get_po_header;
627:
628: FUNCTION get_po_line
629: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
630: ) RETURN po_line_cr IS
631: BEGIN
632: g_po_line_calls := g_po_line_calls + 1;
633:

Line 675: FROM po_lines_all pol

671: , g_po_line_cache(p_po_line_id).tolerable_amount
672: , g_po_line_cache(p_po_line_id).timecard_amount
673: , g_po_line_cache(p_po_line_id).ship_to_organization_id
674: , g_po_line_cache(p_po_line_id).ship_to_location_id
675: FROM po_lines_all pol
676: , po_line_locations_all poll
677: WHERE pol.po_line_id = p_po_line_id
678: AND poll.po_line_id = pol.po_line_id;
679: END IF;

Line 708: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

704: RETURN g_po_line_cache(p_po_line_id);
705: END get_po_line;
706:
707: FUNCTION get_po_distribution
708: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
709: , p_project_id IN PO_DISTRIBUTIONS_ALL.project_id%TYPE
710: , p_task_id IN PO_DISTRIBUTIONS_ALL.task_id%TYPE
711: ) RETURN po_distribution_cr IS
712: l_api_name CONSTANT varchar2(30) := 'get_po_distribution';

Line 806: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

802: RETURN g_price_type_lookup_cache(l_cache_index);
803: END get_price_type_lookup;
804:
805: FUNCTION get_price_differentials
806: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
807: , p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE
808: ) RETURN price_differentials_cr IS
809: l_cache_index BINARY_INTEGER;
810: BEGIN

Line 869: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

865:
866: -- Gets assignment for this PO/person effective on a particular date
867: -- Throws a NO DATA FOUND if no such assignment exists
868: FUNCTION get_assignment
869: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
870: , p_person_id IN PER_ALL_ASSIGNMENTS_F.person_id%TYPE
871: , p_effective_date IN DATE
872: ) RETURN per_all_assignments_cr IS
873: l_sql VARCHAR2(1500);

Line 903: , po_lines_all pl

899: SELECT effective_start_date , effective_end_date
900: FROM per_all_assignments_f paaf
901: , po_cwk_associations pca
902: , po_headers_all ph
903: , po_lines_all pl
904: WHERE pca.po_line_id = :po_line_id
905: AND pca.cwk_person_id = :person_id
906: AND pca.po_line_id = pl.po_line_id
907: AND pca.po_header_id = ph.po_header_id

Line 933: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

929: END get_assignment;
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

Line 992: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

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
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

Line 1819: l_timecard_amount_sum PO_LINES_ALL.amount%TYPE;

1815: ( p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table
1816: ) IS
1817: l_return_status VARCHAR2(1);
1818: l_po_line_id BINARY_INTEGER;
1819: l_timecard_amount_sum PO_LINES_ALL.amount%TYPE;
1820: l_tolerable_amount PO_LINES_ALL.amount%TYPE;
1821: l_qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE;
1822:
1823: GET_TIMECARD_AMOUNT_FAILED EXCEPTION;

Line 1820: l_tolerable_amount PO_LINES_ALL.amount%TYPE;

1816: ) IS
1817: l_return_status VARCHAR2(1);
1818: l_po_line_id BINARY_INTEGER;
1819: l_timecard_amount_sum PO_LINES_ALL.amount%TYPE;
1820: l_tolerable_amount PO_LINES_ALL.amount%TYPE;
1821: l_qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE;
1822:
1823: GET_TIMECARD_AMOUNT_FAILED EXCEPTION;
1824: l_api_name CONSTANT varchar2(30) := 'Validate_Amount_Tolerances';

Line 2183: l_correction_amount po_lines_all.amount%TYPE;

2179: ( p_rti_rows IN OUT NOCOPY rti_table
2180: , p_attributes IN OUT NOCOPY TimecardAttributesRec
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;

Line 2184: l_old_correction_amount po_lines_all.amount%TYPE;

2180: , p_attributes IN OUT NOCOPY TimecardAttributesRec
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;