DBA Data[Home] [Help]

APPS.RCV_HXT_GRP dependencies on PO_DISTRIBUTIONS_ALL

Line 34: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%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
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

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

Line 36: , task_id PO_DISTRIBUTIONS_ALL.task_id%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
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

Line 121: ( po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE

117: , time_attribute_id HXC_TIME_ATTRIBUTES.time_attribute_id%TYPE
118: );
119:
120: TYPE po_distribution_cr IS RECORD
121: ( po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
122: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE
123: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE
124: );
125:

Line 122: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE

118: );
119:
120: TYPE po_distribution_cr IS RECORD
121: ( po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
122: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE
123: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE
124: );
125:
126: TYPE fnd_lookups_cr IS RECORD

Line 123: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE

119:
120: TYPE po_distribution_cr IS RECORD
121: ( po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
122: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE
123: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE
124: );
125:
126: TYPE fnd_lookups_cr IS RECORD
127: ( lookup_code FND_LOOKUPS.lookup_code%TYPE

Line 152: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE

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: , timecard_id RCV_TRANSACTIONS.timecard_id%TYPE
154: , timecard_ovn RCV_TRANSACTIONS.timecard_ovn%TYPE
155: );
156:

Line 699: , p_project_id IN PO_DISTRIBUTIONS_ALL.project_id%TYPE

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';
703: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 700: , p_task_id IN PO_DISTRIBUTIONS_ALL.task_id%TYPE

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';
703: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
704: BEGIN

Line 723: FROM po_distributions_all pod

719:
720: -- allocate all the amount to the first distribution that matches
721: SELECT MIN(pod.po_distribution_id)
722: INTO g_po_distribution_cache(p_po_line_id).po_distribution_id
723: FROM po_distributions_all pod
724: WHERE pod.po_line_id = p_po_line_id
725: AND pod.project_id = p_project_id
726: AND pod.task_id = p_task_id;
727:

Line 986: , p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE

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;
990: BEGIN