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.

[Home] [Help]

APPS.GMP_APS_DS_PULL dependencies on GMP_CALENDAR_PKG

Line 952: IF gmp_calendar_pkg.org_string(pinstance_id) THEN

948: v_cp_enabled := FALSE;
949: END IF;
950:
951: /* populate the org_string */
952: IF gmp_calendar_pkg.org_string(pinstance_id) THEN
953: NULL ;
954: ELSE
955: RAISE invalid_string_value ;
956: END IF;

Line 1125: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

1121: that has already completed should not be passed.And hence added a where clause to filter these rows*/
1122: || ' AND gbsi.batch_id = gbs.batch_id (+) ' /* 2919303 */
1123: || ' AND gbsi.batchstep_id = gbs.batchstep_id (+)'; /* 2919303 */
1124:
1125: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1126: v_prod_cursor := v_prod_cursor
1127: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1128: END IF;
1129:

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

1123: || ' AND gbsi.batchstep_id = gbs.batchstep_id (+)'; /* 2919303 */
1124:
1125: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1126: v_prod_cursor := v_prod_cursor
1127: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1128: END IF;
1129:
1130: -- For alcoa Issue 13097786 Starts
1131: IF v_Overyielded_wip = 0 THEN

Line 1262: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

1258: || ' AND uom.uom_class = :gmp_uom_class '
1259: || ' AND uom.uom_code = gs.usage_um ' /* Sowmya - Alternate Resources */
1260: || ' AND uom2.uom_code = r.step_qty_um ' ;
1261:
1262: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1263: v_rsrc_cursor := v_rsrc_cursor
1264: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1265: END IF;
1266:

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

1260: || ' AND uom2.uom_code = r.step_qty_um ' ;
1261:
1262: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1263: v_rsrc_cursor := v_rsrc_cursor
1264: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1265: END IF;
1266:
1267: -- For alcoa Issue 13097786 Starts
1268: IF v_Overyielded_wip = 0 THEN

Line 1337: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

1333: ||' AND crd.resources = gbsc.resources '
1334: ||' AND crd.organization_id = h.organization_id '
1335: ||' AND gbs.step_status in (1, 2) ';
1336:
1337: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1338: stp_chg_cursor := stp_chg_cursor
1339: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1340: END IF;
1341:

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

1335: ||' AND gbs.step_status in (1, 2) ';
1336:
1337: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1338: stp_chg_cursor := stp_chg_cursor
1339: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1340: END IF;
1341:
1342: -- For alcoa Issue 13097786 Starts
1343: IF v_Overyielded_wip = 0 THEN

Line 1370: log_message(gmp_calendar_pkg.g_in_str_org);

1366: CLOSE c_chg_cursor ;
1367: stp_chg_count := stp_chg_count - 1;
1368: log_message('Batch Step charge size is = '|| to_char(stp_chg_count) );
1369: time_stamp ;
1370: log_message(gmp_calendar_pkg.g_in_str_org);
1371:
1372: /* NAVIN :- alternate resource */
1373: /* NAVIN: In Procedure production_orders just before starting the looping for prod_dtl cursor
1374: try to get all the alternate Resources.*/

Line 1463: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

1459: || 'WHERE '
1460: || ' sy.orgn_code = :p1'
1461: || ' AND sy.resource_whse_code = iwm.whse_code';
1462:
1463: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1464: v_sql_stmt := v_sql_stmt
1465: ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1466: END IF;
1467:

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

1461: || ' AND sy.resource_whse_code = iwm.whse_code';
1462:
1463: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
1464: v_sql_stmt := v_sql_stmt
1465: ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ;
1466: END IF;
1467:
1468: OPEN rsrc_whse FOR v_sql_stmt USING prod_tab(p).plant_code;
1469: FETCH rsrc_whse INTO res_whse_id;

Line 2684: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

2680: ||' AND som.delete_mark = 0 '
2681: ||' AND som.resource_whse_code = iwm.whse_code ' ; */
2682: /* nsinghi INVCONV End */
2683:
2684: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
2685: sql_stmt := sql_stmt
2686: /* nsinghi INVCONV Start */
2687: /* ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ; */
2688: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

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

2683:
2684: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
2685: sql_stmt := sql_stmt
2686: /* nsinghi INVCONV Start */
2687: /* ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ; */
2688: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
2689: /* nsinghi INVCONV End */
2690: END IF;
2691:

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

2684: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
2685: sql_stmt := sql_stmt
2686: /* nsinghi INVCONV Start */
2687: /* ||' AND iwm.mtl_organization_id ' || gmp_calendar_pkg.g_in_str_org ; */
2688: ||' AND h.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
2689: /* nsinghi INVCONV End */
2690: END IF;
2691:
2692: EXECUTE IMMEDIATE sql_stmt USING pinstance_id;

Line 4586: IF gmp_calendar_pkg.org_string(pinstance_id) THEN

4582: prev_fcst_set := '-1' ;
4583: prev_fcst := '-1';
4584:
4585: /* populate the org_string */
4586: IF gmp_calendar_pkg.org_string(pinstance_id) THEN
4587: NULL ;
4588: ELSE
4589: RAISE invalid_string_value ;
4590: END IF;

Line 4612: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

4608: || ' fc_fcst_dtl'||pdblink||' d '
4609: || ' WHERE '
4610: || ' msi.organization_id = wm.mtl_organization_id ' ;
4611:
4612: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
4613: l_fcst_stmt := l_fcst_stmt
4614: || ' and msi.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
4615: END IF;
4616:

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

4610: || ' msi.organization_id = wm.mtl_organization_id ' ;
4611:
4612: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
4613: l_fcst_stmt := l_fcst_stmt
4614: || ' and msi.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
4615: END IF;
4616:
4617: l_fcst_stmt := l_fcst_stmt
4618: || ' and msi.segment1 = iim.item_no '

Line 5870: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

5866: ||' AND gbo.delete_mark = 0 '
5867: ||' AND gbo.so_line_id = ool.line_id '
5868: ||' AND ool.project_id = ppp.project_id (+) ';
5869:
5870: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
5871: v_stmt_alt_rsrc := v_stmt_alt_rsrc
5872: -- ||'
5873: /*Sowmya - INVCONV - Start*/
5874: /* ||' AND EXISTS ( SELECT 1 FROM sy_orgn_mst'||pdblink||' som '

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

5873: /*Sowmya - INVCONV - Start*/
5874: /* ||' AND EXISTS ( SELECT 1 FROM sy_orgn_mst'||pdblink||' som '
5875: ||' WHERE gia.whse_code = som.resource_whse_code )' ;
5876: */
5877: ||' AND msi.organization_id '|| gmp_calendar_pkg.g_in_str_org;
5878: /*Sowmya - INVCONV - End*/
5879: END IF;
5880:
5881: EXECUTE IMMEDIATE v_stmt_alt_rsrc USING