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.OKC_CREATE_PO_FROM_K_PVT dependencies on OKC_K_HEADERS_B

Line 97: FROM okc_k_headers_b

93: contract_number || ' - ' || contract_number_modifier)
94: contract_number_print -- used to form the
95: -- comments in the PO Header
96: -- ,po_headers_s.NEXTVAL po_header_id
97: FROM okc_k_headers_b
98: WHERE id = b_chr_id;
99:
100:
101: -- cursor to get line information for the top lines related to the contract

Line 153: chr_id okc_k_headers_b.id%TYPE

149: -------------------------------------------------------------------------
150:
151: TYPE rule_rec_typ IS RECORD
152: (
153: chr_id okc_k_headers_b.id%TYPE
154: ,cle_id okc_k_lines_b.id%TYPE
155: ,object1_id1 okc_rules_b.object1_id1%TYPE
156: ,object1_id2 okc_rules_b.object1_id2%TYPE
157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE

Line 177: org_id okc_k_headers_b.authoring_org_id%type,

173: -------------------------------------------------------------------------
174:
175: TYPE po_header_rec_type IS RECORD(
176: interface_header_id po_headers_interface.interface_header_id%type,
177: org_id okc_k_headers_b.authoring_org_id%type,
178: document_type_code po_headers_interface.document_type_code%type,
179: document_num po_headers_interface.document_num%type,
180: po_header_id po_headers_interface.po_header_id%type,
181: currency_code okc_k_headers_b.currency_code%type,

Line 181: currency_code okc_k_headers_b.currency_code%type,

177: org_id okc_k_headers_b.authoring_org_id%type,
178: document_type_code po_headers_interface.document_type_code%type,
179: document_num po_headers_interface.document_num%type,
180: po_header_id po_headers_interface.po_header_id%type,
181: currency_code okc_k_headers_b.currency_code%type,
182: rate_type_code okc_conversion_attribs_v.conversion_type%type,
183: rate_date okc_conversion_attribs_v.conversion_date%type,
184: rate okc_conversion_attribs_v.conversion_rate%type,
185: agent_id okx_buyers_v.id1%type,

Line 193: approved_date okc_k_headers_b.date_signed%type,

189: ship_to_location_id okc_rules_b.object1_id1%type,
190: bill_to_location_id okc_rules_b.object1_id1%type,
191: terms_id okc_rules_b.object1_id1%type,
192: freight_terms okc_rules_b.object1_id1%type,
193: approved_date okc_k_headers_b.date_signed%type,
194: ship_to_organization_id okc_rules_b.object2_id1%type,
195: comments varchar2(100) -- used to form the comments
196: -- with the contract number
197: );

Line 238: org_id okc_k_headers_b.authoring_org_id%type,

234: TYPE po_distributions_rec_type IS RECORD(
235: interface_header_id po_headers_interface.interface_header_id%type,
236: interface_line_id po_lines_interface.interface_line_id%type,
237: interface_distribution_id po_distributions_interface.interface_distribution_id%type,
238: org_id okc_k_headers_b.authoring_org_id%type,
239: quantity_ordered okc_k_items.number_of_items%type,
240: charge_account_id po_distributions_interface.charge_account_id%TYPE
241: );
242:

Line 411: ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE

407: ,p_message_body_token2 IN VARCHAR2
408: ,p_message_body_token2_value IN VARCHAR2
409: ,p_message_body_token3 IN VARCHAR2
410: ,p_message_body_token3_value IN VARCHAR2
411: ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE
412: ,x_k_buyer_name OUT NOCOPY VARCHAR2
413: ,x_return_status OUT NOCOPY VARCHAR2
414: ,x_msg_count OUT NOCOPY NUMBER
415: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 650: PROCEDURE get_k_rules(p_chr_id IN okc_k_headers_b.ID%TYPE,

646: -- Note: QA check must ensure that the occurrence of any rule does not happen
647: -- more than once per header or line.
648: -------------------------------------------------------------------------------
649:
650: PROCEDURE get_k_rules(p_chr_id IN okc_k_headers_b.ID%TYPE,
651: p_cle_id IN okc_k_lines_v.id%TYPE,
652: px_po_header_rec IN OUT NOCOPY po_header_rec_type,
653: px_po_lines_rec IN OUT NOCOPY po_lines_rec_type,
654: x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 920: PROCEDURE get_k_info (p_chr_id IN okc_k_headers_b.ID%TYPE

916: -- x_po_lines_tab Table to hold po lines interface data
917: -- x_po_dist_tab Table to hold po distributions interface data
918: --------------------------------------------------------------------------------
919:
920: PROCEDURE get_k_info (p_chr_id IN okc_k_headers_b.ID%TYPE
921: ,x_return_status OUT NOCOPY VARCHAR2
922: ,x_po_header_rec OUT NOCOPY po_header_rec_type
923: ,x_po_lines_tab OUT NOCOPY po_lines_tab
924: ,x_po_dist_tab OUT NOCOPY po_distributions_tab) IS

Line 1455: PROCEDURE insert_po_lines(p_chr_id IN okc_k_headers_b.id%TYPE

1451: --
1452: -- Out Parameters: x_return_status Standard return status
1453: ----------------------------------------------------------------------------
1454:
1455: PROCEDURE insert_po_lines(p_chr_id IN okc_k_headers_b.id%TYPE
1456: ,p_po_lines_tab IN po_lines_tab
1457: ,p_po_header_id IN po_lines_all.po_header_id%TYPE
1458: ,x_return_status OUT NOCOPY VARCHAR2) IS
1459:

Line 1830: ,p_chr_id IN okc_k_headers_b.ID%TYPE

1826: ----------------------------------------------------------------------------------
1827:
1828: PROCEDURE create_po_from_k(p_api_version IN NUMBER
1829: ,p_init_msg_list IN VARCHAR2
1830: ,p_chr_id IN okc_k_headers_b.ID%TYPE
1831: ,x_return_status OUT NOCOPY VARCHAR2
1832: ,x_msg_count OUT NOCOPY NUMBER
1833: ,x_msg_data OUT NOCOPY VARCHAR2) IS
1834:

Line 2048: ,p_chr_id IN okc_k_headers_b.id%TYPE

2044:
2045: PROCEDURE tieback_related_objs_from_po(
2046: p_api_version IN NUMBER
2047: ,p_init_msg_list IN VARCHAR2
2048: ,p_chr_id IN okc_k_headers_b.id%TYPE
2049: ,x_po_number OUT NOCOPY VARCHAR2
2050: ,x_return_status OUT NOCOPY VARCHAR2
2051: ,x_msg_count OUT NOCOPY NUMBER
2052: ,x_msg_data OUT NOCOPY VARCHAR2