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_COPY_CONTRACT_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 9: TYPE l_phid_mapping_type IS RECORD (old_id okl_party_payment_hdr.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_party_payment_hdr.id%TYPE := OKC_API.G_MISS_NUM);

5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7: --subtypes declared here to facilitate rosetta skip okc_rule_pub compilation
8: --which has a clob in it
9: TYPE l_phid_mapping_type IS RECORD (old_id okl_party_payment_hdr.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_party_payment_hdr.id%TYPE := OKC_API.G_MISS_NUM);
10: TYPE l_phid_mapping_tab_type IS TABLE OF l_phid_mapping_type INDEX BY BINARY_INTEGER;
11:
12: SUBTYPE api_components_rec_okc is OKC_COPY_CONTRACT_PVT.api_components_rec;
13: SUBTYPE api_components_tbl_okc is OKC_COPY_CONTRACT_PVT.api_components_tbl;

Line 1048: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR_V

1044: --Bug# : 3143522
1045:
1046: --furong 4350255
1047: ---------------------------------------------------------------------------
1048: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR_V
1049: ---------------------------------------------------------------------------
1050: FUNCTION get_pphv_rec (
1051: p_pphv_rec IN pphv_rec_type,
1052: x_no_data_found OUT NOCOPY BOOLEAN

Line 1054: CURSOR okl_party_payment_hdr_v_pk_csr (p_id IN NUMBER) IS

1050: FUNCTION get_pphv_rec (
1051: p_pphv_rec IN pphv_rec_type,
1052: x_no_data_found OUT NOCOPY BOOLEAN
1053: ) RETURN pphv_rec_type IS
1054: CURSOR okl_party_payment_hdr_v_pk_csr (p_id IN NUMBER) IS
1055: SELECT
1056: ID,
1057: OBJECT_VERSION_NUMBER,
1058: DNZ_CHR_ID,

Line 1073: FROM Okl_Party_Payment_Hdr_V

1069: CREATION_DATE,
1070: LAST_UPDATED_BY,
1071: LAST_UPDATE_DATE,
1072: LAST_UPDATE_LOGIN
1073: FROM Okl_Party_Payment_Hdr_V
1074: WHERE okl_party_payment_hdr_v.id = p_id;
1075: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
1076: l_pphv_rec pphv_rec_type;
1077: BEGIN

Line 1074: WHERE okl_party_payment_hdr_v.id = p_id;

1070: LAST_UPDATED_BY,
1071: LAST_UPDATE_DATE,
1072: LAST_UPDATE_LOGIN
1073: FROM Okl_Party_Payment_Hdr_V
1074: WHERE okl_party_payment_hdr_v.id = p_id;
1075: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
1076: l_pphv_rec pphv_rec_type;
1077: BEGIN
1078: x_no_data_found := TRUE;

Line 1075: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;

1071: LAST_UPDATE_DATE,
1072: LAST_UPDATE_LOGIN
1073: FROM Okl_Party_Payment_Hdr_V
1074: WHERE okl_party_payment_hdr_v.id = p_id;
1075: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
1076: l_pphv_rec pphv_rec_type;
1077: BEGIN
1078: x_no_data_found := TRUE;
1079: -- Get current database values

Line 1080: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);

1076: l_pphv_rec pphv_rec_type;
1077: BEGIN
1078: x_no_data_found := TRUE;
1079: -- Get current database values
1080: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);
1081: FETCH okl_party_payment_hdr_v_pk_csr INTO
1082: l_pphv_rec.id,
1083: l_pphv_rec.object_version_number,
1084: l_pphv_rec.dnz_chr_id,

Line 1081: FETCH okl_party_payment_hdr_v_pk_csr INTO

1077: BEGIN
1078: x_no_data_found := TRUE;
1079: -- Get current database values
1080: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);
1081: FETCH okl_party_payment_hdr_v_pk_csr INTO
1082: l_pphv_rec.id,
1083: l_pphv_rec.object_version_number,
1084: l_pphv_rec.dnz_chr_id,
1085: l_pphv_rec.cle_id,

Line 1099: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;

1095: l_pphv_rec.creation_date,
1096: l_pphv_rec.last_updated_by,
1097: l_pphv_rec.last_update_date,
1098: l_pphv_rec.last_update_login;
1099: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;
1100: CLOSE okl_party_payment_hdr_v_pk_csr;
1101: RETURN(l_pphv_rec);
1102: END get_pphv_rec;
1103: ------------------------------------------------------------------

Line 1100: CLOSE okl_party_payment_hdr_v_pk_csr;

1096: l_pphv_rec.last_updated_by,
1097: l_pphv_rec.last_update_date,
1098: l_pphv_rec.last_update_login;
1099: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;
1100: CLOSE okl_party_payment_hdr_v_pk_csr;
1101: RETURN(l_pphv_rec);
1102: END get_pphv_rec;
1103: ------------------------------------------------------------------
1104: -- This version of get_rec sets error messages if no data found --

Line 3357: FROM okl_party_payment_hdr

