DBA Data[Home] [Help]

APPS.GMD_ROUTINGS_PVT dependencies on GMD_API_GRP

Line 57: IF NOT gmd_api_grp.setup_done THEN

53:
54: BEGIN
55:
56: /* Intialize the setup fields */
57: IF NOT gmd_api_grp.setup_done THEN
58: gmd_api_grp.setup_done := gmd_api_grp.setup;
59: END IF;
60: IF NOT gmd_api_grp.setup_done THEN
61: RAISE setup_failure;

Line 58: gmd_api_grp.setup_done := gmd_api_grp.setup;

54: BEGIN
55:
56: /* Intialize the setup fields */
57: IF NOT gmd_api_grp.setup_done THEN
58: gmd_api_grp.setup_done := gmd_api_grp.setup;
59: END IF;
60: IF NOT gmd_api_grp.setup_done THEN
61: RAISE setup_failure;
62: END IF;

Line 60: IF NOT gmd_api_grp.setup_done THEN

56: /* Intialize the setup fields */
57: IF NOT gmd_api_grp.setup_done THEN
58: gmd_api_grp.setup_done := gmd_api_grp.setup;
59: END IF;
60: IF NOT gmd_api_grp.setup_done THEN
61: RAISE setup_failure;
62: END IF;
63: /* Set the return status to success initially */
64: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 129: x_created_by => gmd_api_grp.user_id,

125: x_owner_id => p_routings.owner_id,
126: x_project_id => p_routings.project_id,
127: x_process_loss => p_routings.process_loss,
128: x_creation_date => NVL(p_routings.creation_date,SYSDATE),
129: x_created_by => gmd_api_grp.user_id,
130: x_last_update_date => NVL(p_routings.last_update_date,SYSDATE),
131: x_last_updated_by => gmd_api_grp.user_id,
132: x_last_update_login => p_routings.last_update_login,
133: x_fixed_process_loss => p_routings.fixed_process_loss, /* RLNAGARA B6997624*/

Line 131: x_last_updated_by => gmd_api_grp.user_id,

127: x_process_loss => p_routings.process_loss,
128: x_creation_date => NVL(p_routings.creation_date,SYSDATE),
129: x_created_by => gmd_api_grp.user_id,
130: x_last_update_date => NVL(p_routings.last_update_date,SYSDATE),
131: x_last_updated_by => gmd_api_grp.user_id,
132: x_last_update_login => p_routings.last_update_login,
133: x_fixed_process_loss => p_routings.fixed_process_loss, /* RLNAGARA B6997624*/
134: x_fixed_process_loss_uom => p_routings.fixed_process_loss_uom /* RLNAGARA B6997624*/
135: );

Line 274: IF NOT gmd_api_grp.setup_done THEN

270: vr.delete_mark = 0;
271:
272: BEGIN
273: /* Intialize the setup fields */
274: IF NOT gmd_api_grp.setup_done THEN
275: gmd_api_grp.setup_done := gmd_api_grp.setup;
276: END IF;
277: IF NOT gmd_api_grp.setup_done THEN
278: RAISE setup_failure;

Line 275: gmd_api_grp.setup_done := gmd_api_grp.setup;

271:
272: BEGIN
273: /* Intialize the setup fields */
274: IF NOT gmd_api_grp.setup_done THEN
275: gmd_api_grp.setup_done := gmd_api_grp.setup;
276: END IF;
277: IF NOT gmd_api_grp.setup_done THEN
278: RAISE setup_failure;
279: END IF;

Line 277: IF NOT gmd_api_grp.setup_done THEN

273: /* Intialize the setup fields */
274: IF NOT gmd_api_grp.setup_done THEN
275: gmd_api_grp.setup_done := gmd_api_grp.setup;
276: END IF;
277: IF NOT gmd_api_grp.setup_done THEN
278: RAISE setup_failure;
279: END IF;
280:
281: /* Set the return status to success initially */

Line 364: l_old_routing_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;

360: l_old_routing_rec.ROUTING_DESC := p_update_table(i).p_value;
361: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'DELETE_MARK') THEN
362: l_old_routing_rec.DELETE_MARK := p_update_table(i).p_value;
363: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATED_BY') THEN
364: l_old_routing_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;
365: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_DATE') THEN
366: l_old_routing_rec.LAST_UPDATE_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);
367: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_LOGIN') THEN
368: l_old_routing_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;

Line 368: l_old_routing_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;

364: l_old_routing_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;
365: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_DATE') THEN
366: l_old_routing_rec.LAST_UPDATE_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);
367: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_LOGIN') THEN
368: l_old_routing_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;
369: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE1') THEN
370: l_old_routing_rec.ATTRIBUTE1 := p_update_table(i).p_value;
371: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE2') THEN
372: l_old_routing_rec.ATTRIBUTE2 := p_update_table(i).p_value;

Line 551: x_last_updated_by => gmd_api_grp.user_id,

547: x_process_loss => l_old_routing_rec.process_loss,
548: x_routing_status => l_old_routing_rec.routing_status,
549: x_routing_desc => l_old_routing_rec.routing_desc,
550: x_last_update_date => NVL(l_old_routing_rec.last_update_date,SYSDATE),
551: x_last_updated_by => gmd_api_grp.user_id,
552: x_last_update_login => l_old_routing_rec.last_update_login,
553: x_fixed_process_loss => l_old_routing_rec.fixed_process_loss, --RLNAGARA B6997624
554: x_fixed_process_loss_uom => l_old_routing_rec.fixed_process_loss_uom --RLNAGARA B6997624
555: );