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_RL_HIERARCHY_PKG dependencies on STANDARD

Line 724: l_standard_process_flag amw_process.standard_process_flag%type;

720: l_control_count amw_process.control_count%type;
721: l_risk_count amw_process.risk_count%type;
722: l_org_count amw_process.org_count%type;
723: l_significant_process_flag amw_process.significant_process_flag%type;
724: l_standard_process_flag amw_process.standard_process_flag%type;
725: l_certification_status amw_process.certification_status%type;
726: l_process_category amw_process.process_category%type;
727: l_process_owner_id amw_process.process_owner_id%type;
728: l_finance_owner_id amw_process.finance_owner_id%type;

Line 730: l_standard_variation amw_process.standard_variation%type;

726: l_process_category amw_process.process_category%type;
727: l_process_owner_id amw_process.process_owner_id%type;
728: l_finance_owner_id amw_process.finance_owner_id%type;
729: l_application_owner_id amw_process.application_owner_id%type;
730: l_standard_variation amw_process.standard_variation%type;
731: l_deletion_date amw_process.deletion_date%type;
732: l_process_type amw_process.process_type%type;
733: l_control_activity_type amw_process.control_activity_type%type;
734: l_object_version_number amw_process.object_version_number%type;

Line 779: standard_process_flag, certification_status,

775:
776: select process_id, process_rev_id, item_type, name, process_code,
777: revision_number, approval_status, control_count,
778: risk_count, org_count, significant_process_flag,
779: standard_process_flag, certification_status,
780: process_category, process_owner_id, finance_owner_id,
781: application_owner_id, standard_variation,
782: object_version_number, deletion_date,
783: process_type, control_activity_type,

Line 781: application_owner_id, standard_variation,

777: revision_number, approval_status, control_count,
778: risk_count, org_count, significant_process_flag,
779: standard_process_flag, certification_status,
780: process_category, process_owner_id, finance_owner_id,
781: application_owner_id, standard_variation,
782: object_version_number, deletion_date,
783: process_type, control_activity_type,
784: attribute_category, attribute1,
785: attribute2, attribute3, attribute4,

Line 797: l_standard_process_flag, l_certification_status,

793:
794: into l_process_id, l_process_rev_id, l_item_type, l_name, l_process_code,
795: l_revision_number, l_approval_status, l_control_count,
796: l_risk_count, l_org_count, l_significant_process_flag,
797: l_standard_process_flag, l_certification_status,
798: l_process_category, l_process_owner_id, l_finance_owner_id,
799: l_application_owner_id, l_standard_variation,
800: l_object_version_number, l_deletion_date,
801: l_process_type, l_control_activity_type,

Line 799: l_application_owner_id, l_standard_variation,

795: l_revision_number, l_approval_status, l_control_count,
796: l_risk_count, l_org_count, l_significant_process_flag,
797: l_standard_process_flag, l_certification_status,
798: l_process_category, l_process_owner_id, l_finance_owner_id,
799: l_application_owner_id, l_standard_variation,
800: l_object_version_number, l_deletion_date,
801: l_process_type, l_control_activity_type,
802: l_attribute_category, l_attribute1,
803: l_attribute2, l_attribute3, l_attribute4,

Line 844: STANDARD_PROCESS_FLAG,

840: CONTROL_COUNT,
841: RISK_COUNT,
842: ORG_COUNT,
843: SIGNIFICANT_PROCESS_FLAG,
844: STANDARD_PROCESS_FLAG,
845: CERTIFICATION_STATUS,
846: PROCESS_CATEGORY,
847: PROCESS_OWNER_ID,
848: FINANCE_OWNER_ID,

Line 850: STANDARD_VARIATION,

846: PROCESS_CATEGORY,
847: PROCESS_OWNER_ID,
848: FINANCE_OWNER_ID,
849: APPLICATION_OWNER_ID,
850: STANDARD_VARIATION,
851: LAST_UPDATE_DATE,
852: LAST_UPDATED_BY,
853: CREATION_DATE,
854: CREATED_BY,

Line 898: l_standard_process_flag,

894: l_control_count,
895: l_risk_count,
896: l_org_count,
897: l_significant_process_flag,
898: l_standard_process_flag,
899: l_certification_status,
900: l_process_category,
901: l_process_owner_id,
902: l_finance_owner_id,

Line 904: l_standard_variation,

900: l_process_category,
901: l_process_owner_id,
902: l_finance_owner_id,
903: l_application_owner_id,
904: l_standard_variation,
905: l_sysdate,
906: G_USER_ID,
907: l_sysdate,
908: G_USER_ID,

Line 1745: STANDARD_PROCESS_FLAG,

1741: PROGRAM_UPDATE_DATE,
1742: RISK_COUNT_LATEST,
1743: CONTROL_COUNT_LATEST,
1744: SIGNIFICANT_PROCESS_FLAG,
1745: STANDARD_PROCESS_FLAG,
1746: PROCESS_CATEGORY)
1747:
1748: VALUES
1749: (AMW_PROCESS_S.nextval,

Line 3851: select standard_process_flag, process_rev_id

3847: and approval_end_date is null;
3848:
3849: else -- appexst = 'N'
3850:
3851: select standard_process_flag, process_rev_id
3852: into l_flag, previd from amw_process
3853: where process_id = p_process_id;
3854:
3855: if l_flag = 'Y' then

Line 3860: where standard_variation = previd

3856: begin
3857: select 1 into l_dummy from dual
3858: where exists
3859: (select 1 from amw_process
3860: where standard_variation = previd
3861: and end_date is null);
3862:
3863: fnd_message.set_name('AMW','AMW_CANT_DEL_DRAFT_NS');
3864: err_msg := fnd_message.get;