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 3089: FROM okc_del_status_history

3085: del_ins_rec del_ins_cur%ROWTYPE;
3086:
3087: CURSOR delStsHist(X NUMBER) IS
3088: SELECT *
3089: FROM okc_del_status_history
3090: WHERE deliverable_id = X;
3091: delStsHist_rec delStsHist%ROWTYPE;
3092: delHistTab delHistTabType;
3093:

Line 3951: INSERT INTO okc_del_status_history (

3947: delHistTab(p).LAST_UPDATE_DATE := sysdate;
3948: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/
3949:
3950: --insert into status history
3951: INSERT INTO okc_del_status_history (
3952: deliverable_id,
3953: deliverable_status,
3954: status_changed_by,
3955: status_change_date,

Line 4855: INSERT INTO okc_del_status_history (

4851: END IF;
4852:
4853:
4854: --insert into status history
4855: INSERT INTO okc_del_status_history (
4856: deliverable_id,
4857: deliverable_status,
4858: status_changed_by,
4859: status_change_date,

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

4958: */
4959: TYPE delIdTabType IS TABLE OF NUMBER;
4960: delIdTab delIdTabType;
4961:
4962: TYPE delStsTabType IS TABLE OF okc_del_status_history%ROWTYPE;
4963: delStsTab delStsTabType;
4964:
4965: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
4966: l_msg_count NUMBER;

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

5007: WHERE deliverable_id = delIdTab(i);
5008: --Bulk insert into status history
5009: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5010: /*code changed for 8i compatability bug#3307941
5011: INSERT INTO okc_del_status_history VALUES delStsTab(i); */
5012: INSERT INTO okc_del_status_history
5013: (deliverable_id,
5014: deliverable_status,
5015: STATUS_CHANGED_BY,

Line 5012: INSERT INTO okc_del_status_history

5008: --Bulk insert into status history
5009: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5010: /*code changed for 8i compatability bug#3307941
5011: INSERT INTO okc_del_status_history VALUES delStsTab(i); */
5012: INSERT INTO okc_del_status_history
5013: (deliverable_id,
5014: deliverable_status,
5015: STATUS_CHANGED_BY,
5016: status_change_date,

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

5094:
5095: -- BULK INSERT into status history
5096: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5097: --code changed for 8i compatability bug#3307941
5098: --INSERT INTO okc_del_status_history VALUES delStsTab(i);
5099: INSERT INTO okc_del_status_history
5100: (deliverable_id,
5101: deliverable_status,
5102: STATUS_CHANGED_BY,

Line 5099: INSERT INTO okc_del_status_history

5095: -- BULK INSERT into status history
5096: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5097: --code changed for 8i compatability bug#3307941
5098: --INSERT INTO okc_del_status_history VALUES delStsTab(i);
5099: INSERT INTO okc_del_status_history
5100: (deliverable_id,
5101: deliverable_status,
5102: STATUS_CHANGED_BY,
5103: status_change_date,

Line 6380: DELETE FROM okc_del_status_history

6376: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6377: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Deleting Deliverable Id :'||to_char(delIdTab(i)));
6378: END IF;
6379: -- delete deliverables status history
6380: DELETE FROM okc_del_status_history
6381: WHERE deliverable_id = delIdTab(i);
6382: -- delete attachments if any
6383: delete_attachments (
6384: p_entity_name => G_ENTITY_NAME

Line 9489: DELETE FROM okc_del_status_history

9485:
9486:
9487:
9488: -- delete deliverables status history
9489: DELETE FROM okc_del_status_history
9490: WHERE deliverable_id = p_deliverable_id;
9491: -- delete attachments if any
9492: delete_attachments (
9493: p_entity_name => G_ENTITY_NAME

Line 9566: FROM okc_del_status_history

9562: l_others_count NUMBER ;
9563:
9564: CURSOR hist_cur (delid NUMBER) IS
9565: SELECT deliverable_status
9566: FROM okc_del_status_history
9567: where deliverable_id = delid;
9568:
9569: hist_rec hist_cur%ROWTYPE;
9570: l_api_name CONSTANT VARCHAR2(30) :='delStatusUnchanged';

Line 9677: DELETE FROM okc_del_status_history

9673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: l_deleteInstances:'||l_deleteInstances);
9674: END IF;
9675: IF (l_deleteInstances = 'Y') then
9676: -- delete deliverables status history
9677: DELETE FROM okc_del_status_history
9678: WHERE deliverable_id = l_del_id;
9679: -- delete attachments if any
9680: delete_attachments (
9681: p_entity_name => G_ENTITY_NAME

Line 9848: DELETE FROM okc_del_status_history

9844: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9845: 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));
9846: END IF;
9847: -- delete deliverables status history
9848: DELETE FROM okc_del_status_history
9849: WHERE deliverable_id = p_del_id;
9850: -- delete attachments if any
9851: delete_attachments (
9852: p_entity_name => G_ENTITY_NAME

Line 10310: FROM okc_del_status_history

10306: TYPE delIdTabType IS TABLE OF delIdRecType;
10307:
10308: CURSOR delStsHist(Y NUMBER) IS
10309: SELECT *
10310: FROM okc_del_status_history
10311: WHERE deliverable_id = Y;
10312: delStsHist_rec delStsHist%ROWTYPE;
10313: delHistTab delHistTabType;
10314:

Line 10798: INSERT INTO okc_del_status_history (

10794: --insert into status history
10795: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10796: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: status history for Deliverable Id :'||to_char(delIdTab(i).del_id));
10797: END IF;
10798: INSERT INTO okc_del_status_history (
10799: deliverable_id,
10800: deliverable_status,
10801: status_changed_by,
10802: status_change_date,

Line 10951: INSERT INTO okc_del_status_history

10947: END IF;
10948:
10949: IF p_del_st_hist_tab.count > 0 THEN
10950: FOR i IN p_del_st_hist_tab.FIRST..p_del_st_hist_tab.LAST LOOP
10951: INSERT INTO okc_del_status_history
10952: (deliverable_id,
10953: deliverable_status,
10954: STATUS_CHANGED_BY,
10955: status_change_date,