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.OKL_OPEN_INTERFACE_PVT dependencies on OKX_PARTIES_V

Line 2513: -- It validates customer against database, OKX_PARTIES_V

2509: END check_line_literal;
2510:
2511: ------------------------------------------------------------------------------
2512: -- FUNCTION validate_customer
2513: -- It validates customer against database, OKX_PARTIES_V
2514: -- Returns OKL_API.G_RET_STS_ERROR for unknown customer
2515: -- OKL_API.G_RET_STS_SUCCESS for existing customer
2516: -- Also outputs ID1 for corresponding Customer
2517: -- Calls:

Line 2524: p_customer_id IN OKX_PARTIES_V.ID1%TYPE,

2520: -- check_input_record
2521: ------------------------------------------------------------------------------
2522:
2523: FUNCTION validate_customer (p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
2524: p_customer_id IN OKX_PARTIES_V.ID1%TYPE,
2525: p_customer_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,
2526: x_id1 OUT NOCOPY OKX_PARTIES_V.ID1%TYPE)
2527: RETURN VARCHAR2 IS
2528:

Line 2525: p_customer_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,

2521: ------------------------------------------------------------------------------
2522:
2523: FUNCTION validate_customer (p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
2524: p_customer_id IN OKX_PARTIES_V.ID1%TYPE,
2525: p_customer_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,
2526: x_id1 OUT NOCOPY OKX_PARTIES_V.ID1%TYPE)
2527: RETURN VARCHAR2 IS
2528:
2529: CURSOR customer_csr (p_customer_id OKX_PARTIES_V.ID1%TYPE,

Line 2526: x_id1 OUT NOCOPY OKX_PARTIES_V.ID1%TYPE)

2522:
2523: FUNCTION validate_customer (p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
2524: p_customer_id IN OKX_PARTIES_V.ID1%TYPE,
2525: p_customer_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,
2526: x_id1 OUT NOCOPY OKX_PARTIES_V.ID1%TYPE)
2527: RETURN VARCHAR2 IS
2528:
2529: CURSOR customer_csr (p_customer_id OKX_PARTIES_V.ID1%TYPE,
2530: p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE) IS

Line 2529: CURSOR customer_csr (p_customer_id OKX_PARTIES_V.ID1%TYPE,

2525: p_customer_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,
2526: x_id1 OUT NOCOPY OKX_PARTIES_V.ID1%TYPE)
2527: RETURN VARCHAR2 IS
2528:
2529: CURSOR customer_csr (p_customer_id OKX_PARTIES_V.ID1%TYPE,
2530: p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE) IS
2531: SELECT id1
2532: FROM okx_parties_v
2533: WHERE NVL(TRUNC(end_date_active), TRUNC(SYSDATE)) >= TRUNC(SYSDATE)

Line 2530: p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE) IS

