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.GMP_CALENDAR_PKG dependencies on GMP_CALENDAR_DETAIL_GTMP

Line 752: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '

748: || ' ((crd.resource_id*2)+1), '
749: || ' 2, '
750: || ' :instance_id, '
751: || ' crd.assigned_qty '
752: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '
753: || ' mtl_parameters'||p_db_link||' m, '
754: || ' cr_rsrc_dtl'||p_db_link||' crd '
755: || ' WHERE NVL(crd.calendar_code,m.calendar_code) = gtmp.calendar_code '
756: || ' AND m.organization_id = crd.organization_id '

Line 1144: ins_stmt := 'INSERT INTO gmp_calendar_detail_gtmp'||p_db_link

1140: CLOSE cal_cur;
1141:
1142: /* 12/13/02 - Rajesh Patangya B2710601, Added database link */
1143: wps_index := 1 ;
1144: ins_stmt := 'INSERT INTO gmp_calendar_detail_gtmp'||p_db_link
1145: ||' ( '
1146: ||' calendar_code, '
1147: ||' shift_num, '
1148: ||' shift_date, '

Line 1218: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp '

1214: || ' from_time, '
1215: || ' to_time, '
1216: || ' 2 , '
1217: || ' :instance_id '
1218: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp '
1219: || ' WHERE calendar_code = :curr_cal_code '
1220: || ' ORDER BY shift_num,from_time,to_time ';
1221:
1222: EXECUTE IMMEDIATE get_shift_time USING n_calendar_code,

Line 1319: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */

1315:
1316: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
1317: instance_number inst_num ;
1318:
1319: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
1320: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
1321: shift_num shift_no ;
1322:
1323: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;

Line 1320: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;

1316: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
1317: instance_number inst_num ;
1318:
1319: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
1320: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
1321: shift_num shift_no ;
1322:
1323: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1324: f_date f_dt ;

Line 1634: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '

1630: || ' (SELECT 1 '
1631: || ' FROM gmp_resource_instances'||p_db_link||' gri '
1632: || ' WHERE gri.resource_id = un.resource_id ) '
1633: || ' ) cmd, '
1634: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1635: || ' WHERE exp.calendar_code = :CAL91 '
1636: || ' AND cmd.interval_date BETWEEN '
1637: || ' exp.from_date AND exp.to_date '
1638: || ' UNION ALL '

Line 1646: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '

1642: || ' 0 , '
1643: || ' exp.from_date interval_date, '
1644: || ' crd.assigned_qty assigned_qty '
1645: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1646: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1647: || ' WHERE crd.delete_mark = 0 '
1648: || ' AND crd.organization_id = :orgn_id10 '
1649: || ' AND nvl(crd.calendar_code,:g_default_code10)=:l_cal_code10 ';
1650:

Line 1665: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '

1661: || ' 0 , '
1662: || ' exp.to_date interval_date, '
1663: || ' crd.assigned_qty assigned_qty '
1664: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1665: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1666: || ' WHERE crd.delete_mark = 0 '
1667: || ' AND crd.organization_id = :orgn_id11 '
1668: || ' AND nvl(crd.calendar_code,:g_default_code11)=:l_cal_code11 ';
1669:

Line 2159: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */

2155:
2156: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
2157: instance_number inst_num ;
2158:
2159: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
2160: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
2161: shift_num shift_no ;
2162:
2163: TYPE f_dt IS TABLE OF mr_shcl_dtl.calendar_date%TYPE;

Line 2160: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;

2156: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
2157: instance_number inst_num ;
2158:
2159: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
2160: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
2161: shift_num shift_no ;
2162:
2163: TYPE f_dt IS TABLE OF mr_shcl_dtl.calendar_date%TYPE;
2164: f_date f_dt ;

Line 2399: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '

2395: || ' WHERE tgri.resource_id = crd.resource_id '
2396: || ' AND rownum <= un.resource_units '
2397: || ' ) '
2398: || ' ) cmd, '
2399: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
2400: || ' WHERE exp.calendar_code = :curr_cal1 '
2401: || ' AND cmd.interval_date BETWEEN '
2402: || ' exp.from_date AND exp.to_date '
2403: || ' UNION ALL '

Line 2411: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '

2407: || ' 1 , '
2408: || ' (exp.shift_date + '
2409: || ' (exp.from_time/86400)) interval_date '
2410: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2411: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '
2412: || ' gmp_resource_instances'||p_db_link||' gri '
2413: || ' WHERE crd.organization_id = :orgn_id7 '
2414: || ' AND nvl(crd.calendar_code,:g_default_cal_code7)=:l_cal_code7'
2415: || ' AND exp.calendar_code = :curr_cal2 '

Line 2433: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '

2429: || ' 1 , '
2430: || ' (exp.shift_date + '
2431: || ' (exp.to_time/86400)) interval_date '
2432: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2433: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '
2434: || ' gmp_resource_instances'||p_db_link||' gri '
2435: || ' WHERE crd.organization_id = :orgn_id8 '
2436: || ' AND nvl(crd.calendar_code,:g_default_cal_code8)=:l_cal_code8'
2437: || ' AND exp.calendar_code = :curr_cal3 '