DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on FND_GLOBAL

Line 958: l_user_id NUMBER := FND_GLOBAL.USER_ID;

954: l_from_status_desc VARCHAR2(240);
955: l_to_status_desc VARCHAR2(240);
956: l_version_lbl VARCHAR2(2000);
957: l_text VARCHAR2(4000);
958: l_user_id NUMBER := FND_GLOBAL.USER_ID;
959: l_status VARCHAR2(2000);
960: l_esig_reqd BOOLEAN;
961: l_erec_reqd BOOLEAN;
962:

Line 1066: ,p_parameter_value6 =>FND_GLOBAL.user_name

1062: ,p_parameter_value4 => p_object_name||', '||p_object_version
1063: ,p_parameter_name5 => '#WF_SOURCE_APPLICATION_TYPE'
1064: ,p_parameter_value5 =>'DB'
1065: ,p_parameter_name6 => '#WF_SIGN_REQUESTER'
1066: ,p_parameter_value6 =>FND_GLOBAL.user_name
1067: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1068: ,p_parameter_value7=>-1);
1069:
1070: IF l_esig_reqd THEN

Line 1191: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1187: l_from_status_desc VARCHAR2(240);
1188: l_to_status_desc VARCHAR2(240);
1189: l_version_lbl VARCHAR2(2000);
1190: l_text VARCHAR2(4000);
1191: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1192: l_status VARCHAR2(2000);
1193: l_esig_reqd BOOLEAN;
1194: l_erec_reqd BOOLEAN;
1195:

Line 1267: ,p_parameter_value6 =>FND_GLOBAL.user_name

1263: ,p_parameter_value4 => p_object_name||', '||p_object_version
1264: ,p_parameter_name5 => '#WF_SOURCE_APPLICATION_TYPE'
1265: ,p_parameter_value5 =>'DB'
1266: ,p_parameter_name6 => '#WF_SIGN_REQUESTER'
1267: ,p_parameter_value6 =>FND_GLOBAL.user_name
1268: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1269: ,p_parameter_value7=>-1);
1270:
1271: IF l_esig_reqd THEN

Line 1382: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1378: l_from_status_desc VARCHAR2(240);
1379: l_to_status_desc VARCHAR2(240);
1380: l_version_lbl VARCHAR2(2000);
1381: l_text VARCHAR2(4000);
1382: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1383: l_status VARCHAR2(2000);
1384: l_esig_reqd BOOLEAN;
1385: l_erec_reqd BOOLEAN;
1386: PENDING_STATUS_ERR EXCEPTION;

Line 1456: ,p_parameter_value6 =>FND_GLOBAL.user_name

1452: ,p_parameter_value4 => p_object_name||', '||p_object_version
1453: ,p_parameter_name5 => '#WF_SOURCE_APPLICATION_TYPE'
1454: ,p_parameter_value5 =>'DB'
1455: ,p_parameter_name6 => '#WF_SIGN_REQUESTER'
1456: ,p_parameter_value6 =>FND_GLOBAL.user_name
1457: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1458: ,p_parameter_value7=>-1);
1459: IF l_esig_reqd THEN
1460: X_return_status := 'P';

Line 1573: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1569: l_from_status_desc VARCHAR2(240);
1570: l_to_status_desc VARCHAR2(240);
1571: l_version_lbl VARCHAR2(2000);
1572: l_text VARCHAR2(4000);
1573: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1574: l_status VARCHAR2(2000);
1575: l_esig_reqd BOOLEAN;
1576: l_erec_reqd BOOLEAN;
1577: l_status_type GMD_STATUS.status_type%TYPE;

Line 1732: ,p_parameter_value6 =>FND_GLOBAL.user_name

1728: ,p_parameter_value4 => p_object_name||', '||p_object_version
1729: ,p_parameter_name5 => '#WF_SOURCE_APPLICATION_TYPE'
1730: ,p_parameter_value5 =>'DB'
1731: ,p_parameter_name6 => '#WF_SIGN_REQUESTER'
1732: ,p_parameter_value6 =>FND_GLOBAL.user_name
1733: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1734: ,p_parameter_value7=>-1);
1735:
1736: IF (l_debug= 'Y') THEN

Line 1875: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1871: l_from_status_desc VARCHAR2(240);
1872: l_to_status_desc VARCHAR2(240);
1873: l_version_lbl VARCHAR2(2000);
1874: l_text VARCHAR2(4000);
1875: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1876: l_status VARCHAR2(2000);
1877: l_esig_reqd BOOLEAN;
1878: l_erec_reqd BOOLEAN;
1879:

Line 1976: ,p_parameter_value6 =>FND_GLOBAL.user_name

1972: ,p_parameter_value4 =>l_user_key_value
1973: ,p_parameter_name5 => '#WF_SOURCE_APPLICATION_TYPE'
1974: ,p_parameter_value5 =>'DB'
1975: ,p_parameter_name6 => '#WF_SIGN_REQUESTER'
1976: ,p_parameter_value6 =>FND_GLOBAL.user_name
1977: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1978: ,p_parameter_value7=>-1);
1979: IF l_esig_reqd THEN
1980: X_return_status := 'P';

Line 2086: last_updated_by = fnd_global.user_id

2082:
2083: UPDATE gmd_item_substitution_hdr_b
2084: SET substitution_status = p_to_status,
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

Line 2141: ,p_parameter_value6 =>FND_GLOBAL.user_name

2137: ,p_parameter_value4 => l_subs_details.substitution_name||', '||l_subs_details.substitution_version
2138: ,p_parameter_name5 => '#WF_SOURCE_APPLICATION_TYPE'
2139: ,p_parameter_value5 =>'DB'
2140: ,p_parameter_name6 => '#WF_SIGN_REQUESTER'
2141: ,p_parameter_value6 =>FND_GLOBAL.user_name
2142: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
2143: ,p_parameter_value7=>-1);
2144:
2145: IF l_esig_reqd THEN