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.AS_STATUSES_PKG dependencies on AS_STATUSES_B

Line 55: cursor C is select ROWID from AS_STATUSES_B

51: X_LAST_UPDATE_DATE in DATE,
52: X_LAST_UPDATED_BY in NUMBER,
53: X_LAST_UPDATE_LOGIN in NUMBER
54: ) is
55: cursor C is select ROWID from AS_STATUSES_B
56: where STATUS_CODE = X_STATUS_CODE
57: ;
58: begin
59: insert into AS_STATUSES_B (

Line 59: insert into AS_STATUSES_B (

55: cursor C is select ROWID from AS_STATUSES_B
56: where STATUS_CODE = X_STATUS_CODE
57: ;
58: begin
59: insert into AS_STATUSES_B (
60: STATUS_CODE,
61: ENABLED_FLAG,
62: LEAD_FLAG,
63: OPP_FLAG,

Line 221: from AS_STATUSES_B

217: ATTRIBUTE12,
218: ATTRIBUTE13,
219: ATTRIBUTE14,
220: ATTRIBUTE15
221: from AS_STATUSES_B
222: where STATUS_CODE = X_STATUS_CODE
223: for update of STATUS_CODE nowait;
224: recinfo c%rowtype;
225:

Line 354: --Fetch the existing open_status_flag value from as_statuses_b.

350: l_request_id NUMBER;
351: l_module CONSTANT VARCHAR2(255) := 'as.plsql.stapk.UPDATE_ROW';
352: begin
353:
354: --Fetch the existing open_status_flag value from as_statuses_b.
355: SELECT opp_open_status_flag INTO l_old_opp_open_status_flag
356: FROM AS_STATUSES_B
357: WHERE ltrim(nls_upper(STATUS_CODE)) = nls_upper(X_STATUS_CODE);
358:

Line 356: FROM AS_STATUSES_B

352: begin
353:
354: --Fetch the existing open_status_flag value from as_statuses_b.
355: SELECT opp_open_status_flag INTO l_old_opp_open_status_flag
356: FROM AS_STATUSES_B
357: WHERE ltrim(nls_upper(STATUS_CODE)) = nls_upper(X_STATUS_CODE);
358:
359: update AS_STATUSES_B set
360: ENABLED_FLAG = X_ENABLED_FLAG,

Line 359: update AS_STATUSES_B set

355: SELECT opp_open_status_flag INTO l_old_opp_open_status_flag
356: FROM AS_STATUSES_B
357: WHERE ltrim(nls_upper(STATUS_CODE)) = nls_upper(X_STATUS_CODE);
358:
359: update AS_STATUSES_B set
360: ENABLED_FLAG = X_ENABLED_FLAG,
361: LEAD_FLAG = X_LEAD_FLAG,
362: OPP_FLAG = X_OPP_FLAG,
363: OPP_OPEN_STATUS_FLAG = X_OPP_OPEN_STATUS_FLAG,

Line 421: delete from AS_STATUSES_B

417: if (sql%notfound) then
418: raise no_data_found;
419: end if;
420:
421: delete from AS_STATUSES_B
422: where STATUS_CODE = X_STATUS_CODE;
423:
424: if (sql%notfound) then
425: raise no_data_found;

Line 469: from AS_STATUSES_B

465: row_id varchar2(64);
466:
467: cursor custom_exist(p_status_code VARCHAR2) is
468: select 'Y'
469: from AS_STATUSES_B
470: where last_updated_by <> 1
471: and status_code = p_STATUS_CODE;
472:
473: l_custom_exist varchar2(1) := 'N';

Line 577: from AS_STATUSES_B B

573: begin
574: delete from AS_STATUSES_TL T
575: where not exists
576: (select NULL
577: from AS_STATUSES_B B
578: where B.STATUS_CODE = T.STATUS_CODE
579: );
580:
581: update AS_STATUSES_TL T set (

Line 1108: from AS_STATUSES_B

1104:
1105:
1106: CURSOR Get_flag_from_Input(c_in_param_1 VARCHAR2,c_in_param_2 VARCHAR2) IS
1107: select NVL(LEAD_FLAG,'N'),NVL(OPP_FLAG,'N')
1108: from AS_STATUSES_B
1109: where status_code = c_in_param_2
1110: and UPPER(opp_open_status_flag) = UPPER(c_in_param_1);
1111:
1112: l_module CONSTANT VARCHAR2(255) := 'as.plsql.stapk.UPDATE_ACCESSES_SUB';

Line 1203: FROM AS_STATUSES_B st,AS_SALES_LEADS slds

1199: ELSE
1200: UPDATE /*+ INDEX(acc AS_ACCESSES_ALL_ALL_MT1)*/ AS_ACCESSES_ALL acc
1201: SET object_version_number = nvl(object_version_number,0) + 1,
1202: acc.OPEN_FLAG = (SELECT /*+ INDEX(slds AS_SALES_LEADS_MT1)*/ st.opp_open_status_flag
1203: FROM AS_STATUSES_B st,AS_SALES_LEADS slds
1204: WHERE st.status_code = slds.status_code
1205: AND slds.sales_lead_id = acc.sales_lead_id
1206: AND acc.sales_lead_id is not null
1207: AND st.lead_flag = 'Y'),

Line 1221: FROM AS_STATUSES_B st,AS_LEADS_ALL lds

1217:
1218: UPDATE /*+ INDEX(acc AS_ACCESSES_ALL_ALL_MT2)*/ AS_ACCESSES_ALL acc
1219: SET object_version_number = nvl(object_version_number,0) + 1,
1220: acc.OPEN_FLAG = (SELECT /*+ INDEX(lds AS_LEADS_ALL_MT2)*/ st.opp_open_status_flag
1221: FROM AS_STATUSES_B st,AS_LEADS_ALL lds
1222: WHERE st.status_code = lds.status
1223: AND lds.lead_id = acc.lead_id
1224: AND acc.lead_id is not null
1225: AND st.opp_flag = 'Y'),

Line 1590: from AS_STATUSES_B

1586: from dual;
1587:
1588: CURSOR Get_flag_from_Input(c_in_param_1 VARCHAR2,c_in_param_2 VARCHAR2) IS
1589: select NVL(LEAD_FLAG,'N')
1590: from AS_STATUSES_B
1591: where status_code = c_in_param_2
1592: and UPPER(opp_open_status_flag) = UPPER(c_in_param_1);
1593:
1594: l_module CONSTANT VARCHAR2(255) := 'as.plsql.stapk.UPDATE_LEADS_ACCESSES';

Line 1660: FROM AS_STATUSES_B st

1656: DECODE(st.status_code,'CONVERTED_TO_OPPORTUNITY','CONVERTED_TO_OPPORTUNITY',
1657: NVL(sld.close_reason,'NOT_SPECIFIED')
1658: )
1659: )
1660: FROM AS_STATUSES_B st
1661: WHERE st.status_code = sld.status_code
1662: AND st.lead_flag = 'Y')
1663: , sld.last_update_date = sysdate
1664: , sld.last_updated_by = l_last_updated_by

Line 2043: from AS_STATUSES_B

2039:
2040:
2041: CURSOR Get_flag_from_Input(c_in_param_1 VARCHAR2,c_in_param_2 VARCHAR2) IS
2042: select NVL(OPP_FLAG,'N')
2043: from AS_STATUSES_B
2044: where status_code = c_in_param_2
2045: and UPPER(opp_open_status_flag) = UPPER(c_in_param_1);
2046:
2047: l_module CONSTANT VARCHAR2(255) := 'as.plsql.stapk.UPDATE_OPPTY_ACCESSES';

Line 2103: FROM AS_STATUSES_B st

2099: -- update statements for opptys here
2100: If Upper(X_STATUS_CODE) = 'ALL' THEN
2101: execute immediate 'UPDATE /*+ INDEX(ld AS_LEADS_ALL_MT2)*/ AS_LEADS_ALL ld
2102: SET ld.close_reason = (DECODE((SELECT opp_open_status_flag
2103: FROM AS_STATUSES_B st
2104: WHERE st.status_code = ld.status
2105: AND st.opp_flag = ''Y''),''Y'',NULL,''N'',nvl(ld.CLOSE_REASON,''NOT_SPECIFIED'')))
2106: , ld.last_update_date = sysdate
2107: , ld.last_updated_by = :l_last_updated_by