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_OC_INT_PUB dependencies on OKC_K_HEADERS_B

Line 42: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

38: PROCEDURE create_quote_for_renewal(p_init_msg_list IN VARCHAR2
39: ,x_return_status OUT NOCOPY VARCHAR2
40: ,x_msg_count OUT NOCOPY NUMBER
41: ,x_msg_data OUT NOCOPY VARCHAR2
42: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
43: ,p_trace_mode IN VARCHAR2
44: ) IS
45:
46: l_api_version CONSTANT NUMBER := 1;

Line 83: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE

79:
80: PROCEDURE create_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
81: ,RETCODE OUT NOCOPY NUMBER
82: --
83: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE
84: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
85: -- Contains in fact the contract ID
86: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE
87: ,p_trace_mode IN VARCHAR2

Line 84: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE

80: PROCEDURE create_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
81: ,RETCODE OUT NOCOPY NUMBER
82: --
83: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE
84: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
85: -- Contains in fact the contract ID
86: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE
87: ,p_trace_mode IN VARCHAR2
88: ) IS

Line 144: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER
142: ,x_msg_data OUT NOCOPY VARCHAR2
143: --
144: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
145: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE
146: --
147: ,p_trace_mode IN VARCHAR2
148: ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE

Line 282: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE

278:
279: PROCEDURE update_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
280: ,RETCODE OUT NOCOPY NUMBER
281: --
282: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
283: -- p_contract_number is in fact equal to contract ID
284: --
285: ,p_quote_number IN OKX_QUOTE_HEADERS_V.ID1%TYPE
286: -- p_quote_number is in fact equal to quote ID

Line 346: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

342: ,p_init_msg_list IN VARCHAR2
343: ,p_commit IN VARCHAR2
344: --
345: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE
346: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
347: --
348: ,p_trace_mode IN VARCHAR2
349: --
350: ,x_return_status OUT NOCOPY VARCHAR2

Line 502: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE

498:
499: PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
500: ,RETCODE OUT NOCOPY NUMBER
501: --
502: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE
503: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
504: -- Contains in fact the contract ID
505: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE
506: ,p_trace_mode IN VARCHAR2

Line 503: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE

499: PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
500: ,RETCODE OUT NOCOPY NUMBER
501: --
502: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE
503: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
504: -- Contains in fact the contract ID
505: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE
506: ,p_trace_mode IN VARCHAR2
507: ) IS

Line 563: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

559: ,x_return_status OUT NOCOPY VARCHAR2
560: ,x_msg_count OUT NOCOPY NUMBER
561: ,x_msg_data OUT NOCOPY VARCHAR2
562: --
563: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
564: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE
565: --
566: ,p_trace_mode IN VARCHAR2
567: ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE

Line 706: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE

702: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
703: PROCEDURE create_k_from_quote(ERRBUF OUT NOCOPY VARCHAR2
704: ,RETCODE OUT NOCOPY NUMBER
705: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
706: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE
707: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
708: ,p_template_version IN NUMBER
709: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE
710: ,p_trace_mode IN VARCHAR2

Line 707: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE

703: PROCEDURE create_k_from_quote(ERRBUF OUT NOCOPY VARCHAR2
704: ,RETCODE OUT NOCOPY NUMBER
705: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
706: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE
707: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
708: ,p_template_version IN NUMBER
709: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE
710: ,p_trace_mode IN VARCHAR2
711: ) IS

Line 714: lx_contract_id okc_k_headers_b.id%TYPE := NULL;

710: ,p_trace_mode IN VARCHAR2
711: ) IS
712:
713: l_api_version CONSTANT NUMBER := 1;
714: lx_contract_id okc_k_headers_b.id%TYPE := NULL;
715: lx_contract_number VARCHAR2(1000) := NULL;
716: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
717: lx_msg_count NUMBER := 0;
718: lx_msg_data VARCHAR2(2000);

Line 774: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE

