APPS.HXT_TIME_SUMMARY dependencies on HXT_DET_DUPLICATE_REGULAR

Line 69: --TYPE det_tab IS TABLE OF hxt_det_duplicate_regular%ROWTYPE;

65: g_CALL_ADJUST_ABS VARCHAR2(1);
66:
67: -- Bug 10123886
68: -- Added this type to store the regular elements to be deleted.
69: --TYPE det_tab IS TABLE OF hxt_det_duplicate_regular%ROWTYPE;
70: --g_det_tab det_tab := det_tab();
71: --g_index BINARY_INTEGER;
72:
73:

Line 367: FROM hxt_det_duplicate_regular dup

363: parent_id) IN
364: ( SELECT dup.tim_id,
365: dup.det_id,
366: dup.parent_id
367: FROM hxt_det_duplicate_regular dup
368: WHERE dup.tim_id = g_hol_tim_id);
369:
370: -- Delete from the table storing duplicates.
371: DELETE FROM hxt_det_duplicate_regular

Line 371: DELETE FROM hxt_det_duplicate_regular

367: FROM hxt_det_duplicate_regular dup
368: WHERE dup.tim_id = g_hol_tim_id);
369:
370: -- Delete from the table storing duplicates.
371: DELETE FROM hxt_det_duplicate_regular
372: WHERE tim_id = g_hol_tim_id;
373:
374:
375: END IF;

Line 853: INSERT INTO hxt_det_duplicate_regular

849:
850: g_det_tab.EXTEND;
851: g_index := g_index+1;
852: g_det_tab(g_index) := l_det_tab(i);
853: INSERT INTO hxt_det_duplicate_regular
854: ( det_id,
855: det_rowid,
856: tim_id,
857: parent_id)