3353:
3354: --furong 4350255, find out the hdr id for a cle id --
3355: CURSOR hdr_exist_csr (p_chr_id NUMBER, p_cle_id NUMBER) IS
3356: SELECT id
3357: FROM okl_party_payment_hdr
3358: WHERE dnz_chr_id = p_chr_id
3359: AND cle_id = p_cle_id;
3360:
3361: l_old_hdr_id NUMBER;

Line 3370: FROM okl_party_payment_hdr

3366: SELECT id
3367: FROM okl_party_payment_dtls
3368: WHERE payment_hdr_id IN
3369: (SELECT id
3370: FROM okl_party_payment_hdr
3371: WHERE dnz_chr_id = p_chr_id
3372: AND cle_id = p_cle_id);
3373:
3374: --l_old_hdr_id NUMBER;

Line 3394: okl_party_payment_hdr hdr

3390: cpl_new.id cpl_id
3391: from okl_party_payment_dtls pyd_old,
3392: okc_k_party_roles_b cpl_old,
3393: okc_k_party_roles_b cpl_new,
3394: okl_party_payment_hdr hdr
3395: where pyd_old.cpl_id = cpl_old.id
3396: and cpl_old.cle_id = p_old_cle_id
3397: and cpl_old.dnz_chr_id = p_old_chr_id
3398: and cpl_new.cle_id = p_new_cle_id

Line 12223: TYPE l_phid_type is table of okl_party_payment_hdr.id%TYPE index by binary_integer;

12219:
12220:
12221: Procedure copy_party_payment_hdr(p_old_id IN NUMBER,
12222: p_new_id IN NUMBER) IS
12223: TYPE l_phid_type is table of okl_party_payment_hdr.id%TYPE index by binary_integer;
12224: TYPE l_phdnz_chr_id_type is table of okl_party_payment_hdr.dnz_chr_id%TYPE index by binary_integer;
12225: TYPE l_phcle_id_type is table of okl_party_payment_hdr.cle_id%TYPE index by binary_integer;
12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;
12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;

Line 12224: TYPE l_phdnz_chr_id_type is table of okl_party_payment_hdr.dnz_chr_id%TYPE index by binary_integer;

12220:
12221: Procedure copy_party_payment_hdr(p_old_id IN NUMBER,
12222: p_new_id IN NUMBER) IS
12223: TYPE l_phid_type is table of okl_party_payment_hdr.id%TYPE index by binary_integer;
12224: TYPE l_phdnz_chr_id_type is table of okl_party_payment_hdr.dnz_chr_id%TYPE index by binary_integer;
12225: TYPE l_phcle_id_type is table of okl_party_payment_hdr.cle_id%TYPE index by binary_integer;
12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;
12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;
12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;

Line 12225: TYPE l_phcle_id_type is table of okl_party_payment_hdr.cle_id%TYPE index by binary_integer;

12221: Procedure copy_party_payment_hdr(p_old_id IN NUMBER,
12222: p_new_id IN NUMBER) IS
12223: TYPE l_phid_type is table of okl_party_payment_hdr.id%TYPE index by binary_integer;
12224: TYPE l_phdnz_chr_id_type is table of okl_party_payment_hdr.dnz_chr_id%TYPE index by binary_integer;
12225: TYPE l_phcle_id_type is table of okl_party_payment_hdr.cle_id%TYPE index by binary_integer;
12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;
12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;
12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;
12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;

Line 12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;

12222: p_new_id IN NUMBER) IS
12223: TYPE l_phid_type is table of okl_party_payment_hdr.id%TYPE index by binary_integer;
12224: TYPE l_phdnz_chr_id_type is table of okl_party_payment_hdr.dnz_chr_id%TYPE index by binary_integer;
12225: TYPE l_phcle_id_type is table of okl_party_payment_hdr.cle_id%TYPE index by binary_integer;
12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;
12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;
12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;
12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;
12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;

Line 12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;

12223: TYPE l_phid_type is table of okl_party_payment_hdr.id%TYPE index by binary_integer;
12224: TYPE l_phdnz_chr_id_type is table of okl_party_payment_hdr.dnz_chr_id%TYPE index by binary_integer;
12225: TYPE l_phcle_id_type is table of okl_party_payment_hdr.cle_id%TYPE index by binary_integer;
12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;
12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;
12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;
12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;
12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;
12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;

Line 12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;

12224: TYPE l_phdnz_chr_id_type is table of okl_party_payment_hdr.dnz_chr_id%TYPE index by binary_integer;
12225: TYPE l_phcle_id_type is table of okl_party_payment_hdr.cle_id%TYPE index by binary_integer;
12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;
12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;
12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;
12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;
12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;
12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;
12232: TYPE l_phpassthru_term_type is table of okl_party_payment_hdr.passthru_term%TYPE index by binary_integer;

Line 12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;

12225: TYPE l_phcle_id_type is table of okl_party_payment_hdr.cle_id%TYPE index by binary_integer;
12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;
12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;
12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;
12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;
12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;
12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;
12232: TYPE l_phpassthru_term_type is table of okl_party_payment_hdr.passthru_term%TYPE index by binary_integer;
12233: TYPE l_phpayout_basis_formula_type is table of okl_party_payment_hdr.payout_basis_formula%TYPE index by binary_integer;

