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 986: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '

982: || ' ((crd.resource_id*2)+1), '
983: || ' 2, '
984: || ' :instance_id, '
985: || ' crd.assigned_qty '
986: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '
987: || ' mtl_parameters'||p_db_link||' m, '
988: || ' cr_rsrc_dtl'||p_db_link||' crd '
989: || ' WHERE NVL(crd.calendar_code,m.calendar_code) = gtmp.calendar_code '
990: || ' AND m.organization_id = crd.organization_id '

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

1386: CLOSE cal_cur;
1387:
1388: /* 12/13/02 - Rajesh Patangya B2710601, Added database link */
1389: wps_index := 1 ;
1390: ins_stmt := 'INSERT INTO gmp_calendar_detail_gtmp'||p_db_link
1391: ||' ( '
1392: ||' calendar_code, '
1393: ||' shift_num, '
1394: ||' shift_date, '

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

1472: || ' from_time, '
1473: || ' to_time, '
1474: || ' 2 , '
1475: || ' :instance_id '
1476: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp '
1477: || ' WHERE calendar_code = :curr_cal_code '
1478: || ' ORDER BY shift_num,from_time,to_time ';
1479:
1480: EXECUTE IMMEDIATE get_shift_time USING n_calendar_code,

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

1578:
1579: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
1580: instance_number inst_num ;
1581:
1582: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
1583: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
1584: shift_num shift_no ;
1585:
1586: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;

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

1579: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
1580: instance_number inst_num ;
1581:
1582: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
1583: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
1584: shift_num shift_no ;
1585:
1586: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1587: f_date f_dt ;

Line 1902: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '

1898: || ' (SELECT 1 '
1899: || ' FROM gmp_resource_instances'||p_db_link||' gri '
1900: || ' WHERE gri.resource_id = un.resource_id ) '
1901: || ' ) cmd, '
1902: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1903: || ' WHERE exp.calendar_code = :CAL91 '
1904: || ' AND cmd.interval_date BETWEEN '
1905: || ' exp.from_date AND exp.to_date '
1906: || ' UNION ALL '

Line 1914: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '

1910: || ' 0 , '
1911: || ' exp.from_date interval_date, '
1912: || ' crd.assigned_qty assigned_qty '
1913: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1914: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1915: || ' WHERE crd.delete_mark = 0 '
1916: || ' AND crd.organization_id = :orgn_id10 '
1917: || ' AND nvl(crd.calendar_code,:g_default_code10)=:l_cal_code10 ';
1918:

Line 1933: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '

1929: || ' 0 , '
1930: || ' exp.to_date interval_date, '
1931: || ' crd.assigned_qty assigned_qty '
1932: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1933: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1934: || ' WHERE crd.delete_mark = 0 '
1935: || ' AND crd.organization_id = :orgn_id11 '
1936: || ' AND nvl(crd.calendar_code,:g_default_code11)=:l_cal_code11 ';
1937:

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

2571:
2572: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
2573: instance_number inst_num ;
2574:
2575: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
2576: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
2577: shift_num shift_no ;
2578:
2579: TYPE f_dt IS TABLE OF mr_shcl_dtl.calendar_date%TYPE;

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

2572: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
2573: instance_number inst_num ;
2574:
2575: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
2576: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
2577: shift_num shift_no ;
2578:
2579: TYPE f_dt IS TABLE OF mr_shcl_dtl.calendar_date%TYPE;
2580: f_date f_dt ;

Line 2819: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '

2815: || ' WHERE tgri.resource_id = crd.resource_id '
2816: || ' AND rownum <= un.resource_units '
2817: || ' ) '
2818: || ' ) cmd, '
2819: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
2820: || ' WHERE exp.calendar_code = :curr_cal1 '
2821: || ' AND cmd.interval_date BETWEEN '
2822: || ' exp.from_date AND exp.to_date '
2823: || ' UNION ALL '

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

2827: || ' 1 , '
2828: || ' (exp.shift_date + '
2829: || ' (exp.from_time/86400)) interval_date '
2830: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2831: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '
2832: || ' gmp_resource_instances'||p_db_link||' gri '
2833: || ' WHERE crd.organization_id = :orgn_id7 '
2834: || ' AND nvl(crd.calendar_code,:g_default_cal_code7)=:l_cal_code7'
2835: || ' AND exp.calendar_code = :curr_cal2 '

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

2849: || ' 1 , '
2850: || ' (exp.shift_date + '
2851: || ' (exp.to_time/86400)) interval_date '
2852: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2853: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '
2854: || ' gmp_resource_instances'||p_db_link||' gri '
2855: || ' WHERE crd.organization_id = :orgn_id8 '
2856: || ' AND nvl(crd.calendar_code,:g_default_cal_code8)=:l_cal_code8'
2857: || ' AND exp.calendar_code = :curr_cal3 '