DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on GMA_STANDARD

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

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

Line 907: GMA_STANDARD.psig_required (p_event => p_event

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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