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.CS_BILLINGTYPE_PVT dependencies on CS_COVERAGE_TXN_GROUPS

Line 85: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS

81: p_billingtype_rec IN BillingType_Rec_Type
82: )
83: RETURN VARCHAR2 IS
84: item_not_found_error EXCEPTION;
85: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS
86: SELECT *
87: FROM Cs_Coverage_Txn_Groups
88: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;

Line 87: FROM Cs_Coverage_Txn_Groups

83: RETURN VARCHAR2 IS
84: item_not_found_error EXCEPTION;
85: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS
86: SELECT *
87: FROM Cs_Coverage_Txn_Groups
88: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
90: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
91: SELECT *

Line 88: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;

84: item_not_found_error EXCEPTION;
85: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS
86: SELECT *
87: FROM Cs_Coverage_Txn_Groups
88: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
90: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Txn_Billing_Types

Line 89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;

85: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS
86: SELECT *
87: FROM Cs_Coverage_Txn_Groups
88: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
90: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Txn_Billing_Types
93: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;

Line 100: OPEN cs_coverage_txn_groups_pk_csr(p_billingtype_rec.COVERAGE_TXN_GROUP_ID);

96: l_row_notfound BOOLEAN := TRUE;
97: BEGIN
98: IF (p_billingtype_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)
99: THEN
100: OPEN cs_coverage_txn_groups_pk_csr(p_billingtype_rec.COVERAGE_TXN_GROUP_ID);
101: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
102: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
103: CLOSE cs_coverage_txn_groups_pk_csr;
104: IF (l_row_notfound) THEN

Line 101: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;

97: BEGIN
98: IF (p_billingtype_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)
99: THEN
100: OPEN cs_coverage_txn_groups_pk_csr(p_billingtype_rec.COVERAGE_TXN_GROUP_ID);
101: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
102: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
103: CLOSE cs_coverage_txn_groups_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_TXN_GROUP_ID');

Line 102: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;

98: IF (p_billingtype_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)
99: THEN
100: OPEN cs_coverage_txn_groups_pk_csr(p_billingtype_rec.COVERAGE_TXN_GROUP_ID);
101: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
102: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
103: CLOSE cs_coverage_txn_groups_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_TXN_GROUP_ID');
106: RAISE item_not_found_error;

Line 103: CLOSE cs_coverage_txn_groups_pk_csr;

99: THEN
100: OPEN cs_coverage_txn_groups_pk_csr(p_billingtype_rec.COVERAGE_TXN_GROUP_ID);
101: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
102: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
103: CLOSE cs_coverage_txn_groups_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_TXN_GROUP_ID');
106: RAISE item_not_found_error;
107: END IF;