2526: x_id1 OUT NOCOPY OKX_PARTIES_V.ID1%TYPE)
2527: RETURN VARCHAR2 IS
2528:
2529: CURSOR customer_csr (p_customer_id OKX_PARTIES_V.ID1%TYPE,
2530: p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE) IS
2531: SELECT id1
2532: FROM okx_parties_v
2533: WHERE NVL(TRUNC(end_date_active), TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
2534: AND ((id1 = p_customer_id

Line 2532: FROM okx_parties_v

2528:
2529: CURSOR customer_csr (p_customer_id OKX_PARTIES_V.ID1%TYPE,
2530: p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE) IS
2531: SELECT id1
2532: FROM okx_parties_v
2533: WHERE NVL(TRUNC(end_date_active), TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
2534: AND ((id1 = p_customer_id
2535: AND p_customer_id IS NOT NULL)
2536: OR

Line 3055: l_customer_id okx_parties_v.id1%TYPE;

3051:
3052: l_proc_name VARCHAR2(35) := NULL;
3053: l_progress VARCHAR2(3) := NULL;
3054: l_contract_number_old okl_header_interface.contract_number_old%TYPE;
3055: l_customer_id okx_parties_v.id1%TYPE;
3056: l_record_status VARCHAR2(3);
3057: l_batch_status VARCHAR2(3);
3058: x_id1 NUMBER;
3059:

Line 3987: p_party_id IN OKX_PARTIES_V.ID1%TYPE,

3983: x_msg_count OUT NOCOPY NUMBER,
3984: x_msg_data OUT NOCOPY VARCHAR2,
3985: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
3986: p_line_number IN okl_lines_interface.line_number%TYPE,
3987: p_party_id IN OKX_PARTIES_V.ID1%TYPE,
3988: p_party_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,
3989: x_party_id OUT NOCOPY NUMBER
3990: ) IS
3991:

Line 3988: p_party_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,

3984: x_msg_data OUT NOCOPY VARCHAR2,
3985: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
3986: p_line_number IN okl_lines_interface.line_number%TYPE,
3987: p_party_id IN OKX_PARTIES_V.ID1%TYPE,
3988: p_party_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,
3989: x_party_id OUT NOCOPY NUMBER
3990: ) IS
3991:
3992: CURSOR party_csr (p_party_number VARCHAR2,

Line 3995: FROM okx_parties_v

3991:
3992: CURSOR party_csr (p_party_number VARCHAR2,
3993: p_party_id NUMBER) IS
3994: SELECT id1
3995: FROM okx_parties_v
3996: WHERE ((party_number = p_party_number
3997: AND
3998: p_party_number IS NOT NULL)
3999: OR

Line 4217: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,

4213: p_customer_number IN okl_header_interface.customer_number%TYPE,
4214: p_authoring_org_id IN okl_header_interface.authoring_org_id%TYPE,
4215: x_cplv_rec OUT NOCOPY cplv_rec_type ) IS
4216:
4217: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
4218: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
4219: SELECT id1
4220: FROM okx_parties_v
4221: WHERE ((party_number = p_customer_number

Line 4218: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS

4214: p_authoring_org_id IN okl_header_interface.authoring_org_id%TYPE,
4215: x_cplv_rec OUT NOCOPY cplv_rec_type ) IS
4216:
4217: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
4218: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
4219: SELECT id1
4220: FROM okx_parties_v
4221: WHERE ((party_number = p_customer_number
4222: AND

Line 4220: FROM okx_parties_v

4216:
4217: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
4218: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
4219: SELECT id1
4220: FROM okx_parties_v
4221: WHERE ((party_number = p_customer_number
4222: AND
4223: p_customer_number IS NOT NULL
4224: )

Line 4232: l_id1 okx_parties_v.id1%TYPE;

4228: p_customer_id IS NOT NULL
4229: )
4230: );
4231:
4232: l_id1 okx_parties_v.id1%TYPE;
4233: l_proc_name VARCHAR2(35) := 'CREATE_PARTY_ROLE';
4234: party_role_failed EXCEPTION;
4235: p_cplv_rec cplv_rec_type;
4236: l_kplv_rec kplv_rec_type;

Line 7559: FROM okx_parties_v

7555: RETURN VARCHAR2 IS
7556: CURSOR lien_csr (p_id NUMBER,
7557: p_name VARCHAR2) IS
7558: SELECT id1
7559: FROM okx_parties_v
7560: WHERE ((name = p_name
7561: AND
7562: p_name IS NOT NULL)
7563: OR

Line 18610: FROM okx_parties_v

18606:
18607: CURSOR party_csr (p_private_label_number VARCHAR2,
18608: p_private_label_id NUMBER) IS
18609: SELECT id1
18610: FROM okx_parties_v
18611: WHERE ((party_number = p_private_label_number
18612: AND
18613: p_private_label_number IS NOT NULL)
18614: OR

Line 19223: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,

19219: x_payment_term_id1 VARCHAR2(240);
19220: x_pay_site_id1 VARCHAR2(240);
19221: x_payment_method_id1 VARCHAR2(240);
19222:
19223: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
19224: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
19225: SELECT id1
19226: FROM okx_parties_v
19227: WHERE ((party_number = p_customer_number

Line 19224: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS

19220: x_pay_site_id1 VARCHAR2(240);
19221: x_payment_method_id1 VARCHAR2(240);
19222:
19223: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
19224: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
19225: SELECT id1
19226: FROM okx_parties_v
19227: WHERE ((party_number = p_customer_number
19228: AND

Line 19226: FROM okx_parties_v

19222:
19223: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
19224: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
19225: SELECT id1
19226: FROM okx_parties_v
19227: WHERE ((party_number = p_customer_number
19228: AND
19229: p_customer_number IS NOT NULL
19230: )

Line 24704: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,

24700: p_start_date IN OKL_HEADER_INTERFACE.START_DATE%TYPE,
24701: p_template_start_date IN OKL_HEADER_INTERFACE.START_DATE%TYPE
24702: ) IS
24703:
24704: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
24705: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
24706: SELECT id1
24707: FROM okx_parties_v
24708: WHERE ((party_number = p_customer_number

Line 24705: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS

24701: p_template_start_date IN OKL_HEADER_INTERFACE.START_DATE%TYPE
24702: ) IS
24703:
24704: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
24705: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
24706: SELECT id1
24707: FROM okx_parties_v
24708: WHERE ((party_number = p_customer_number
24709: AND

Line 24707: FROM okx_parties_v

24703:
24704: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
24705: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
24706: SELECT id1
24707: FROM okx_parties_v
24708: WHERE ((party_number = p_customer_number
24709: AND
24710: p_customer_number IS NOT NULL
24711: )

Line 24745: l_customer_id OKX_PARTIES_V.ID1%TYPE;

24741: FROM okc_k_headers_v
24742: WHERE id = p_chr_id
24743: AND end_date >= p_main_start_date;
24744:
24745: l_customer_id OKX_PARTIES_V.ID1%TYPE;
24746: l_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24747: l_credit_customer_id OKX_PARTIES_V.ID1%TYPE;
24748: l_credit_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24749: l_rule_count NUMBER;

Line 24747: l_credit_customer_id OKX_PARTIES_V.ID1%TYPE;

24743: AND end_date >= p_main_start_date;
24744:
24745: l_customer_id OKX_PARTIES_V.ID1%TYPE;
24746: l_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24747: l_credit_customer_id OKX_PARTIES_V.ID1%TYPE;
24748: l_credit_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24749: l_rule_count NUMBER;
24750: l_rulv_tbl rulv_tbl_type;
24751: l_ok VARCHAR2(1) := '?';

Line 25410: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,

25406: -- l_qcl_id NUMBER;
25407: x_program_agreement_id OKC_K_HEADERS_V.ID%TYPE;
25408: x_product_id NUMBER;
25409:
25410: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
25411: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
25412: SELECT id1
25413: FROM okx_parties_v
25414: WHERE ((party_number = p_customer_number

Line 25411: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS

25407: x_program_agreement_id OKC_K_HEADERS_V.ID%TYPE;
25408: x_product_id NUMBER;
25409:
25410: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
25411: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
25412: SELECT id1
25413: FROM okx_parties_v
25414: WHERE ((party_number = p_customer_number
25415: AND

Line 25413: FROM okx_parties_v

25409:
25410: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
25411: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS
25412: SELECT id1
25413: FROM okx_parties_v
25414: WHERE ((party_number = p_customer_number
25415: AND
25416: p_customer_number IS NOT NULL
25417: )

Line 25425: l_id1 OKX_PARTIES_V.ID1%TYPE;

25421: p_customer_id IS NOT NULL
25422: )
25423: );
25424:
25425: l_id1 OKX_PARTIES_V.ID1%TYPE;
25426: x_customer_account_id NUMBER;
25427: x_bill_to_address_id NUMBER;
25428: pop_header_failed EXCEPTION;
25429: