DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on 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 1048: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.formula.sts'

1044: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1045:
1046: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_FORM_USR_LBL');
1047: l_user_key_label := FND_MESSAGE.GET;
1048: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.formula.sts'
1049: ,p_event_key => p_formula_id
1050: ,p_parameter_name1 => 'DEFERRED'
1051: ,p_parameter_value1 => 'Y'
1052: ,p_parameter_name2 => 'POST_OPERATION_API'

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 1249: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.operation.sts'

1245:
1246: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_OPER_USR_LBL');
1247: l_user_key_label := FND_MESSAGE.GET;
1248:
1249: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.operation.sts'
1250: ,p_event_key => p_oprn_id
1251: ,p_parameter_name1 => 'DEFERRED'
1252: ,p_parameter_value1 => 'Y'
1253: ,p_parameter_name2 => 'POST_OPERATION_API'

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 1438: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.routing.sts'

1434: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1435:
1436: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_ROUT_USR_LBL');
1437: l_user_key_label := FND_MESSAGE.GET;
1438: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.routing.sts'
1439: ,p_event_key => p_routing_id
1440: ,p_parameter_name1 => 'DEFERRED'
1441: ,p_parameter_value1 => 'Y'
1442: ,p_parameter_name2 => 'POST_OPERATION_API'

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 1717: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.recipe.sts'

1713: IF GMD_RECIPE_GENERATE.create_validity THEN
1714: l_post_operation_api := l_post_operation_api||', '||1;
1715: END IF;
1716: l_post_operation_api := l_post_operation_api||');';
1717: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.recipe.sts'
1718: ,p_event_key => p_recipe_id
1719: ,p_parameter_name1 => 'DEFERRED'
1720: ,p_parameter_value1 => 'Y'
1721: ,p_parameter_name2 => 'POST_OPERATION_API'

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 1958: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.validity.sts'

1954: CLOSE Cur_get_recipe_info;
1955:
1956: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_VLD_USR_LBL');
1957: l_user_key_label := FND_MESSAGE.GET;
1958: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.validity.sts'
1959: ,p_event_key => P_validity_rule_id
1960: ,p_parameter_name1 => 'DEFERRED'
1961: ,p_parameter_value1 => 'Y'
1962: ,p_parameter_name2 => 'POST_OPERATION_API'

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

Line 2123: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.itemsub.sts'

2119:
2120: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_SUBSTITUTION_USR_LBL');
2121: l_user_key_label := FND_MESSAGE.GET;
2122:
2123: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.itemsub.sts'
2124: ,p_event_key => p_substitution_id
2125: ,p_parameter_name1 => 'DEFERRED'
2126: ,p_parameter_value1 => 'Y'
2127: ,p_parameter_name2 => 'POST_OPERATION_API'