APPS.CS_TXNGRP_PVT dependencies on CS_TIME_ZONES

Line 95: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS

91: SELECT *
92: FROM Cs_Business_Processes
93: WHERE cs_business_processes.business_process_id = p_business_process_id;
94: l_csbp_pk csbp_pk_csr%ROWTYPE;
95: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
96: SELECT *
97: FROM Cs_Time_Zones
98: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
99: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;

Line 97: FROM Cs_Time_Zones

93: WHERE cs_business_processes.business_process_id = p_business_process_id;
94: l_csbp_pk csbp_pk_csr%ROWTYPE;
95: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
96: SELECT *
97: FROM Cs_Time_Zones
98: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
99: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;
100: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
101: l_row_notfound BOOLEAN := TRUE;

Line 98: WHERE cs_time_zones.time_zone_id = p_time_zone_id;

94: l_csbp_pk csbp_pk_csr%ROWTYPE;
95: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
96: SELECT *
97: FROM Cs_Time_Zones
98: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
99: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;
100: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
101: l_row_notfound BOOLEAN := TRUE;
102: BEGIN

Line 99: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;

95: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
96: SELECT *
97: FROM Cs_Time_Zones
98: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
99: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;
100: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
101: l_row_notfound BOOLEAN := TRUE;
102: BEGIN
103: IF (p_txngrp_rec.COVERAGE_ID IS NOT NULL)

Line 127: OPEN cs_time_zones_pk_csr(p_txngrp_rec.TIME_ZONE_ID);

123: END IF;
124: END IF;
125: IF (p_txngrp_rec.TIME_ZONE_ID IS NOT NULL)
126: THEN
127: OPEN cs_time_zones_pk_csr(p_txngrp_rec.TIME_ZONE_ID);
128: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
129: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
130: CLOSE cs_time_zones_pk_csr;
131: IF (l_row_notfound) THEN

Line 128: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;

124: END IF;
125: IF (p_txngrp_rec.TIME_ZONE_ID IS NOT NULL)
126: THEN
127: OPEN cs_time_zones_pk_csr(p_txngrp_rec.TIME_ZONE_ID);
128: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
129: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
130: CLOSE cs_time_zones_pk_csr;
131: IF (l_row_notfound) THEN
132: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TIME_ZONE_ID');

Line 129: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;

125: IF (p_txngrp_rec.TIME_ZONE_ID IS NOT NULL)
126: THEN
127: OPEN cs_time_zones_pk_csr(p_txngrp_rec.TIME_ZONE_ID);
128: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
129: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
130: CLOSE cs_time_zones_pk_csr;
131: IF (l_row_notfound) THEN
132: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TIME_ZONE_ID');
133: RAISE item_not_found_error;

Line 130: CLOSE cs_time_zones_pk_csr;

126: THEN
127: OPEN cs_time_zones_pk_csr(p_txngrp_rec.TIME_ZONE_ID);
128: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
129: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
130: CLOSE cs_time_zones_pk_csr;
131: IF (l_row_notfound) THEN
132: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TIME_ZONE_ID');
133: RAISE item_not_found_error;
134: END IF;