eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_PROCESS_PKG dependencies on STANDARD

Line 40: p_standard_process_flag VARCHAR2,

36:
37:
38: PROCEDURE Load_Row(
39: p_significant_process_flag VARCHAR2,
40: p_standard_process_flag VARCHAR2,
41: p_approval_status VARCHAR2,
42: p_certification_status VARCHAR2,
43: p_process_owner_id number,
44: p_last_update_date DATE,

Line 79: p_standard_variation number := null,

75: p_org_count number,
76: p_process_category varchar2 := null,
77: p_finance_owner_id number := null,
78: p_application_owner_id number := null,
79: p_standard_variation number := null,
80: px_object_version_number IN OUT NOCOPY NUMBER,
81: px_process_rev_id in out nocopy number,
82: px_process_id IN OUT NOCOPY NUMBER)
83:

Line 102: -- p_standard_process_flag => p_standard_process_flag,

98:
99: -- user_id := 1;
100: -- AMW_PROCESS_PKG.Update_Row (
101: -- p_significant_process_flag => p_significant_process_flag,
102: -- p_standard_process_flag => p_standard_process_flag,
103: -- p_approval_status => p_approval_status,
104: -- p_certification_status => p_certification_status,
105: -- p_process_owner_id => p_process_owner_id,
106: -- p_last_update_date => p_last_update_date,

Line 141: -- p_standard_variation => p_standard_variation,

137: -- p_org_count => p_org_count,
138: -- p_process_category => p_process_category,
139: -- p_finance_owner_id => p_finance_owner_id,
140: -- p_application_owner_id => p_application_owner_id,
141: -- p_standard_variation => p_standard_variation,
142: -- p_object_version_number => px_object_version_number,
143: -- p_process_rev_id => px_process_rev_id,
144: -- p_process_id => px_process_id);
145: --

Line 151: -- p_standard_process_flag => p_standard_process_flag,

147: -- when NO_DATA_FOUND then
148: --
149: -- AMW_PROCESS_PKG.Insert_Row(
150: -- p_significant_process_flag => p_significant_process_flag,
151: -- p_standard_process_flag => p_standard_process_flag,
152: -- p_approval_status => p_approval_status,
153: -- p_certification_status => p_certification_status,
154: -- p_process_owner_id => p_process_owner_id,
155: -- p_last_update_date => p_last_update_date,

Line 190: -- p_standard_variation => p_standard_variation,

186: -- p_org_count => p_org_count,
187: -- p_process_category => p_process_category,
188: -- p_finance_owner_id => p_finance_owner_id,
189: -- p_application_owner_id => p_application_owner_id,
190: -- p_standard_variation => p_standard_variation,
191: -- px_object_version_number => px_object_version_number,
192: -- px_process_rev_id => px_process_rev_id,
193: -- px_process_id => px_process_id);
194: -- end;

Line 220: p_STANDARD_PROCESS_FLAG VARCHAR2,

216: --
217: -- ========================================================
218: PROCEDURE Insert_Row(
219: p_SIGNIFICANT_PROCESS_FLAG VARCHAR2,
220: p_STANDARD_PROCESS_FLAG VARCHAR2,
221: p_APPROVAL_STATUS VARCHAR2,
222: p_CERTIFICATION_STATUS VARCHAR2,
223: p_PROCESS_OWNER_ID NUMBER,
224: p_last_update_date DATE,

Line 259: p_standard_variation number := null,

255: p_ORG_COUNT NUMBER,
256: p_process_category varchar2 := null,
257: p_finance_owner_id number := null,
258: p_application_owner_id number := null,
259: p_standard_variation number := null,
260: px_object_version_number IN OUT NOCOPY NUMBER,
261: px_PROCESS_REV_ID in out nocopy NUMBER,
262: px_process_id IN OUT NOCOPY NUMBER)
263:

Line 276: standard_process_flag,

272:
273:
274: INSERT INTO AMW_PROCESS(
275: significant_process_flag,
276: standard_process_flag,
277: approval_status,
278: certification_status,
279: process_owner_id,
280: process_id,

Line 318: standard_variation

314: org_count,
315: process_category,
316: finance_owner_id,
317: application_owner_id,
318: standard_variation
319: ) VALUES (
320: DECODE( p_significant_process_flag, FND_API.g_miss_char, NULL, p_significant_process_flag),
321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),

Line 321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),

317: application_owner_id,
318: standard_variation
319: ) VALUES (
320: DECODE( p_significant_process_flag, FND_API.g_miss_char, NULL, p_significant_process_flag),
321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),

Line 363: DECODE( p_standard_variation, FND_API.g_miss_num, NULL, p_standard_variation)

