DBA Data[Home] [Help]

APPS.OKL_POOL_PVT dependencies on OKC_K_HEADERS_B

Line 88: ,DNZ_CHR_ID OKC_K_HEADERS_B.ID%TYPE := NULL --NUMBER

84: TYPE polsrch_rec_type IS RECORD (
85: CUST_OBJECT1_ID1 hz_parties.PARTY_ID%TYPE := NULL --NUMBER(15)
86: ,LESSEE hz_parties.PARTY_NAME%TYPE := NULL --VARCHAR2(360)
87: ,SIC_CODE hz_parties.SIC_CODE%TYPE := NULL --VARCHAR2(30)
88: ,DNZ_CHR_ID OKC_K_HEADERS_B.ID%TYPE := NULL --NUMBER
89: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL --VARCHAR2(120)
90: ,PRE_TAX_YIELD_FROM OKL_K_HEADERS.PRE_TAX_YIELD%TYPE := NULL--NUMBER
91: ,PRE_TAX_YIELD_TO OKL_K_HEADERS.PRE_TAX_YIELD%TYPE := NULL--NUMBER
92: ,BOOK_CLASSIFICATION OKL_K_HEADERS.DEAL_TYPE%TYPE := NULL --VARCHAR2(30)

Line 89: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL --VARCHAR2(120)

85: CUST_OBJECT1_ID1 hz_parties.PARTY_ID%TYPE := NULL --NUMBER(15)
86: ,LESSEE hz_parties.PARTY_NAME%TYPE := NULL --VARCHAR2(360)
87: ,SIC_CODE hz_parties.SIC_CODE%TYPE := NULL --VARCHAR2(30)
88: ,DNZ_CHR_ID OKC_K_HEADERS_B.ID%TYPE := NULL --NUMBER
89: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL --VARCHAR2(120)
90: ,PRE_TAX_YIELD_FROM OKL_K_HEADERS.PRE_TAX_YIELD%TYPE := NULL--NUMBER
91: ,PRE_TAX_YIELD_TO OKL_K_HEADERS.PRE_TAX_YIELD%TYPE := NULL--NUMBER
92: ,BOOK_CLASSIFICATION OKL_K_HEADERS.DEAL_TYPE%TYPE := NULL --VARCHAR2(30)
93: ,PDT_ID OKL_K_HEADERS.PDT_ID%TYPE := NULL--NUMBER

Line 94: ,START_FROM_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE

90: ,PRE_TAX_YIELD_FROM OKL_K_HEADERS.PRE_TAX_YIELD%TYPE := NULL--NUMBER
91: ,PRE_TAX_YIELD_TO OKL_K_HEADERS.PRE_TAX_YIELD%TYPE := NULL--NUMBER
92: ,BOOK_CLASSIFICATION OKL_K_HEADERS.DEAL_TYPE%TYPE := NULL --VARCHAR2(30)
93: ,PDT_ID OKL_K_HEADERS.PDT_ID%TYPE := NULL--NUMBER
94: ,START_FROM_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
95: ,START_TO_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
96: ,END_FROM_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
97: ,END_TO_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
98: ,OPERATING_UNIT OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL--NUMBER

Line 95: ,START_TO_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE

91: ,PRE_TAX_YIELD_TO OKL_K_HEADERS.PRE_TAX_YIELD%TYPE := NULL--NUMBER
92: ,BOOK_CLASSIFICATION OKL_K_HEADERS.DEAL_TYPE%TYPE := NULL --VARCHAR2(30)
93: ,PDT_ID OKL_K_HEADERS.PDT_ID%TYPE := NULL--NUMBER
94: ,START_FROM_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
95: ,START_TO_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
96: ,END_FROM_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
97: ,END_TO_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
98: ,OPERATING_UNIT OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL--NUMBER
99: ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := NULL --VARCHAR2(15)

Line 96: ,END_FROM_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE

92: ,BOOK_CLASSIFICATION OKL_K_HEADERS.DEAL_TYPE%TYPE := NULL --VARCHAR2(30)
93: ,PDT_ID OKL_K_HEADERS.PDT_ID%TYPE := NULL--NUMBER
94: ,START_FROM_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
95: ,START_TO_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
96: ,END_FROM_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
97: ,END_TO_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
98: ,OPERATING_UNIT OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL--NUMBER
99: ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := NULL --VARCHAR2(15)
100: ,TAX_OWNER okc_rules_b.RULE_INFORMATION1%TYPE := NULL --VARCHAR2(450)

Line 97: ,END_TO_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE

93: ,PDT_ID OKL_K_HEADERS.PDT_ID%TYPE := NULL--NUMBER
94: ,START_FROM_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
95: ,START_TO_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
96: ,END_FROM_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
97: ,END_TO_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
98: ,OPERATING_UNIT OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL--NUMBER
99: ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := NULL --VARCHAR2(15)
100: ,TAX_OWNER okc_rules_b.RULE_INFORMATION1%TYPE := NULL --VARCHAR2(450)
101: ,KLE_ID okc_k_lines_b.ID%TYPE := NULL--NUMBER

Line 98: ,OPERATING_UNIT OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL--NUMBER

94: ,START_FROM_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
95: ,START_TO_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
96: ,END_FROM_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
97: ,END_TO_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
98: ,OPERATING_UNIT OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL--NUMBER
99: ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := NULL --VARCHAR2(15)
100: ,TAX_OWNER okc_rules_b.RULE_INFORMATION1%TYPE := NULL --VARCHAR2(450)
101: ,KLE_ID okc_k_lines_b.ID%TYPE := NULL--NUMBER
102: ,ASSET_ID okx_assets_v.ASSET_ID%TYPE := NULL--NUMBER(15)

Line 99: ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := NULL --VARCHAR2(15)

95: ,START_TO_DATE OKC_K_HEADERS_B.START_DATE%TYPE := NULL --DATE
96: ,END_FROM_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
97: ,END_TO_DATE OKC_K_HEADERS_B.END_DATE%TYPE := NULL --DATE
98: ,OPERATING_UNIT OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL--NUMBER
99: ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := NULL --VARCHAR2(15)
100: ,TAX_OWNER okc_rules_b.RULE_INFORMATION1%TYPE := NULL --VARCHAR2(450)
101: ,KLE_ID okc_k_lines_b.ID%TYPE := NULL--NUMBER
102: ,ASSET_ID okx_assets_v.ASSET_ID%TYPE := NULL--NUMBER(15)
103: ,ASSET_NUMBER okx_assets_v.ASSET_NUMBER%TYPE := NULL --VARCHAR2(15)

Line 456: ,p_khr_id IN okc_k_headers_b.id%TYPE

452: ,x_return_status OUT NOCOPY VARCHAR2
453: ,x_msg_count OUT NOCOPY NUMBER
454: ,x_msg_data OUT NOCOPY VARCHAR2
455: ,x_value OUT NOCOPY NUMBER
456: ,p_khr_id IN okc_k_headers_b.id%TYPE
457: );
458: ----------------------------------------------------------------------------------
459: -- Start of comments
460: --

Line 509: ,p_khr_id IN okc_k_headers_b.id%TYPE

505: ,x_return_status OUT NOCOPY VARCHAR2
506: ,x_msg_count OUT NOCOPY NUMBER
507: ,x_msg_data OUT NOCOPY VARCHAR2
508: ,x_value OUT NOCOPY NUMBER
509: ,p_khr_id IN okc_k_headers_b.id%TYPE
510: );
511:
512: ----------------------------------------------------------------------------------
513: -- Start of comments