25: |-------------------------------------------------------------------------------------*/
26:
27:
28: TYPE pym_rec_type IS RECORD (
29: RULE_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM,
30: STUB_DAYS OKC_RULES_V.RULE_INFORMATION7%TYPE := OKL_API.G_MISS_CHAR,
31: STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
32: PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
33: AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
26:
27:
28: TYPE pym_rec_type IS RECORD (
29: RULE_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM,
30: STUB_DAYS OKC_RULES_V.RULE_INFORMATION7%TYPE := OKL_API.G_MISS_CHAR,
31: STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
32: PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
33: AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
34: SORT_DATE OKC_RULES_V.RULE_INFORMATION2%TYPE := OKL_API.G_MISS_CHAR,
27:
28: TYPE pym_rec_type IS RECORD (
29: RULE_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM,
30: STUB_DAYS OKC_RULES_V.RULE_INFORMATION7%TYPE := OKL_API.G_MISS_CHAR,
31: STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
32: PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
33: AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
34: SORT_DATE OKC_RULES_V.RULE_INFORMATION2%TYPE := OKL_API.G_MISS_CHAR,
35: UPDATE_TYPE VARCHAR2(20) := OKL_API.G_MISS_CHAR
28: TYPE pym_rec_type IS RECORD (
29: RULE_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM,
30: STUB_DAYS OKC_RULES_V.RULE_INFORMATION7%TYPE := OKL_API.G_MISS_CHAR,
31: STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
32: PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
33: AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
34: SORT_DATE OKC_RULES_V.RULE_INFORMATION2%TYPE := OKL_API.G_MISS_CHAR,
35: UPDATE_TYPE VARCHAR2(20) := OKL_API.G_MISS_CHAR
36: );
29: RULE_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM,
30: STUB_DAYS OKC_RULES_V.RULE_INFORMATION7%TYPE := OKL_API.G_MISS_CHAR,
31: STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
32: PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
33: AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
34: SORT_DATE OKC_RULES_V.RULE_INFORMATION2%TYPE := OKL_API.G_MISS_CHAR,
35: UPDATE_TYPE VARCHAR2(20) := OKL_API.G_MISS_CHAR
36: );
37:
30: STUB_DAYS OKC_RULES_V.RULE_INFORMATION7%TYPE := OKL_API.G_MISS_CHAR,
31: STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
32: PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
33: AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
34: SORT_DATE OKC_RULES_V.RULE_INFORMATION2%TYPE := OKL_API.G_MISS_CHAR,
35: UPDATE_TYPE VARCHAR2(20) := OKL_API.G_MISS_CHAR
36: );
37:
38:
31: STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
32: PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
33: AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
34: SORT_DATE OKC_RULES_V.RULE_INFORMATION2%TYPE := OKL_API.G_MISS_CHAR,
35: UPDATE_TYPE VARCHAR2(20) := OKL_API.G_MISS_CHAR
36: );
37:
38:
39: TYPE pym_del_rec_type IS RECORD (
36: );
37:
38:
39: TYPE pym_del_rec_type IS RECORD (
40: CHR_ID OKC_K_HEADERS_B.ID%TYPE := OKL_API.G_MISS_NUM,
41: RGP_ID OKC_RULES_V.RGP_ID%TYPE := OKL_API.G_MISS_NUM,
42: SLH_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM
43: );
44:
37:
38:
39: TYPE pym_del_rec_type IS RECORD (
40: CHR_ID OKC_K_HEADERS_B.ID%TYPE := OKL_API.G_MISS_NUM,
41: RGP_ID OKC_RULES_V.RGP_ID%TYPE := OKL_API.G_MISS_NUM,
42: SLH_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM
43: );
44:
45: TYPE pym_hdr_rec_type IS RECORD (
38:
39: TYPE pym_del_rec_type IS RECORD (
40: CHR_ID OKC_K_HEADERS_B.ID%TYPE := OKL_API.G_MISS_NUM,
41: RGP_ID OKC_RULES_V.RGP_ID%TYPE := OKL_API.G_MISS_NUM,
42: SLH_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM
43: );
44:
45: TYPE pym_hdr_rec_type IS RECORD (
46: STRUCTURE VARCHAR2(1) DEFAULT NULL,
43: );
44:
45: TYPE pym_hdr_rec_type IS RECORD (
46: STRUCTURE VARCHAR2(1) DEFAULT NULL,
47: STRUCTURE_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
48: FREQUENCY VARCHAR2(1) DEFAULT NULL,
49: FREQUENCY_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
50: ARREARS VARCHAR2(1) DEFAULT NULL,
51: ARREARS_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR
45: TYPE pym_hdr_rec_type IS RECORD (
46: STRUCTURE VARCHAR2(1) DEFAULT NULL,
47: STRUCTURE_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
48: FREQUENCY VARCHAR2(1) DEFAULT NULL,
49: FREQUENCY_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
50: ARREARS VARCHAR2(1) DEFAULT NULL,
51: ARREARS_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR
52: );
53:
47: STRUCTURE_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
48: FREQUENCY VARCHAR2(1) DEFAULT NULL,
49: FREQUENCY_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
50: ARREARS VARCHAR2(1) DEFAULT NULL,
51: ARREARS_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR
52: );
53:
54:
55: TYPE pym_tbl_type IS TABLE OF pym_rec_type INDEX BY BINARY_INTEGER;
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
71: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
72: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
73: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
74: p_pym_hdr_rec IN pym_hdr_rec_type,
75: p_pym_tbl IN pym_tbl_type,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
71: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
72: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
73: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
74: p_pym_hdr_rec IN pym_hdr_rec_type,
75: p_pym_tbl IN pym_tbl_type,
76: p_update_type IN VARCHAR2 DEFAULT 'UPDATE',
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
87: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
88: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
89: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
90: p_update_type IN VARCHAR2,
91: x_rulv_tbl OUT NOCOPY rulv_tbl_type);
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
87: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
88: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
89: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
90: p_update_type IN VARCHAR2,
91: x_rulv_tbl OUT NOCOPY rulv_tbl_type);
92: