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_V

Line 1062: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR_V

1058: --Bug# : 3143522
1059:
1060: --furong 4350255
1061: ---------------------------------------------------------------------------
1062: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR_V
1063: ---------------------------------------------------------------------------
1064: FUNCTION get_pphv_rec (
1065: p_pphv_rec IN pphv_rec_type,
1066: x_no_data_found OUT NOCOPY BOOLEAN

Line 1068: CURSOR okl_party_payment_hdr_v_pk_csr (p_id IN NUMBER) IS

1064: FUNCTION get_pphv_rec (
1065: p_pphv_rec IN pphv_rec_type,
1066: x_no_data_found OUT NOCOPY BOOLEAN
1067: ) RETURN pphv_rec_type IS
1068: CURSOR okl_party_payment_hdr_v_pk_csr (p_id IN NUMBER) IS
1069: SELECT
1070: ID,
1071: OBJECT_VERSION_NUMBER,
1072: DNZ_CHR_ID,

Line 1087: FROM Okl_Party_Payment_Hdr_V

1083: CREATION_DATE,
1084: LAST_UPDATED_BY,
1085: LAST_UPDATE_DATE,
1086: LAST_UPDATE_LOGIN
1087: FROM Okl_Party_Payment_Hdr_V
1088: WHERE okl_party_payment_hdr_v.id = p_id;
1089: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
1090: l_pphv_rec pphv_rec_type;
1091: BEGIN

Line 1088: WHERE okl_party_payment_hdr_v.id = p_id;

1084: LAST_UPDATED_BY,
1085: LAST_UPDATE_DATE,
1086: LAST_UPDATE_LOGIN
1087: FROM Okl_Party_Payment_Hdr_V
1088: WHERE okl_party_payment_hdr_v.id = p_id;
1089: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
1090: l_pphv_rec pphv_rec_type;
1091: BEGIN
1092: x_no_data_found := TRUE;

Line 1089: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;

1085: LAST_UPDATE_DATE,
1086: LAST_UPDATE_LOGIN
1087: FROM Okl_Party_Payment_Hdr_V
1088: WHERE okl_party_payment_hdr_v.id = p_id;
1089: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
1090: l_pphv_rec pphv_rec_type;
1091: BEGIN
1092: x_no_data_found := TRUE;
1093: -- Get current database values

Line 1094: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);

1090: l_pphv_rec pphv_rec_type;
1091: BEGIN
1092: x_no_data_found := TRUE;
1093: -- Get current database values
1094: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);
1095: FETCH okl_party_payment_hdr_v_pk_csr INTO
1096: l_pphv_rec.id,
1097: l_pphv_rec.object_version_number,
1098: l_pphv_rec.dnz_chr_id,

Line 1095: FETCH okl_party_payment_hdr_v_pk_csr INTO

1091: BEGIN
1092: x_no_data_found := TRUE;
1093: -- Get current database values
1094: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);
1095: FETCH okl_party_payment_hdr_v_pk_csr INTO
1096: l_pphv_rec.id,
1097: l_pphv_rec.object_version_number,
1098: l_pphv_rec.dnz_chr_id,
1099: l_pphv_rec.cle_id,

Line 1113: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;

1109: l_pphv_rec.creation_date,
1110: l_pphv_rec.last_updated_by,
1111: l_pphv_rec.last_update_date,
1112: l_pphv_rec.last_update_login;
1113: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;
1114: CLOSE okl_party_payment_hdr_v_pk_csr;
1115: RETURN(l_pphv_rec);
1116: END get_pphv_rec;
1117: ------------------------------------------------------------------

Line 1114: CLOSE okl_party_payment_hdr_v_pk_csr;

1110: l_pphv_rec.last_updated_by,
1111: l_pphv_rec.last_update_date,
1112: l_pphv_rec.last_update_login;
1113: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;
1114: CLOSE okl_party_payment_hdr_v_pk_csr;
1115: RETURN(l_pphv_rec);
1116: END get_pphv_rec;
1117: ------------------------------------------------------------------
1118: -- This version of get_rec sets error messages if no data found --