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_APS_DS_PULL dependencies on GMP_CALENDAR_PKG

Line 935: IF gmp_calendar_pkg.org_string(pinstance_id) THEN

931: v_cp_enabled := FALSE;
932: END IF;
933:
934: /* populate the org_string */
935: IF gmp_calendar_pkg.org_string(pinstance_id) THEN
936: NULL ;
937: ELSE
938: RAISE invalid_string_value ;
939: END IF;

Line 1061: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

1057: that has already completed should not be passed.And hence added a where clause to filter these rows*/
1058: || ' AND gbsi.batch_id = gbs.batch_id (+) ' /* 2919303 */
1059: || ' AND gbsi.batchstep_id = gbs.batchstep_id (+)'; /* 2919303 */
1060:
1061: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1062: v_prod_cursor := v_prod_cursor
1063: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1064: END IF;
1065:

Line 1063: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

1059: || ' AND gbsi.batchstep_id = gbs.batchstep_id (+)'; /* 2919303 */
1060:
1061: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1062: v_prod_cursor := v_prod_cursor
1063: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1064: END IF;
1065:
1066: v_prod_cursor := v_prod_cursor
1067: || ' AND h.batch_status in (1, 2)'

Line 1180: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

1176: || ' AND uom.uom_class = :gmp_uom_class '
1177: || ' AND uom.uom_code = gs.usage_um ' /* Sowmya - Alternate Resources */
1178: || ' AND uom2.uom_code = r.step_qty_um ' ;
1179:
1180: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1181: v_rsrc_cursor := v_rsrc_cursor
1182: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1183: END IF;
1184:

Line 1182: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

1178: || ' AND uom2.uom_code = r.step_qty_um ' ;
1179:
1180: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1181: v_rsrc_cursor := v_rsrc_cursor
1182: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1183: END IF;
1184:
1185: v_rsrc_cursor := v_rsrc_cursor
1186: || ' AND go.oprn_id = r.oprn_id '

Line 1240: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

1236: ||' AND crd.resources = gbsc.resources '
1237: ||' AND crd.organization_id = h.organization_id '
1238: ||' AND gbs.step_status in (1, 2) ';
1239:
1240: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1241: stp_chg_cursor := stp_chg_cursor
1242: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1243: END IF;
1244:

Line 1242: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

1238: ||' AND gbs.step_status in (1, 2) ';
1239:
1240: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1241: stp_chg_cursor := stp_chg_cursor
1242: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1243: END IF;
1244:
1245: stp_chg_cursor := stp_chg_cursor
1246: ||' ORDER BY 1, 2, 3, 4 ' ;

Line 1258: log_message(gmp_calendar_pkg.g_in_str_org);

1254: CLOSE c_chg_cursor ;
1255: stp_chg_count := stp_chg_count - 1;
1256: log_message('Batch Step charge size is = '|| to_char(stp_chg_count) );
1257: time_stamp ;
1258: log_message(gmp_calendar_pkg.g_in_str_org);
1259:
1260: /* NAVIN :- alternate resource */
1261: /* NAVIN: In Procedure production_orders just before starting the looping for prod_dtl cursor
1262: try to get all the alternate Resources.*/

Line 1347: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

1343: || 'WHERE '
1344: || ' sy.orgn_code = :p1'
1345: || ' AND sy.resource_whse_code = iwm.whse_code';
1346:
1347: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1348: v_sql_stmt := v_sql_stmt
1349: ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1350: END IF;
1351:

Line 1349: ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ;

1345: || ' AND sy.resource_whse_code = iwm.whse_code';
1346:
1347: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1348: v_sql_stmt := v_sql_stmt
1349: ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1350: END IF;
1351:
1352: OPEN rsrc_whse FOR v_sql_stmt USING prod_tab(p).plant_code;
1353: FETCH rsrc_whse INTO res_whse_id;

Line 2438: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

2434: ||' AND som.delete_mark = 0 '
2435: ||' AND som.resource_whse_code = iwm.whse_code ' ; */
2436: /* nsinghi INVCONV End */
2437:
2438: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
2439: sql_stmt := sql_stmt
2440: /* nsinghi INVCONV Start */
2441: /* ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ; */
2442: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

Line 2441: /* ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ; */

2437:
2438: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
2439: sql_stmt := sql_stmt
2440: /* nsinghi INVCONV Start */
2441: /* ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ; */
2442: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
2443: /* nsinghi INVCONV End */
2444: END IF;
2445:

Line 2442: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

2438: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
2439: sql_stmt := sql_stmt
2440: /* nsinghi INVCONV Start */
2441: /* ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ; */
2442: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
2443: /* nsinghi INVCONV End */
2444: END IF;
2445:
2446: EXECUTE IMMEDIATE sql_stmt USING pinstance_id;

Line 4340: IF gmp_calendar_pkg.org_string(pinstance_id) THEN

4336: prev_fcst_set := '-1' ;
4337: prev_fcst := '-1';
4338:
4339: /* populate the org_string */
4340: IF gmp_calendar_pkg.org_string(pinstance_id) THEN
4341: NULL ;
4342: ELSE
4343: RAISE invalid_string_value ;
4344: END IF;

Line 4366: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

4362: || ' fc_fcst_dtl'||pdblink||' d '
4363: || ' WHERE '
4364: || ' msi.organization_id = wm.mtl_organization_id ' ;
4365:
4366: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
4367: l_fcst_stmt := l_fcst_stmt
4368: || ' and msi.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
4369: END IF;
4370:

Line 4368: || ' and msi.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

4364: || ' msi.organization_id = wm.mtl_organization_id ' ;
4365:
4366: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
4367: l_fcst_stmt := l_fcst_stmt
4368: || ' and msi.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
4369: END IF;
4370:
4371: l_fcst_stmt := l_fcst_stmt
4372: || ' and msi.segment1 = iim.item_no '

Line 5624: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

5620: ||' AND gbo.delete_mark = 0 '
5621: ||' AND gbo.so_line_id = ool.line_id '
5622: ||' AND ool.project_id = ppp.project_id (+) ';
5623:
5624: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
5625: v_stmt_alt_rsrc := v_stmt_alt_rsrc
5626: -- ||'
5627: /*Sowmya - INVCONV - Start*/
5628: /* ||' AND EXISTS ( SELECT 1 FROM sy_orgn_mst'||pdblink||' som '

Line 5631: ||' AND msi.organization_id '|| gmp_calendar_pkg.g_in_str_org;

5627: /*Sowmya - INVCONV - Start*/
5628: /* ||' AND EXISTS ( SELECT 1 FROM sy_orgn_mst'||pdblink||' som '
5629: ||' WHERE gia.whse_code = som.resource_whse_code )' ;
5630: */
5631: ||' AND msi.organization_id '|| gmp_calendar_pkg.g_in_str_org;
5632: /*Sowmya - INVCONV - End*/
5633: END IF;
5634:
5635: EXECUTE IMMEDIATE v_stmt_alt_rsrc USING