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

Line 1058: CURSOR okx_parties_v_pk_csr (p_id1 IN NUMBER,

1054: WHERE okx_customer_accounts_v.id1 = p_id1
1055: AND okx_customer_accounts_v.id2 = p_id2;
1056: l_okx_customer_account_v_pk okx_customer_account_v_pk_csr%ROWTYPE;
1057:
1058: CURSOR okx_parties_v_pk_csr (p_id1 IN NUMBER,
1059: p_id2 IN VARCHAR2) IS
1060: SELECT 'x'
1061: FROM Okx_Parties_V
1062: WHERE okx_parties_v.id1 = p_id1

Line 1061: FROM Okx_Parties_V

1057:
1058: CURSOR okx_parties_v_pk_csr (p_id1 IN NUMBER,
1059: p_id2 IN VARCHAR2) IS
1060: SELECT 'x'
1061: FROM Okx_Parties_V
1062: WHERE okx_parties_v.id1 = p_id1
1063: AND okx_parties_v.id2 = p_id2;
1064: l_okx_parties_v_pk okx_parties_v_pk_csr%ROWTYPE;
1065:

Line 1062: WHERE okx_parties_v.id1 = p_id1

1058: CURSOR okx_parties_v_pk_csr (p_id1 IN NUMBER,
1059: p_id2 IN VARCHAR2) IS
1060: SELECT 'x'
1061: FROM Okx_Parties_V
1062: WHERE okx_parties_v.id1 = p_id1
1063: AND okx_parties_v.id2 = p_id2;
1064: l_okx_parties_v_pk okx_parties_v_pk_csr%ROWTYPE;
1065:
1066: CURSOR okx_site_uses_v_pk_csr (p_id1 IN NUMBER,

Line 1063: AND okx_parties_v.id2 = p_id2;

1059: p_id2 IN VARCHAR2) IS
1060: SELECT 'x'
1061: FROM Okx_Parties_V
1062: WHERE okx_parties_v.id1 = p_id1
1063: AND okx_parties_v.id2 = p_id2;
1064: l_okx_parties_v_pk okx_parties_v_pk_csr%ROWTYPE;
1065:
1066: CURSOR okx_site_uses_v_pk_csr (p_id1 IN NUMBER,
1067: p_id2 IN VARCHAR2) IS

Line 1064: l_okx_parties_v_pk okx_parties_v_pk_csr%ROWTYPE;

1060: SELECT 'x'
1061: FROM Okx_Parties_V
1062: WHERE okx_parties_v.id1 = p_id1
1063: AND okx_parties_v.id2 = p_id2;
1064: l_okx_parties_v_pk okx_parties_v_pk_csr%ROWTYPE;
1065:
1066: CURSOR okx_site_uses_v_pk_csr (p_id1 IN NUMBER,
1067: p_id2 IN VARCHAR2) IS
1068: SELECT 'x'

Line 1154: OPEN okx_parties_v_pk_csr (p_bpev_rec.OWNED_PARTY_ID1,

1150: AND
1151: ((p_bpev_rec.OWNED_PARTY_ID1 <> p_db_bpev_rec.OWNED_PARTY_ID1) OR
1152: (p_bpev_rec.OWNED_PARTY_ID2 <> p_db_bpev_rec.OWNED_PARTY_ID2)))
1153: THEN
1154: OPEN okx_parties_v_pk_csr (p_bpev_rec.OWNED_PARTY_ID1,
1155: p_bpev_rec.OWNED_PARTY_ID2);
1156: FETCH okx_parties_v_pk_csr INTO l_okx_parties_v_pk;
1157: l_row_notfound := okx_parties_v_pk_csr%NOTFOUND;
1158: CLOSE okx_parties_v_pk_csr;

Line 1156: FETCH okx_parties_v_pk_csr INTO l_okx_parties_v_pk;

1152: (p_bpev_rec.OWNED_PARTY_ID2 <> p_db_bpev_rec.OWNED_PARTY_ID2)))
1153: THEN
1154: OPEN okx_parties_v_pk_csr (p_bpev_rec.OWNED_PARTY_ID1,
1155: p_bpev_rec.OWNED_PARTY_ID2);
1156: FETCH okx_parties_v_pk_csr INTO l_okx_parties_v_pk;
1157: l_row_notfound := okx_parties_v_pk_csr%NOTFOUND;
1158: CLOSE okx_parties_v_pk_csr;
1159: IF (l_row_notfound) THEN
1160: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OWNED_PARTY_ID1');

Line 1157: l_row_notfound := okx_parties_v_pk_csr%NOTFOUND;

1153: THEN
1154: OPEN okx_parties_v_pk_csr (p_bpev_rec.OWNED_PARTY_ID1,
1155: p_bpev_rec.OWNED_PARTY_ID2);
1156: FETCH okx_parties_v_pk_csr INTO l_okx_parties_v_pk;
1157: l_row_notfound := okx_parties_v_pk_csr%NOTFOUND;
1158: CLOSE okx_parties_v_pk_csr;
1159: IF (l_row_notfound) THEN
1160: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OWNED_PARTY_ID1');
1161: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OWNED_PARTY_ID2');

Line 1158: CLOSE okx_parties_v_pk_csr;

1154: OPEN okx_parties_v_pk_csr (p_bpev_rec.OWNED_PARTY_ID1,
1155: p_bpev_rec.OWNED_PARTY_ID2);
1156: FETCH okx_parties_v_pk_csr INTO l_okx_parties_v_pk;
1157: l_row_notfound := okx_parties_v_pk_csr%NOTFOUND;
1158: CLOSE okx_parties_v_pk_csr;
1159: IF (l_row_notfound) THEN
1160: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OWNED_PARTY_ID1');
1161: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OWNED_PARTY_ID2');
1162: RAISE item_not_found_error;