770: PROCEDURE create_k_from_quote(p_api_version IN NUMBER
771: ,p_init_msg_list IN VARCHAR2
772: ,p_commit IN VARCHAR2
773: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
774: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
775: ,p_template_version IN NUMBER
776: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
777: ,p_terms_agreed_flag IN VARCHAR2
778: ,p_trace_mode IN VARCHAR2

Line 779: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE

775: ,p_template_version IN NUMBER
776: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
777: ,p_terms_agreed_flag IN VARCHAR2
778: ,p_trace_mode IN VARCHAR2
779: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
780: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
781: ,x_return_status OUT NOCOPY VARCHAR2
782: ,x_msg_count OUT NOCOPY NUMBER
783: ,x_msg_data OUT NOCOPY VARCHAR2

Line 780: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

776: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
777: ,p_terms_agreed_flag IN VARCHAR2
778: ,p_trace_mode IN VARCHAR2
779: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
780: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
781: ,x_return_status OUT NOCOPY VARCHAR2
782: ,x_msg_count OUT NOCOPY NUMBER
783: ,x_msg_data OUT NOCOPY VARCHAR2
784: ) IS

Line 903: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE

899: PROCEDURE create_k_from_quote(p_api_version IN NUMBER
900: ,p_init_msg_list IN VARCHAR2
901: ,p_commit IN VARCHAR2
902: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
903: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
904: ,p_template_version IN NUMBER
905: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
906: ,p_trace_mode IN VARCHAR2
907: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE

Line 907: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE

903: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
904: ,p_template_version IN NUMBER
905: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
906: ,p_trace_mode IN VARCHAR2
907: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
908: ,x_return_status OUT NOCOPY VARCHAR2
909: ,x_msg_count OUT NOCOPY NUMBER
910: ,x_msg_data OUT NOCOPY VARCHAR2
911: ) IS

Line 916: x_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

912:
913: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_K_FROM_Q';
914: l_api_version CONSTANT NUMBER := 1;
915:
916: x_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
917:
918: BEGIN
919:
920: -- call the main routine

Line 946: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE

942:
943: PROCEDURE create_k_relationships(p_api_version IN NUMBER
944: ,p_init_msg_list IN VARCHAR2
945: ,p_commit IN VARCHAR2
946: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE
947: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE
948: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
949: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB
950: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE

Line 947: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE

943: PROCEDURE create_k_relationships(p_api_version IN NUMBER
944: ,p_init_msg_list IN VARCHAR2
945: ,p_commit IN VARCHAR2
946: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE
947: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE
948: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
949: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB
950: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE
951: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB

Line 1255: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

1251: ,p_message_body_token2_value IN VARCHAR2
1252: ,p_message_body_token3 IN VARCHAR2
1253: ,p_message_body_token3_value IN VARCHAR2
1254: ,p_trace_mode IN VARCHAR2
1255: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
1256: ,x_k_admin_user_name OUT NOCOPY VARCHAR2
1257: ,x_return_status OUT NOCOPY VARCHAR2
1258: ,x_msg_count OUT NOCOPY NUMBER
1259: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1513: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE

1509: ,p_init_msg_list IN VARCHAR2
1510: ,p_commit IN VARCHAR2
1511: ,p_contract_id IN NUMBER
1512: ,p_trace_mode IN VARCHAR2
1513: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
1514: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
1515: ,x_return_status OUT NOCOPY VARCHAR2
1516: ,x_msg_count OUT NOCOPY NUMBER
1517: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1514: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE

1510: ,p_commit IN VARCHAR2
1511: ,p_contract_id IN NUMBER
1512: ,p_trace_mode IN VARCHAR2
1513: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
1514: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
1515: ,x_return_status OUT NOCOPY VARCHAR2
1516: ,x_msg_count OUT NOCOPY NUMBER
1517: ,x_msg_data OUT NOCOPY VARCHAR2) IS
1518:

Line 1759: lx_contract_number OKC_K_HEADERS_B.contract_number%TYPE; -- new contract number

1755: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1756: lx_msg_count NUMBER := 0;
1757: lx_msg_data VARCHAR2(50) := 'msg';
1758:
1759: lx_contract_number OKC_K_HEADERS_B.contract_number%TYPE; -- new contract number
1760: lx_contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE; -- new contract number modifier
1761: lx_k_admin_user_name FND_USER.user_name%TYPE;
1762:
1763: BEGIN

Line 1760: lx_contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE; -- new contract number modifier

1756: lx_msg_count NUMBER := 0;
1757: lx_msg_data VARCHAR2(50) := 'msg';
1758:
1759: lx_contract_number OKC_K_HEADERS_B.contract_number%TYPE; -- new contract number
1760: lx_contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE; -- new contract number modifier
1761: lx_k_admin_user_name FND_USER.user_name%TYPE;
1762:
1763: BEGIN
1764: