DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on FND_GLOBAL

Line 956: l_user_id NUMBER := FND_GLOBAL.USER_ID;

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

Line 1064: ,p_parameter_value6 =>FND_GLOBAL.user_name

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

Line 1189: l_user_id NUMBER := FND_GLOBAL.USER_ID;

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

Line 1265: ,p_parameter_value6 =>FND_GLOBAL.user_name

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

Line 1380: l_user_id NUMBER := FND_GLOBAL.USER_ID;

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

Line 1454: ,p_parameter_value6 =>FND_GLOBAL.user_name

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

Line 1571: l_user_id NUMBER := FND_GLOBAL.USER_ID;

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

Line 1730: ,p_parameter_value6 =>FND_GLOBAL.user_name

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

Line 1873: l_user_id NUMBER := FND_GLOBAL.USER_ID;

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

Line 1974: ,p_parameter_value6 =>FND_GLOBAL.user_name

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

Line 2084: last_updated_by = fnd_global.user_id

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

Line 2139: ,p_parameter_value6 =>FND_GLOBAL.user_name

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