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

Line 138: ,NVL(STANDARD_PROCESS_FLAG,'N') AS STANDARD_PROCESS_FLAG

134: CURSOR C_GET_INTF_DATA IS
135: SELECT BATCH_ID
136: ,PROCESS_INTERFACE_ID
137: ,SIGNIFICANT_PROCESS_FLAG
138: ,NVL(STANDARD_PROCESS_FLAG,'N') AS STANDARD_PROCESS_FLAG
139: ,NVL(APPROVAL_STATUS,'D') AS APPROVAL_STATUS
140: ,PROCESSED_FLAG
141: ,ERROR_FLAG
142: ,INTERFACE_STATUS

Line 165: ,NVL(STANDARD_PROCESS_FLAG,'Y') AS STANDARD_PROCESS_FLAG

161: CURSOR C_GET_INTF_ROWS IS
162: SELECT BATCH_ID
163: ,PROCESS_INTERFACE_ID
164: ,SIGNIFICANT_PROCESS_FLAG
165: ,NVL(STANDARD_PROCESS_FLAG,'Y') AS STANDARD_PROCESS_FLAG
166: ,NVL(APPROVAL_STATUS,'D') AS APPROVAL_STATUS
167: ,PROCESSED_FLAG
168: ,ERROR_FLAG
169: ,INTERFACE_STATUS

Line 183: ,STANDARD_VARIATION

179: ,PARENT_PROCESS_CODE
180: ,ATTACHMENT_URL
181: ,CERTIFICATION_STATUS
182: ---12.29.2004 NPANANDI: ADDED STD VAR d COLS
183: ,STANDARD_VARIATION
184: ,CLASSIFICATION
185: ---04.22.2005 npanandi: added 3 owner columns below
186: ,process_owner_id
187: ,finance_owner_id

Line 432: L_PROCESS_REC.STANDARD_PROCESS_FLAG := INSERT_REC.STANDARD_PROCESS_FLAG;

428: when no_data_found then
429: null;
430: END;
431: L_PROCESS_REC.SIGNIFICANT_PROCESS_FLAG := INSERT_REC.SIGNIFICANT_PROCESS_FLAG;
432: L_PROCESS_REC.STANDARD_PROCESS_FLAG := INSERT_REC.STANDARD_PROCESS_FLAG;
433: L_PROCESS_REC.CERTIFICATION_STATUS := INSERT_REC.CERTIFICATION_STATUS;
434: L_PROCESS_REC.PROCESS_CATEGORY := INSERT_REC.PROCESS_CATEGORY;
435: L_PROCESS_REC.PROCESS_TYPE := INSERT_REC.PROCESS_TYPE;
436: L_PROCESS_REC.CONTROL_ACTIVITY_TYPE := INSERT_REC.CONTROL_ACTIVITY_TYPE;

Line 440: L_PROCESS_REC.STANDARD_VARIATION := INSERT_REC.STANDARD_VARIATION;

436: L_PROCESS_REC.CONTROL_ACTIVITY_TYPE := INSERT_REC.CONTROL_ACTIVITY_TYPE;
437: L_PROCESS_REC.DISPLAY_NAME := INSERT_REC.PROCESS_DISPLAY_NAME;
438: L_PROCESS_REC.ATTACHMENT_URL := INSERT_REC.ATTACHMENT_URL;
439: ---12.29.2004 NPANANDI: ADDED STD VAR d ATTRIBUTES
440: L_PROCESS_REC.STANDARD_VARIATION := INSERT_REC.STANDARD_VARIATION;
441: L_PROCESS_REC.CLASSIFICATION := INSERT_REC.CLASSIFICATION;
442: --04.22.2005 npanandi: added 3 owner columns below
443: l_process_rec.process_owner_id := insert_rec.process_owner_id;
444: l_process_rec.finance_owner_id := insert_rec.finance_owner_id;

Line 1406: l_standard_variation number;

