APPS.IGC_CC_PERIODS_PKG dependencies on IGC_CC_PERIODS_ALL

Line 39: CURSOR C IS SELECT ROWID FROM igc_cc_periods_all

35:
36: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
37: l_api_version CONSTANT NUMBER := 1.0;
38:
39: CURSOR C IS SELECT ROWID FROM igc_cc_periods_all
40: WHERE org_id = p_org_id
41: AND period_set_name = p_period_set_name
42: AND period_name = p_period_name;
43: BEGIN

Line 62: INSERT INTO igc_cc_periods_all

58: END IF;
59:
60: p_return_status := FND_API.G_RET_STS_SUCCESS ;
61:
62: INSERT INTO igc_cc_periods_all
63: (
64: org_id,
65: period_set_name,
66: period_name,

Line 165: SELECT * FROM igc_cc_periods_all

161: l_api_version CONSTANT NUMBER := 1.0;
162:
163: Counter NUMBER;
164: CURSOR C IS
165: SELECT * FROM igc_cc_periods_all
166: WHERE rowid = p_row_id
167: FOR UPDATE NOWAIT;
168: Recinfo C%ROWTYPE;
169:

Line 312: UPDATE igc_cc_periods_all

308:
309: p_return_status := FND_API.G_RET_STS_SUCCESS ;
310:
311:
312: UPDATE igc_cc_periods_all
313: SET
314: org_id = p_org_id,
315: cc_period_status = p_cc_period_status,
316: last_update_date = p_last_update_date ,

Line 413: DELETE FROM igc_cc_periods_all

409: p_return_status := FND_API.G_RET_STS_SUCCESS ;
410:
411: -- Deleting the record in igc_cc_periods.
412:
413: DELETE FROM igc_cc_periods_all
414: WHERE rowid = p_row_id;
415:
416:
417: IF (SQL%NOTFOUND) THEN

Line 490: FROM igc_cc_periods_all

486: l_tmp VARCHAR2(1);
487:
488: CURSOR c IS
489: SELECT '1'
490: FROM igc_cc_periods_all
491: WHERE org_id = p_org_id
492: AND period_set_name = p_period_set_name
493: AND period_name = p_period_name
494: AND (