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.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_DEL_STATUS_HISTORY

Line 3266: FROM okc_del_status_history

3262: del_ins_rec del_ins_cur%ROWTYPE;
3263:
3264: CURSOR delStsHist(X NUMBER) IS
3265: SELECT *
3266: FROM okc_del_status_history
3267: WHERE deliverable_id = X;
3268: delStsHist_rec delStsHist%ROWTYPE;
3269: delHistTab delHistTabType;
3270:

Line 4189: INSERT INTO okc_del_status_history (

4185: delHistTab(p).LAST_UPDATE_DATE := sysdate;
4186: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/
4187:
4188: --insert into status history
4189: INSERT INTO okc_del_status_history (
4190: deliverable_id,
4191: deliverable_status,
4192: status_changed_by,
4193: status_change_date,

Line 5152: INSERT INTO okc_del_status_history (

5148: END IF;
5149:
5150:
5151: --insert into status history
5152: INSERT INTO okc_del_status_history (
5153: deliverable_id,
5154: deliverable_status,
5155: status_changed_by,
5156: status_change_date,

Line 5259: TYPE delStsTabType IS TABLE OF okc_del_status_history%ROWTYPE;

5255: */
5256: TYPE delIdTabType IS TABLE OF NUMBER;
5257: delIdTab delIdTabType;
5258:
5259: TYPE delStsTabType IS TABLE OF okc_del_status_history%ROWTYPE;
5260: delStsTab delStsTabType;
5261:
5262: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
5263: l_msg_count NUMBER;

Line 5308: INSERT INTO okc_del_status_history VALUES delStsTab(i); */

5304: WHERE deliverable_id = delIdTab(i);
5305: --Bulk insert into status history
5306: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5307: /*code changed for 8i compatability bug#3307941
5308: INSERT INTO okc_del_status_history VALUES delStsTab(i); */
5309: INSERT INTO okc_del_status_history
5310: (deliverable_id,
5311: deliverable_status,
5312: STATUS_CHANGED_BY,

Line 5309: INSERT INTO okc_del_status_history

5305: --Bulk insert into status history
5306: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5307: /*code changed for 8i compatability bug#3307941
5308: INSERT INTO okc_del_status_history VALUES delStsTab(i); */
5309: INSERT INTO okc_del_status_history
5310: (deliverable_id,
5311: deliverable_status,
5312: STATUS_CHANGED_BY,
5313: status_change_date,

Line 5395: --INSERT INTO okc_del_status_history VALUES delStsTab(i);

5391:
5392: -- BULK INSERT into status history
5393: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5394: --code changed for 8i compatability bug#3307941
5395: --INSERT INTO okc_del_status_history VALUES delStsTab(i);
5396: INSERT INTO okc_del_status_history
5397: (deliverable_id,
5398: deliverable_status,
5399: STATUS_CHANGED_BY,

Line 5396: INSERT INTO okc_del_status_history

5392: -- BULK INSERT into status history
5393: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5394: --code changed for 8i compatability bug#3307941
5395: --INSERT INTO okc_del_status_history VALUES delStsTab(i);
5396: INSERT INTO okc_del_status_history
5397: (deliverable_id,
5398: deliverable_status,
5399: STATUS_CHANGED_BY,
5400: status_change_date,

Line 6749: DELETE FROM okc_del_status_history

6745: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6746: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Deleting Deliverable Id :'||to_char(delIdTab(i)));
6747: END IF;
6748: -- delete deliverables status history
6749: DELETE FROM okc_del_status_history
6750: WHERE deliverable_id = delIdTab(i);
6751: -- delete attachments if any
6752: delete_attachments (
6753: p_entity_name => G_ENTITY_NAME

Line 10380: DELETE FROM okc_del_status_history

10376:
10377:
10378:
10379: -- delete deliverables status history
10380: DELETE FROM okc_del_status_history
10381: WHERE deliverable_id = p_deliverable_id;
10382: -- delete attachments if any
10383: delete_attachments (
10384: p_entity_name => G_ENTITY_NAME

Line 10457: FROM okc_del_status_history

10453: l_others_count NUMBER ;
10454:
10455: CURSOR hist_cur (delid NUMBER) IS
10456: SELECT deliverable_status
10457: FROM okc_del_status_history
10458: where deliverable_id = delid;
10459:
10460: hist_rec hist_cur%ROWTYPE;
10461: l_api_name CONSTANT VARCHAR2(30) :='delStatusUnchanged';

Line 10568: DELETE FROM okc_del_status_history

10564: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: l_deleteInstances:'||l_deleteInstances);
10565: END IF;
10566: IF (l_deleteInstances = 'Y') then
10567: -- delete deliverables status history
10568: DELETE FROM okc_del_status_history
10569: WHERE deliverable_id = l_del_id;
10570: -- delete attachments if any
10571: delete_attachments (
10572: p_entity_name => G_ENTITY_NAME

Line 10743: DELETE FROM okc_del_status_history

10739: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10740: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable'||to_char(p_del_id));
10741: END IF;
10742: -- delete deliverables status history
10743: DELETE FROM okc_del_status_history
10744: WHERE deliverable_id = p_del_id;
10745: -- delete attachments if any
10746: delete_attachments (
10747: p_entity_name => G_ENTITY_NAME

Line 11269: FROM okc_del_status_history

11265: TYPE delIdTabType IS TABLE OF delIdRecType;
11266:
11267: CURSOR delStsHist(Y NUMBER) IS
11268: SELECT *
11269: FROM okc_del_status_history
11270: WHERE deliverable_id = Y;
11271: delStsHist_rec delStsHist%ROWTYPE;
11272: delHistTab delHistTabType;
11273:

Line 11817: INSERT INTO okc_del_status_history (

11813: --insert into status history
11814: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11815: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: status history for Deliverable Id :'||to_char(delIdTab(i).del_id));
11816: END IF;
11817: INSERT INTO okc_del_status_history (
11818: deliverable_id,
11819: deliverable_status,
11820: status_changed_by,
11821: status_change_date,

Line 11970: INSERT INTO okc_del_status_history

11966: END IF;
11967:
11968: IF p_del_st_hist_tab.count > 0 THEN
11969: FOR i IN p_del_st_hist_tab.FIRST..p_del_st_hist_tab.LAST LOOP
11970: INSERT INTO okc_del_status_history
11971: (deliverable_id,
11972: deliverable_status,
11973: STATUS_CHANGED_BY,
11974: status_change_date,

Line 13408: DELETE FROM okc_del_status_history

13404: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
13405: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_del_attach_and_history'||to_char(p_del_id));
13406: END IF;
13407: -- delete deliverables status history
13408: DELETE FROM okc_del_status_history
13409: WHERE deliverable_id = p_del_id;
13410: -- delete attachments if any
13411: delete_attachments (
13412: p_entity_name => G_ENTITY_NAME