1402: lX_msg_data varchar2(2000);
1403: lx_index number;
1404:
1405: ---12.29.2004 npanandi: addition of StdVariation flag
1406: l_standard_variation number;
1407:
1408: ---04.22.2005 npanandi: added vars below for profile option values
1409: l_amw_process_owner_col varchar2(30);
1410: l_amw_application_owner_col varchar2(30);

Line 1424: if(P_PROCESS_REC.standard_process_flag = 'Y')then

1420: l_process_name := P_PROCESS_REC.name;
1421: end if;
1422:
1423: ---12.29.2004 npanandi: check for StdVariation=NULL if Process is Std Process
1424: if(P_PROCESS_REC.standard_process_flag = 'Y')then
1425: l_standard_variation := NULL;
1426: else
1427: l_standard_variation := P_PROCESS_REC.standard_variation;
1428: end if;

Line 1425: l_standard_variation := NULL;

1421: end if;
1422:
1423: ---12.29.2004 npanandi: check for StdVariation=NULL if Process is Std Process
1424: if(P_PROCESS_REC.standard_process_flag = 'Y')then
1425: l_standard_variation := NULL;
1426: else
1427: l_standard_variation := P_PROCESS_REC.standard_variation;
1428: end if;
1429:

Line 1427: l_standard_variation := P_PROCESS_REC.standard_variation;

1423: ---12.29.2004 npanandi: check for StdVariation=NULL if Process is Std Process
1424: if(P_PROCESS_REC.standard_process_flag = 'Y')then
1425: l_standard_variation := NULL;
1426: else
1427: l_standard_variation := P_PROCESS_REC.standard_variation;
1428: end if;
1429:
1430: insert into amw_process (
1431: PROCESS_ID,

Line 1440: STANDARD_PROCESS_FLAG,

1436: PROCESS_REV_ID,
1437: APPROVAL_STATUS,
1438: START_DATE,
1439: SIGNIFICANT_PROCESS_FLAG,
1440: STANDARD_PROCESS_FLAG,
1441: CERTIFICATION_STATUS,
1442: PROCESS_CATEGORY,
1443: STANDARD_VARIATION,
1444: LAST_UPDATE_DATE,

Line 1443: STANDARD_VARIATION,

1439: SIGNIFICANT_PROCESS_FLAG,
1440: STANDARD_PROCESS_FLAG,
1441: CERTIFICATION_STATUS,
1442: PROCESS_CATEGORY,
1443: STANDARD_VARIATION,
1444: LAST_UPDATE_DATE,
1445: LAST_UPDATED_BY,
1446: CREATION_DATE,
1447: CREATED_BY,

Line 1464: P_PROCESS_REC.standard_process_flag,

1460: l_process_rev_id,
1461: 'D',
1462: sysdate,
1463: P_PROCESS_REC.significant_process_flag,
1464: P_PROCESS_REC.standard_process_flag,
1465: P_PROCESS_REC.certification_status,
1466: P_PROCESS_REC.process_category,
1467: l_standard_variation,
1468: sysdate,

Line 1467: l_standard_variation,

1463: P_PROCESS_REC.significant_process_flag,
1464: P_PROCESS_REC.standard_process_flag,
1465: P_PROCESS_REC.certification_status,
1466: P_PROCESS_REC.process_category,
1467: l_standard_variation,
1468: sysdate,
1469: G_USER_ID,
1470: sysdate,
1471: G_USER_ID,

Line 1624: L_STANDARD_VARIATION NUMBER;

1620: lX_msg_data varchar2(2000);
1621: lx_index number;
1622:
1623: ---12.29.2004 NPANANDI: STD VAR VAR ADDED
1624: L_STANDARD_VARIATION NUMBER;
1625: L_IS_STD_VAR NUMBER;
1626: l_standard_process_flag varchar2(1);
1627:
1628: ---04.22.2005 npanandi: added vars below for profile option values

Line 1626: l_standard_process_flag varchar2(1);

1622:
1623: ---12.29.2004 NPANANDI: STD VAR VAR ADDED
1624: L_STANDARD_VARIATION NUMBER;
1625: L_IS_STD_VAR NUMBER;
1626: l_standard_process_flag varchar2(1);
1627:
1628: ---04.22.2005 npanandi: added vars below for profile option values
1629: l_amw_process_owner_col varchar2(30);
1630: l_amw_application_owner_col varchar2(30);

Line 1657: ---is not the same Process, if it is same Process, then set StandardVariation=NULL

1653: END;
1654:
1655: ---12.29.2004 npanandi:
1656: ---for an update, check if the Std Process chosen for this NonStdVariation
1657: ---is not the same Process, if it is same Process, then set StandardVariation=NULL
1658: L_STANDARD_VARIATION := NULL;
1659: l_standard_process_flag := 'Y';
1660: L_IS_STD_VAR := 0;
1661: begin

Line 1658: L_STANDARD_VARIATION := NULL;

1654:
1655: ---12.29.2004 npanandi:
1656: ---for an update, check if the Std Process chosen for this NonStdVariation
1657: ---is not the same Process, if it is same Process, then set StandardVariation=NULL
1658: L_STANDARD_VARIATION := NULL;
1659: l_standard_process_flag := 'Y';
1660: L_IS_STD_VAR := 0;
1661: begin
1662: select 1

Line 1659: l_standard_process_flag := 'Y';

1655: ---12.29.2004 npanandi:
1656: ---for an update, check if the Std Process chosen for this NonStdVariation
1657: ---is not the same Process, if it is same Process, then set StandardVariation=NULL
1658: L_STANDARD_VARIATION := NULL;
1659: l_standard_process_flag := 'Y';
1660: L_IS_STD_VAR := 0;
1661: begin
1662: select 1
1663: into L_IS_STD_VAR

Line 1667: where process_rev_id = ap.standard_variation) =

