[Home] [Help]
120: END IF;
121:
122: /* Insert header record */
123: -- BUG 5197863 Added NVL to effective end date
124: GMD_ROUTINGS_PKG.INSERT_ROW(
125: X_ROWID => x_hdr_rec.ROW_ID,
126: X_ROUTING_ID => x_routing_id,
127: X_owner_organization_id => x_hdr_rec.owner_organization_id,
128: X_ROUTING_NO => x_hdr_rec.ROUTING_NO,
231: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
232: gmd_api_grp.get_status_details (V_entity_type => 'ROUTING',
233: V_orgn_id => x_hdr_rec.owner_organization_id,
234: X_entity_status => l_entity_status);
235: --Add this code after the call to gmd_routings_pkg.insert_row.
236: IF (l_entity_status.entity_status <> 100) THEN
237: Gmd_status_pub.modify_status ( p_api_version => 1
238: , p_init_msg_list => TRUE
239: , p_entity_name =>'ROUTING'
532: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
533: gmd_api_grp.get_status_details (V_entity_type => 'OPERATION',
534: V_orgn_id => x_hdr_rec.owner_organization_id,
535: X_entity_status => l_entity_status);
536: --Add this code after the call to gmd_routings_pkg.insert_row.
537: IF (l_entity_status.entity_status <> 100) THEN
538: Gmd_status_pub.modify_status ( p_api_version => 1
539: , p_init_msg_list => TRUE
540: , p_entity_name =>'OPERATION'
1003: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
1004: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',
1005: V_orgn_id => NVL(p_Organization_id, X_hdr_rec.owner_organization_id),
1006: X_entity_status => l_entity_status);
1007: --Add this code after the call to gmd_routings_pkg.insert_row.
1008: IF (l_entity_status.entity_status <> 100) THEN
1009: Gmd_status_pub.modify_status ( p_api_version => 1
1010: , p_init_msg_list => TRUE
1011: , p_entity_name =>'RECIPE'