DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on GMA_STANDARD

Line 867: GMA_STANDARD.psig_required (p_event => 'oracle.apps.gmd.validity.sts'

863: WHILE Cur_get_validity%FOUND LOOP
864: UPDATE gmd_recipe_validity_rules
865: SET validity_rule_status = p_to_status
866: WHERE recipe_validity_rule_id = l_recipe_validity_rule_id;
867: GMA_STANDARD.psig_required (p_event => 'oracle.apps.gmd.validity.sts'
868: ,p_event_key => l_recipe_validity_rule_id
869: ,p_status => l_status);
870: IF l_status THEN
871: ROLLBACK to Savepoint check_vr_required;

Line 909: GMA_STANDARD.psig_required (p_event => p_event

905: p_to_status IN VARCHAR2)
906: RETURN BOOLEAN IS
907: l_status BOOLEAN;
908: BEGIN
909: GMA_STANDARD.psig_required (p_event => p_event
910: ,p_event_key => p_event_key
911: ,p_status => l_status);
912: IF l_status THEN
913: RETURN TRUE;

Line 1017: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.formula.sts'

1013:
1014: END IF;
1015: -- End of Bug# 3497522
1016:
1017: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.formula.sts'
1018: ,p_event_key => p_formula_id
1019: ,p_status => l_esig_reqd);
1020:
1021: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.formula.sts'

Line 1021: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.formula.sts'

1017: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.formula.sts'
1018: ,p_event_key => p_formula_id
1019: ,p_status => l_esig_reqd);
1020:
1021: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.formula.sts'
1022: ,p_event_key => p_formula_id
1023: ,p_status => l_erec_reqd);
1024:
1025: IF (l_esig_reqd OR l_erec_reqd) THEN

Line 1217: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.operation.sts'

1213: last_update_date = sysdate,
1214: last_updated_by = l_user_id
1215: WHERE oprn_id = p_oprn_id;
1216:
1217: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.operation.sts'
1218: ,p_event_key => p_oprn_id
1219: ,p_status => l_esig_reqd);
1220:
1221: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.operation.sts'

Line 1221: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.operation.sts'

1217: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.operation.sts'
1218: ,p_event_key => p_oprn_id
1219: ,p_status => l_esig_reqd);
1220:
1221: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.operation.sts'
1222: ,p_event_key => p_oprn_id
1223: ,p_status => l_erec_reqd);
1224:
1225: IF (l_esig_reqd OR l_erec_reqd) THEN

Line 1407: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.routing.sts'

1403: last_update_date = sysdate,
1404: last_updated_by = l_user_id
1405: WHERE routing_id = p_routing_id;
1406:
1407: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.routing.sts'
1408: ,p_event_key => p_routing_id
1409: ,p_status => l_esig_reqd);
1410:
1411: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.routing.sts'

Line 1411: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.routing.sts'

1407: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.routing.sts'
1408: ,p_event_key => p_routing_id
1409: ,p_status => l_esig_reqd);
1410:
1411: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.routing.sts'
1412: ,p_event_key => p_routing_id
1413: ,p_status => l_erec_reqd);
1414:
1415: IF (l_esig_reqd OR l_erec_reqd) THEN

Line 1662: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.recipe.sts'

1658: last_update_date = sysdate,
1659: last_updated_by = l_user_id
1660: WHERE recipe_id = p_recipe_id;
1661:
1662: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.recipe.sts'
1663: ,p_event_key => p_recipe_id
1664: ,p_status => l_esig_reqd);
1665:
1666: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.recipe.sts'

Line 1666: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.recipe.sts'

1662: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.recipe.sts'
1663: ,p_event_key => p_recipe_id
1664: ,p_status => l_esig_reqd);
1665:
1666: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.recipe.sts'
1667: ,p_event_key => p_recipe_id
1668: ,p_status => l_erec_reqd);
1669:
1670: IF (l_debug= 'Y') THEN

Line 1910: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.validity.sts'

1906: last_update_date = sysdate,
1907: last_updated_by = l_user_id
1908: WHERE recipe_validity_rule_id = P_validity_rule_id;
1909:
1910: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.validity.sts'
1911: ,p_event_key => P_validity_rule_id
1912: ,p_status => l_esig_reqd);
1913:
1914: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.validity.sts'

Line 1914: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.validity.sts'

1910: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.validity.sts'
1911: ,p_event_key => P_validity_rule_id
1912: ,p_status => l_esig_reqd);
1913:
1914: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.validity.sts'
1915: ,p_event_key => P_validity_rule_id
1916: ,p_status => l_erec_reqd);
1917:
1918: IF (l_esig_reqd OR l_erec_reqd) THEN

Line 2089: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.itemsub.sts'

2085: last_update_date = sysdate,
2086: last_updated_by = fnd_global.user_id
2087: WHERE substitution_id = p_substitution_id;
2088:
2089: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.itemsub.sts'
2090: ,p_event_key => p_substitution_id
2091: ,p_status => l_esig_reqd);
2092:
2093: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.itemsub.sts'

Line 2093: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.itemsub.sts'

2089: GMA_STANDARD.PSIG_REQUIRED (p_event => 'oracle.apps.gmd.itemsub.sts'
2090: ,p_event_key => p_substitution_id
2091: ,p_status => l_esig_reqd);
2092:
2093: GMA_STANDARD.EREC_REQUIRED (p_event => 'oracle.apps.gmd.itemsub.sts'
2094: ,p_event_key => p_substitution_id
2095: ,p_status => l_erec_reqd);
2096:
2097: IF (l_esig_reqd OR l_erec_reqd) THEN