1663: into L_IS_STD_VAR
1664: from amw_process ap
1665: where (select process_id
1666: from amw_process
1667: where process_rev_id = ap.standard_variation) =
1668: (select process_id
1669: from amw_process
1670: where process_rev_id = L_PROCESS_REV_ID)
1671: and ap.end_date is null;

Line 1677: IF(P_PROCESS_REC.STANDARD_VARIATION <> L_PROCESS_REV_ID AND L_IS_STD_VAR = 0)THEN

1673: WHEN NO_DATA_FOUND THEN
1674: L_IS_STD_VAR := 0;
1675: END;
1676:
1677: IF(P_PROCESS_REC.STANDARD_VARIATION <> L_PROCESS_REV_ID AND L_IS_STD_VAR = 0)THEN
1678: L_STANDARD_VARIATION := P_PROCESS_REC.STANDARD_VARIATION;
1679: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='N')then
1680: l_standard_process_flag := 'N';
1681: end if;

Line 1678: L_STANDARD_VARIATION := P_PROCESS_REC.STANDARD_VARIATION;

1674: L_IS_STD_VAR := 0;
1675: END;
1676:
1677: IF(P_PROCESS_REC.STANDARD_VARIATION <> L_PROCESS_REV_ID AND L_IS_STD_VAR = 0)THEN
1678: L_STANDARD_VARIATION := P_PROCESS_REC.STANDARD_VARIATION;
1679: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='N')then
1680: l_standard_process_flag := 'N';
1681: end if;
1682: END IF;

Line 1679: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='N')then

1675: END;
1676:
1677: IF(P_PROCESS_REC.STANDARD_VARIATION <> L_PROCESS_REV_ID AND L_IS_STD_VAR = 0)THEN
1678: L_STANDARD_VARIATION := P_PROCESS_REC.STANDARD_VARIATION;
1679: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='N')then
1680: l_standard_process_flag := 'N';
1681: end if;
1682: END IF;
1683:

Line 1680: l_standard_process_flag := 'N';

