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_REACTTIME_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_reacttime_rec IN ReactTime_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: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
91: l_row_notfound BOOLEAN := TRUE;

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: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
91: l_row_notfound BOOLEAN := TRUE;
92: BEGIN

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: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
91: l_row_notfound BOOLEAN := TRUE;
92: BEGIN
93: IF (p_reacttime_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)

Line 95: OPEN cs_coverage_txn_groups_pk_csr(p_reacttime_rec.COVERAGE_TXN_GROUP_ID);

91: l_row_notfound BOOLEAN := TRUE;
92: BEGIN
93: IF (p_reacttime_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)
94: THEN
95: OPEN cs_coverage_txn_groups_pk_csr(p_reacttime_rec.COVERAGE_TXN_GROUP_ID);
96: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
97: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
98: CLOSE cs_coverage_txn_groups_pk_csr;
99: IF (l_row_notfound) THEN

Line 96: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;

92: BEGIN
93: IF (p_reacttime_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)
94: THEN
95: OPEN cs_coverage_txn_groups_pk_csr(p_reacttime_rec.COVERAGE_TXN_GROUP_ID);
96: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
97: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
98: CLOSE cs_coverage_txn_groups_pk_csr;
99: IF (l_row_notfound) THEN
100: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_TXN_GROUP_ID');

Line 97: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;

93: IF (p_reacttime_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)
94: THEN
95: OPEN cs_coverage_txn_groups_pk_csr(p_reacttime_rec.COVERAGE_TXN_GROUP_ID);
96: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
97: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
98: CLOSE cs_coverage_txn_groups_pk_csr;
99: IF (l_row_notfound) THEN
100: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_TXN_GROUP_ID');
101: RAISE item_not_found_error;

Line 98: CLOSE cs_coverage_txn_groups_pk_csr;

94: THEN
95: OPEN cs_coverage_txn_groups_pk_csr(p_reacttime_rec.COVERAGE_TXN_GROUP_ID);
96: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
97: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
98: CLOSE cs_coverage_txn_groups_pk_csr;
99: IF (l_row_notfound) THEN
100: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_TXN_GROUP_ID');
101: RAISE item_not_found_error;
102: END IF;