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 508: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;

504: -- This procedure is called by the update process
505: -- to reset state of the caches for each timecard
506: -- submission without actually clearing the caches
507: PROCEDURE initialize_caches IS
508: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
509: BEGIN
510: l_po_line_id := g_po_line_cache.FIRST;
511: WHILE l_po_line_id IS NOT NULL LOOP
512: -- Reset the amounts in case the user tries

Line 619: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

615: RETURN g_po_header_cache(p_po_header_id);
616: END get_po_header;
617:
618: FUNCTION get_po_line
619: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
620: ) RETURN po_line_cr IS
621: BEGIN
622: g_po_line_calls := g_po_line_calls + 1;
623:

Line 665: FROM po_lines_all pol

661: , g_po_line_cache(p_po_line_id).tolerable_amount
662: , g_po_line_cache(p_po_line_id).timecard_amount
663: , g_po_line_cache(p_po_line_id).ship_to_organization_id
664: , g_po_line_cache(p_po_line_id).ship_to_location_id
665: FROM po_lines_all pol
666: , po_line_locations_all poll
667: WHERE pol.po_line_id = p_po_line_id
668: AND poll.po_line_id = pol.po_line_id;
669: END IF;

Line 698: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

694: RETURN g_po_line_cache(p_po_line_id);
695: END get_po_line;
696:
697: FUNCTION get_po_distribution
698: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
699: , p_project_id IN PO_DISTRIBUTIONS_ALL.project_id%TYPE
700: , p_task_id IN PO_DISTRIBUTIONS_ALL.task_id%TYPE
701: ) RETURN po_distribution_cr IS
702: l_api_name CONSTANT varchar2(30) := 'get_po_distribution';

Line 796: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

792: RETURN g_price_type_lookup_cache(l_cache_index);
793: END get_price_type_lookup;
794:
795: FUNCTION get_price_differentials
796: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
797: , p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE
798: ) RETURN price_differentials_cr IS
799: l_cache_index BINARY_INTEGER;
800: BEGIN

Line 860: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

856:
857: -- Gets assignment for this PO/person effective on a particular date
858: -- Throws a NO DATA FOUND if no such assignment exists
859: FUNCTION get_assignment
860: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
861: , p_person_id IN PER_ALL_ASSIGNMENTS_F.person_id%TYPE
862: , p_effective_date IN DATE
863: ) RETURN per_all_assignments_cr IS
864: l_sql VARCHAR2(1500);

Line 895: po_lines_all pl

891: SELECT effective_start_date , effective_end_date
892: FROM per_all_assignments_f paaf,
893: po_cwk_associations pca,
894: po_headers_all ph,
895: po_lines_all pl
896: WHERE pca.po_line_id = :po_line_id
897: AND pca.cwk_person_id = :person_id
898: AND pca.po_line_id = pl.po_line_id
899: AND pca.po_header_id = ph.po_header_id

Line 926: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

922: END get_assignment;
923:
924: FUNCTION get_rcv_transaction
925: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
926: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
927: ) RETURN rcv_transactions_cr IS
928: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';
929: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
930: BEGIN

Line 985: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

981: END get_rcv_transaction;
982:
983: FUNCTION get_rcv_transaction
984: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
985: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
986: , p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
987: ) RETURN rcv_transactions_cr IS
988: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';
989: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 1787: l_timecard_amount_sum PO_LINES_ALL.amount%TYPE;

1783: ( p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table
1784: ) IS
1785: l_return_status VARCHAR2(1);
1786: l_po_line_id BINARY_INTEGER;
1787: l_timecard_amount_sum PO_LINES_ALL.amount%TYPE;
1788: l_tolerable_amount PO_LINES_ALL.amount%TYPE;
1789: l_qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE;
1790:
1791: GET_TIMECARD_AMOUNT_FAILED EXCEPTION;

Line 1788: l_tolerable_amount PO_LINES_ALL.amount%TYPE;

1784: ) IS
1785: l_return_status VARCHAR2(1);
1786: l_po_line_id BINARY_INTEGER;
1787: l_timecard_amount_sum PO_LINES_ALL.amount%TYPE;
1788: l_tolerable_amount PO_LINES_ALL.amount%TYPE;
1789: l_qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE;
1790:
1791: GET_TIMECARD_AMOUNT_FAILED EXCEPTION;
1792: l_api_name CONSTANT varchar2(30) := 'Validate_Amount_Tolerances';

Line 2152: l_correction_amount po_lines_all.amount%TYPE;

2148: ( p_rti_rows IN OUT NOCOPY rti_table
2149: , p_attributes IN OUT NOCOPY TimecardAttributesRec
2150: , p_old_attributes IN OUT NOCOPY TimecardAttributesRec
2151: ) IS
2152: l_correction_amount po_lines_all.amount%TYPE;
2153: l_old_correction_amount po_lines_all.amount%TYPE;
2154: l_swap rcv_transactions_interface.interface_transaction_id%TYPE; /*Bug 6031665*/
2155: -- we need one correction for each parent transaction
2156: l_rcv_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;

Line 2153: l_old_correction_amount po_lines_all.amount%TYPE;

2149: , p_attributes IN OUT NOCOPY TimecardAttributesRec
2150: , p_old_attributes IN OUT NOCOPY TimecardAttributesRec
2151: ) IS
2152: l_correction_amount po_lines_all.amount%TYPE;
2153: l_old_correction_amount po_lines_all.amount%TYPE;
2154: l_swap rcv_transactions_interface.interface_transaction_id%TYPE; /*Bug 6031665*/
2155: -- we need one correction for each parent transaction
2156: l_rcv_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
2157: l_del_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;