1676:
1677: IF(P_PROCESS_REC.STANDARD_VARIATION <> L_PROCESS_REV_ID AND L_IS_STD_VAR = 0)THEN
1678: L_STANDARD_VARIATION := P_PROCESS_REC.STANDARD_VARIATION;
1679: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='N')then
1680: l_standard_process_flag := 'N';
1681: end if;
1682: END IF;
1683:
1684: --disregard the StandardVariation if the Process is Std Process

Line 1684: --disregard the StandardVariation if the Process is Std Process

1680: l_standard_process_flag := 'N';
1681: end if;
1682: END IF;
1683:
1684: --disregard the StandardVariation if the Process is Std Process
1685: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='Y')then
1686: L_STANDARD_VARIATION := null;
1687: end if;
1688:

Line 1685: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='Y')then

1681: end if;
1682: END IF;
1683:
1684: --disregard the StandardVariation if the Process is Std Process
1685: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='Y')then
1686: L_STANDARD_VARIATION := null;
1687: end if;
1688:
1689: UPDATE AMW_PROCESS

Line 1686: L_STANDARD_VARIATION := null;

1682: END IF;
1683:
1684: --disregard the StandardVariation if the Process is Std Process
1685: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='Y')then
1686: L_STANDARD_VARIATION := null;
1687: end if;
1688:
1689: UPDATE AMW_PROCESS
1690: SET APPROVAL_STATUS=P_PROCESS_REC.APPROVAL_STATUS

Line 1692: ---,STANDARD_PROCESS_FLAG=P_PROCESS_REC.STANDARD_PROCESS_FLAG

1688:
1689: UPDATE AMW_PROCESS
1690: SET APPROVAL_STATUS=P_PROCESS_REC.APPROVAL_STATUS
1691: ,SIGNIFICANT_PROCESS_FLAG=P_PROCESS_REC.SIGNIFICANT_PROCESS_FLAG
1692: ---,STANDARD_PROCESS_FLAG=P_PROCESS_REC.STANDARD_PROCESS_FLAG
1693: ,STANDARD_PROCESS_FLAG=l_STANDARD_PROCESS_FLAG
1694: ,CERTIFICATION_STATUS=P_PROCESS_REC.CERTIFICATION_STATUS
1695: ,PROCESS_CATEGORY=P_PROCESS_REC.PROCESS_CATEGORY
1696: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1

Line 1693: ,STANDARD_PROCESS_FLAG=l_STANDARD_PROCESS_FLAG

1689: UPDATE AMW_PROCESS
1690: SET APPROVAL_STATUS=P_PROCESS_REC.APPROVAL_STATUS
1691: ,SIGNIFICANT_PROCESS_FLAG=P_PROCESS_REC.SIGNIFICANT_PROCESS_FLAG
1692: ---,STANDARD_PROCESS_FLAG=P_PROCESS_REC.STANDARD_PROCESS_FLAG
1693: ,STANDARD_PROCESS_FLAG=l_STANDARD_PROCESS_FLAG
1694: ,CERTIFICATION_STATUS=P_PROCESS_REC.CERTIFICATION_STATUS
1695: ,PROCESS_CATEGORY=P_PROCESS_REC.PROCESS_CATEGORY
1696: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1697: ,PROCESS_TYPE=P_PROCESS_REC.PROCESS_TYPE

Line 1703: ,STANDARD_VARIATION=L_STANDARD_VARIATION

1699: ,LAST_UPDATE_DATE=SYSDATE
1700: ,LAST_UPDATED_BY=G_USER_ID
1701: ,LAST_UPDATE_LOGIN=G_LOGIN_ID
1702: ---12.29.2004 NPANANDI: ADDED STD VARIATION COL UPDATE
1703: ,STANDARD_VARIATION=L_STANDARD_VARIATION
1704: WHERE PROCESS_ID=P_PROCESS_REC.PROCESS_ID
1705: AND END_DATE IS NULL;
1706:
1707: if (sql%notfound) then