359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
361: DECODE( p_finance_owner_id, FND_API.g_miss_num, NULL, p_finance_owner_id),
362: DECODE( p_application_owner_id, FND_API.g_miss_num, NULL, p_application_owner_id),
363: DECODE( p_standard_variation, FND_API.g_miss_num, NULL, p_standard_variation)
364: );
365: END Insert_Row;
366:
367:

Line 386: p_STANDARD_PROCESS_FLAG VARCHAR2,

382: --
383: -- ========================================================
384: PROCEDURE Update_Row(
385: p_SIGNIFICANT_PROCESS_FLAG VARCHAR2,
386: p_STANDARD_PROCESS_FLAG VARCHAR2,
387: p_APPROVAL_STATUS VARCHAR2,
388: p_CERTIFICATION_STATUS VARCHAR2,
389: p_PROCESS_OWNER_ID NUMBER,
390: p_last_update_date DATE,

Line 425: p_standard_variation number := null,

421: p_ORG_COUNT NUMBER,
422: p_process_category varchar2 := null,
423: p_finance_owner_id number := null,
424: p_application_owner_id number := null,
425: p_standard_variation number := null,
426: p_object_version_number NUMBER,
427: p_PROCESS_REV_ID NUMBER,
428: p_process_id NUMBER)
429:

Line 447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),

443:
444: Update AMW_PROCESS
445: SET
446: significant_process_flag = DECODE(p_significant_process_flag, FND_API.g_miss_char, significant_process_flag, p_significant_process_flag),
447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),

Line 488: standard_variation = DECODE( p_standard_variation, FND_API.g_miss_num, standard_variation, p_standard_variation)

484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
486: finance_owner_id = DECODE( p_finance_owner_id, FND_API.g_miss_num, finance_owner_id, p_finance_owner_id),
487: application_owner_id = DECODE( p_application_owner_id, FND_API.g_miss_num, application_owner_id, p_application_owner_id),
488: standard_variation = DECODE( p_standard_variation, FND_API.g_miss_num, standard_variation, p_standard_variation)
489: WHERE PROCESS_rev_ID = p_PROCESS_rev_ID;
490:
491: IF (SQL%NOTFOUND) THEN
492: RAISE NO_DATA_FOUND;

Line 544: p_STANDARD_PROCESS_FLAG VARCHAR2,

540: --
541: -- ========================================================
542: PROCEDURE Lock_Row(
543: p_SIGNIFICANT_PROCESS_FLAG VARCHAR2,
544: p_STANDARD_PROCESS_FLAG VARCHAR2,
545: p_APPROVAL_STATUS VARCHAR2,
546: p_CERTIFICATION_STATUS VARCHAR2,
547: p_PROCESS_OWNER_ID NUMBER,
548: p_last_update_date DATE,

Line 583: p_standard_variation number := null,

579: p_ORG_COUNT NUMBER,
580: p_process_category varchar2 := null,
581: p_finance_owner_id number := null,
582: p_application_owner_id number := null,
583: p_standard_variation number := null,
584: p_object_version_number NUMBER,
585: p_PROCESS_REV_ID NUMBER,
586: p_process_id NUMBER)
587:

Line 705: AND ( ( Recinfo.standard_variation = p_standard_variation)

701: AND ( p_finance_owner_id IS NULL )))
702: AND ( ( Recinfo.application_owner_id = p_application_owner_id)
703: OR ( ( Recinfo.application_owner_id IS NULL )
704: AND ( p_application_owner_id IS NULL )))
705: AND ( ( Recinfo.standard_variation = p_standard_variation)
706: OR ( ( Recinfo.standard_variation IS NULL )
707: AND ( p_standard_variation IS NULL )))
708: ) THEN
709: RETURN;

Line 706: OR ( ( Recinfo.standard_variation IS NULL )

702: AND ( ( Recinfo.application_owner_id = p_application_owner_id)
703: OR ( ( Recinfo.application_owner_id IS NULL )
704: AND ( p_application_owner_id IS NULL )))
705: AND ( ( Recinfo.standard_variation = p_standard_variation)
706: OR ( ( Recinfo.standard_variation IS NULL )
707: AND ( p_standard_variation IS NULL )))
708: ) THEN
709: RETURN;
710: ELSE

Line 707: AND ( p_standard_variation IS NULL )))

703: OR ( ( Recinfo.application_owner_id IS NULL )
704: AND ( p_application_owner_id IS NULL )))
705: AND ( ( Recinfo.standard_variation = p_standard_variation)
706: OR ( ( Recinfo.standard_variation IS NULL )
707: AND ( p_standard_variation IS NULL )))
708: ) THEN
709: RETURN;
710: ELSE
711: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');