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.GMD_ROUTING_DESIGNER_PKG dependencies on GMD_ROUTINGS

Line 247: l_routings_step_dep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

243: l_message_list VARCHAR2(2000);
244: l_message VARCHAR2(1000);
245: l_dummy NUMBER;
246: INSERT_STEP_DEP_EXCEPTION EXCEPTION;
247: l_routings_step_dep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
248:
249: BEGIN
250:
251: x_return_code := 'S';

Line 361: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;

357: l_message VARCHAR2(1000);
358: l_dummy NUMBER;
359: UPDATE_STEP_DEP_EXCEPTION EXCEPTION;
360: RECORD_CHANGED_EXCEPTION EXCEPTION;
361: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;
362:
363: CURSOR Cur_Get_Step_Dep IS
364: SELECT *
365: FROM fm_rout_dep

Line 611: FROM gmd_routings

607: x_return_code OUT NOCOPY VARCHAR2,
608: x_error_msg OUT NOCOPY VARCHAR2) IS
609: CURSOR Cur_get_routing IS
610: SELECT *
611: FROM gmd_routings
612: WHERE routing_id = p_routing_id AND
613: last_update_date = p_last_update_date_orig;
614:
615: UPDATE_ROUTING_EXCEPTION EXCEPTION;

Line 619: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;

615: UPDATE_ROUTING_EXCEPTION EXCEPTION;
616: RECORD_CHANGED_EXCEPTION EXCEPTION;
617: l_rec Cur_get_routing%ROWTYPE;
618: l_enforce_step_dep NUMBER;
619: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;
620: l_return_status VARCHAR2(2);
621: l_msg_count NUMBER;
622: l_msg_data VARCHAR2(2000);
623: l_message_count NUMBER;

Line 697: GMD_ROUTINGS_PUB.update_routing

693: l_update_table(17).p_col_to_update := 'last_update_login';
694: l_update_table(17).p_value := p_user_id;
695:
696:
697: GMD_ROUTINGS_PUB.update_routing
698: ( p_api_version => 1
699: , p_init_msg_list => TRUE
700: , p_commit => FALSE
701: , p_routing_id => p_routing_id

Line 722: GMD_ROUTINGS_B

718: IF l_rec.routing_no <> p_routing_no OR
719: l_rec.routing_vers <> p_routing_vers THEN
720:
721: UPDATE
722: GMD_ROUTINGS_B
723: SET
724: routing_no = p_routing_no,
725: routing_vers = p_routing_vers
726: WHERE

Line 909: l_routings_step_dep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

905: l_message_list VARCHAR2(2000);
906: l_message VARCHAR2(1000);
907: l_dummy NUMBER;
908: INSERT_STEP_EXCEPTION EXCEPTION;
909: l_routings_step_dep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
910:
911: BEGIN
912:
913: x_error_msg := '';

Line 1016: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;

1012: l_message_count NUMBER;
1013: l_message_list VARCHAR2(2000);
1014: l_message VARCHAR2(1000);
1015: l_dummy NUMBER;
1016: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;
1017: UPDATE_STEP_EXCEPTION EXCEPTION;
1018: RECORD_CHANGED_EXCEPTION EXCEPTION;
1019:
1020: CURSOR Cur_get_step IS

Line 1172: l_routing_rec GMD_ROUTINGS%ROWTYPE;

1168: l_owner_orgn_id VARCHAR2(4);
1169: l_timestamp DATE;
1170: l_routing_no VARCHAR2(32);
1171: l_enforce_step_dependency NUMBER;
1172: l_routing_rec GMD_ROUTINGS%ROWTYPE;
1173: INSERT_ROUTING_EXCEPTION EXCEPTION;
1174:
1175: l_message_count NUMBER;
1176: l_message_list VARCHAR2(2000);

Line 1269: GMD_ROUTINGS_PVT.insert_routing ( p_routings => l_routing_rec

1265: l_routing_rec.last_update_date := p_last_update_date;
1266: l_routing_rec.last_updated_by := p_user_id;
1267: l_routing_rec.last_update_login := p_user_id;
1268:
1269: GMD_ROUTINGS_PVT.insert_routing ( p_routings => l_routing_rec
1270: , x_message_count => l_message_count
1271: , x_message_list => l_message_list
1272: , x_return_status => l_return_status);
1273:

Line 1487: FROM gmd_routings

1483: FROM FND_DUAL;
1484:
1485: CURSOR Cur_get_hdr IS
1486: SELECT *
1487: FROM gmd_routings
1488: WHERE routing_id = p_copy_from_routing_id;
1489:
1490: CURSOR Cur_get_dtl IS
1491: SELECT *

Line 1604: l_table_lnk := 'gmd_routings' || '|' || x_routing_id;

1600:
1601: FOR i IN 1..l_hdr_text_tbl.COUNT LOOP
1602:
1603: l_txt_ind := l_txt_ind + 1;
1604: l_table_lnk := 'gmd_routings' || '|' || x_routing_id;
1605:
1606: -- Create routing header text
1607: GMD_RECIPE_DESIGNER_PKG.Create_Text_Row
1608: (p_text_code => l_text_code,

Line 1630: GMD_ROUTINGS_PKG.INSERT_ROW(

1626: END IF;
1627:
1628: -- Insert routing header record
1629:
1630: GMD_ROUTINGS_PKG.INSERT_ROW(
1631: X_ROWID => l_rowid,
1632: X_ROUTING_ID => x_routing_id,
1633: X_OWNER_ORGANIZATION_ID => X_HDR_rec.owner_organization_id,
1634: X_ROUTING_NO => p_routing_no,

Line 2271: FROM gmd_routings

2267: x_error_msg OUT NOCOPY VARCHAR2) IS
2268:
2269: CURSOR Cur_get_routing IS
2270: SELECT *
2271: FROM gmd_routings
2272: WHERE routing_id = p_routing_id AND
2273: last_update_date = p_last_update_date_orig;
2274:
2275: DELETE_ROUTING_EXCEPTION EXCEPTION;

Line 2300: GMD_ROUTINGS_PUB.delete_routing

2296: END IF;
2297:
2298: CLOSE Cur_get_routing;
2299:
2300: GMD_ROUTINGS_PUB.delete_routing
2301: ( p_api_version => 1
2302: , p_init_msg_list => TRUE
2303: , p_commit => TRUE
2304: , p_routing_id => p_routing_id

Line 2370: FROM gmd_routings

2366: x_error_msg OUT NOCOPY VARCHAR2) IS
2367:
2368: CURSOR Cur_get_routing IS
2369: SELECT *
2370: FROM gmd_routings
2371: WHERE routing_id = p_routing_id AND
2372: last_update_date = p_last_update_date_orig;
2373:
2374: UNDELETE_ROUTING_EXCEPTION EXCEPTION;

Line 2397: GMD_ROUTINGS_PUB.undelete_routing

2393: RAISE RECORD_CHANGED_EXCEPTION;
2394: END IF;
2395: CLOSE Cur_get_routing;
2396:
2397: GMD_ROUTINGS_PUB.undelete_routing
2398: ( p_api_version => 1
2399: , p_init_msg_list => TRUE
2400: , p_commit => TRUE
2401: , p_routing_id => p_routing_id

Line 2463: FROM gmd_routings_b

2459: x_return_code OUT NOCOPY VARCHAR2) IS
2460:
2461: CURSOR Cur_get_rout_orgn IS
2462: SELECT owner_organization_id
2463: FROM gmd_routings_b
2464: WHERE routing_id = p_routing_id;
2465:
2466: l_orgn_id NUMBER;
2467: l_return_status VARCHAR2(10);