Line 12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;

12226: TYPE l_phppl_id_type is table of okl_party_payment_hdr.ppl_id%TYPE index by binary_integer;
12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;
12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;
12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;
12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;
12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;
12232: TYPE l_phpassthru_term_type is table of okl_party_payment_hdr.passthru_term%TYPE index by binary_integer;
12233: TYPE l_phpayout_basis_formula_type is table of okl_party_payment_hdr.payout_basis_formula%TYPE index by binary_integer;
12234: TYPE l_phpassthru_stre_type_id_type is table of okl_party_payment_hdr.passthru_stream_type_id%TYPE index by binary_integer;

Line 12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;

12227: TYPE l_phpassthru_start_date_type is table of okl_party_payment_hdr.passthru_start_date%TYPE index by binary_integer;
12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;
12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;
12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;
12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;
12232: TYPE l_phpassthru_term_type is table of okl_party_payment_hdr.passthru_term%TYPE index by binary_integer;
12233: TYPE l_phpayout_basis_formula_type is table of okl_party_payment_hdr.payout_basis_formula%TYPE index by binary_integer;
12234: TYPE l_phpassthru_stre_type_id_type is table of okl_party_payment_hdr.passthru_stream_type_id%TYPE index by binary_integer;
12235:

Line 12232: TYPE l_phpassthru_term_type is table of okl_party_payment_hdr.passthru_term%TYPE index by binary_integer;

12228: TYPE l_phpayout_basis_type is table of okl_party_payment_hdr.payout_basis%TYPE index by binary_integer;
12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;
12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;
12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;
12232: TYPE l_phpassthru_term_type is table of okl_party_payment_hdr.passthru_term%TYPE index by binary_integer;
12233: TYPE l_phpayout_basis_formula_type is table of okl_party_payment_hdr.payout_basis_formula%TYPE index by binary_integer;
12234: TYPE l_phpassthru_stre_type_id_type is table of okl_party_payment_hdr.passthru_stream_type_id%TYPE index by binary_integer;
12235:
12236: l_phid_tab l_phid_type;

Line 12233: TYPE l_phpayout_basis_formula_type is table of okl_party_payment_hdr.payout_basis_formula%TYPE index by binary_integer;

12229: TYPE l_pheffective_from_type is table of okl_party_payment_hdr.effective_from%TYPE index by binary_integer;
12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;
12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;
12232: TYPE l_phpassthru_term_type is table of okl_party_payment_hdr.passthru_term%TYPE index by binary_integer;
12233: TYPE l_phpayout_basis_formula_type is table of okl_party_payment_hdr.payout_basis_formula%TYPE index by binary_integer;
12234: TYPE l_phpassthru_stre_type_id_type is table of okl_party_payment_hdr.passthru_stream_type_id%TYPE index by binary_integer;
12235:
12236: l_phid_tab l_phid_type;
12237: l_phdnz_chr_id_tab l_phdnz_chr_id_type;

Line 12234: TYPE l_phpassthru_stre_type_id_type is table of okl_party_payment_hdr.passthru_stream_type_id%TYPE index by binary_integer;

12230: TYPE l_pheffective_to_type is table of okl_party_payment_hdr.effective_to%TYPE index by binary_integer;
12231: TYPE l_phobject_version_number_type is table of okl_party_payment_hdr.object_version_number%TYPE index by binary_integer;
12232: TYPE l_phpassthru_term_type is table of okl_party_payment_hdr.passthru_term%TYPE index by binary_integer;
12233: TYPE l_phpayout_basis_formula_type is table of okl_party_payment_hdr.payout_basis_formula%TYPE index by binary_integer;
12234: TYPE l_phpassthru_stre_type_id_type is table of okl_party_payment_hdr.passthru_stream_type_id%TYPE index by binary_integer;
12235:
12236: l_phid_tab l_phid_type;
12237: l_phdnz_chr_id_tab l_phdnz_chr_id_type;
12238: l_phcle_id_tab l_phcle_id_type;

Line 12268: FROM okl_party_payment_hdr a

12264: a.id, a.dnz_chr_id, a.cle_id,
12265: a.ppl_id, a.passthru_start_date, a.payout_basis,
12266: a.effective_from, a.effective_to, a.object_version_number,
12267: a.passthru_term, a.payout_basis_formula, a.passthru_stream_type_id
12268: FROM okl_party_payment_hdr a
12269: WHERE a.dnz_chr_id = p_id;
12270: l_new_cle_id NUMBER;
12271:
12272: BEGIN

Line 12332: INSERT INTO okl_party_payment_hdr (

12328: END IF;
12329: IF (l_party_payment_hdr_counter > 1) THEN
12330: sort_phid_mapping_tab;
12331: FORALL i IN l_phid_tab.FIRST..l_phid_tab.LAST
12332: INSERT INTO okl_party_payment_hdr (
12333: id, dnz_chr_id, cle_id,
12334: ppl_id, passthru_start_date, payout_basis,
12335: effective_from, effective_to, created_by,
12336: creation_date, last_updated_by, last_update_date,