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.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTY_WEBADI_RESOURCES

Line 564: OR EXISTS (select 1 from jty_webadi_resources jwr

560: and jwot.TERR_QUAL_ID18 IS NULL and jwot.TERR_QUAL_ID19 IS NULL
561: and jwot.TERR_QUAL_ID20 IS NULL and jwot.TERR_QUAL_ID21 IS NULL
562: and jwot.TERR_QUAL_ID22 IS NULL and jwot.TERR_QUAL_ID23 IS NULL
563: and jwot.TERR_QUAL_ID24 IS NULL and jwot.TERR_QUAL_ID25 IS NULL)
564: OR EXISTS (select 1 from jty_webadi_resources jwr
565: where jwot.lay_seq_num = jwr.lay_seq_num
566: and jwr.terr_rsc_id is null
567: and jwr.header = l_header)
568: )

Line 621: (select 1 from JTY_WEBADI_RESOURCES jwr

617: update JTY_WEBADI_OTH_TERR_INTF jwot
618: set jwot.status = x_return_status,
619: jwot.error_msg = X_Msg_Data
620: where exists
621: (select 1 from JTY_WEBADI_RESOURCES jwr
622: where jwot.lay_seq_num = jwr.lay_seq_num
623: AND jwr.TRANS_ACCESS_CODE1 is null
624: AND jwr.TRANS_ACCESS_CODE2 is null
625: AND jwr.TRANS_ACCESS_CODE3 is null

Line 646: UPDATE JTY_WEBADI_RESOURCES jut

642: -- Fix for bug #5583243 START
643: -- if any access is left blank while uploading the data from excel,
644: -- then the upload should populate the value 'NONE' in the database.
645:
646: UPDATE JTY_WEBADI_RESOURCES jut
647: SET jut.TRANS_ACCESS_CODE1 = NVL(jut.TRANS_ACCESS_CODE1,'NONE')
648: , jut.TRANS_ACCESS_CODE2 = NVL(jut.TRANS_ACCESS_CODE2,'NONE')
649: , jut.TRANS_ACCESS_CODE3 = NVL(jut.TRANS_ACCESS_CODE3,'NONE')
650: , jut.TRANS_ACCESS_CODE4 = NVL(jut.TRANS_ACCESS_CODE4,'NONE')

Line 674: (select 1 from JTY_WEBADI_RESOURCES jwr

670: update JTY_WEBADI_OTH_TERR_INTF jwot
671: set jwot.status = x_return_status,
672: jwot.error_msg = X_Msg_Data
673: where exists
674: (select 1 from JTY_WEBADI_RESOURCES jwr
675: where jwot.lay_seq_num = jwr.lay_seq_num
676: AND jwr.TRANS_ACCESS_CODE1 = 'NONE'
677: AND jwr.TRANS_ACCESS_CODE2 = 'NONE'
678: AND jwr.TRANS_ACCESS_CODE3 = 'NONE'

Line 712: from JTF_TERR_RSC_ALL jtr,JTY_WEBADI_RESOURCES jwr

708: and jwot.status is null
709: and jwot.action_flag = 'C'
710: and jwot.header = 'RSC'
711: and exists( select 1
712: from JTF_TERR_RSC_ALL jtr,JTY_WEBADI_RESOURCES jwr
713: where jwr.USER_SEQUENCE = jwot.USER_SEQUENCE
714: and jwr.header = jwot.header
715: and jwr.INTERFACE_TYPE = jwot.INTERFACE_TYPE
716: and jwot.lay_seq_num = jwr.lay_seq_num

Line 734: (select 1 from JTY_WEBADI_RESOURCES jwr

730: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
731: set jwot.status = x_return_status,
732: jwot.error_msg = X_Msg_Data
733: where exists
734: (select 1 from JTY_WEBADI_RESOURCES jwr
735: where jwot.lay_seq_num = jwr.lay_seq_num
736: and jwr.USER_SEQUENCE = jwot.USER_SEQUENCE
737: and jwr.interface_type = jwot.interface_type
738: and jwr.header = jwot.header

Line 756: (select 1 from JTY_WEBADI_RESOURCES jwr

752: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
753: set jwot.status = x_return_status,
754: jwot.error_msg = X_Msg_Data
755: where exists
756: (select 1 from JTY_WEBADI_RESOURCES jwr
757: where jwot.lay_seq_num = jwr.lay_seq_num
758: and jwr.USER_SEQUENCE = jwot.USER_SEQUENCE
759: and jwr.interface_type = jwot.interface_type
760: and jwr.header = jwot.header

Line 983: UPDATE JTY_WEBADI_RESOURCES jwr

979: and jwot.user_sequence = jwot2.user_sequence
980: and jwot.interface_type = jwot2.interface_type
981: and jwot2.header = 'TERR');
982:
983: UPDATE JTY_WEBADI_RESOURCES jwr
984: SET TERR_ID = (select jwot.terr_id
985: from JTY_WEBADI_OTH_TERR_INTF jwot
986: where jwr.lay_seq_num = jwot.lay_seq_num
987: and rownum = 1) ,

Line 1816: JTY_WEBADI_RESOURCES jwr

1812: v_header varchar2
1813: ) IS
1814: SELECT jwr.TERR_RSC_ID, jwot.lay_seq_num
1815: FROM JTY_WEBADI_OTH_TERR_INTF jwot,
1816: JTY_WEBADI_RESOURCES jwr
1817: WHERE jwot.lay_seq_num = jwr.lay_seq_num
1818: and jwot.header = jwr.header
1819: and jwot.user_sequence = jwr.user_sequence
1820: AND jwot.interface_type = jwr.interface_type

Line 4743: JTY_WEBADI_RESOURCES jwr,

4739: jwr.ATTRIBUTE12, jwr.ATTRIBUTE13, jwr.ATTRIBUTE14,
4740: jwr.ATTRIBUTE15
4741: from
4742: JTY_WEBADI_OTH_TERR_INTF jwot,
4743: JTY_WEBADI_RESOURCES jwr,
4744: jtf_rs_resource_extns res
4745: where jwr.RESOURCE_ID = res.resource_id(+)
4746: and jwr.user_sequence = jwot.user_sequence
4747: and jwr.interface_type = jwot.interface_type

Line 4771: FROM JTY_WEBADI_RESOURCES jut

4767: (
4768: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4769: 1 qual_type_num, TERR_RSC_ACCESS_ID1 TERR_RSC_ACCESS_ID,
4770: TRANS_ACCESS_CODE1 TRANS_ACCESS_CODE
4771: FROM JTY_WEBADI_RESOURCES jut
4772: where jut.USER_SEQUENCE = v_user_sequence
4773: and jut.TRANS_ACCESS_CODE1 is not null
4774: and jut.TERR_RSC_ACCESS_ID1 is null
4775: and jut.header = v_header

Line 4781: FROM JTY_WEBADI_RESOURCES jut

4777: union all
4778: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4779: 2 qual_type_num, TERR_RSC_ACCESS_ID2 TERR_RSC_ACCESS_ID,
4780: TRANS_ACCESS_CODE2 TRANS_ACCESS_CODE
4781: FROM JTY_WEBADI_RESOURCES jut
4782: where jut.USER_SEQUENCE = v_user_sequence
4783: and jut.TRANS_ACCESS_CODE2 is not null
4784: and jut.TERR_RSC_ACCESS_ID2 is null
4785: and jut.header = v_header

Line 4791: FROM JTY_WEBADI_RESOURCES jut

4787: union all
4788: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4789: 3 qual_type_num, TERR_RSC_ACCESS_ID3 TERR_RSC_ACCESS_ID,
4790: TRANS_ACCESS_CODE3 TRANS_ACCESS_CODE
4791: FROM JTY_WEBADI_RESOURCES jut
4792: where jut.USER_SEQUENCE = v_user_sequence
4793: and jut.TRANS_ACCESS_CODE3 is not null
4794: and jut.TERR_RSC_ACCESS_ID3 is null
4795: and jut.header = v_header

Line 4801: FROM JTY_WEBADI_RESOURCES jut

4797: union all
4798: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4799: 4 qual_type_num, TERR_RSC_ACCESS_ID4 TERR_RSC_ACCESS_ID,
4800: TRANS_ACCESS_CODE4 TRANS_ACCESS_CODE
4801: FROM JTY_WEBADI_RESOURCES jut
4802: where jut.USER_SEQUENCE = v_user_sequence
4803: and jut.TRANS_ACCESS_CODE4 is not null
4804: and jut.TERR_RSC_ACCESS_ID4 is null
4805: and jut.header = v_header

Line 4811: FROM JTY_WEBADI_RESOURCES jut

4807: union all
4808: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4809: 5 qual_type_num, TERR_RSC_ACCESS_ID5 TERR_RSC_ACCESS_ID,
4810: TRANS_ACCESS_CODE5 TRANS_ACCESS_CODE
4811: FROM JTY_WEBADI_RESOURCES jut
4812: where jut.USER_SEQUENCE = v_user_sequence
4813: and jut.TRANS_ACCESS_CODE5 is not null
4814: and jut.TERR_RSC_ACCESS_ID5 is null
4815: and jut.header = v_header

Line 4821: FROM JTY_WEBADI_RESOURCES jut

4817: union all
4818: select user_sequence, TERR_RSC_ID,lay_seq_num, header,
4819: 6 qual_type_num, TERR_RSC_ACCESS_ID6 TERR_RSC_ACCESS_ID,
4820: TRANS_ACCESS_CODE6 TRANS_ACCESS_CODE
4821: FROM JTY_WEBADI_RESOURCES jut
4822: where jut.USER_SEQUENCE = v_user_sequence
4823: and jut.TRANS_ACCESS_CODE6 is not null
4824: and jut.TERR_RSC_ACCESS_ID6 is null
4825: and jut.header = v_header

Line 4831: FROM JTY_WEBADI_RESOURCES jut

4827: union all
4828: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4829: 7 qual_type_num, TERR_RSC_ACCESS_ID7 TERR_RSC_ACCESS_ID,
4830: TRANS_ACCESS_CODE7 TRANS_ACCESS_CODE
4831: FROM JTY_WEBADI_RESOURCES jut
4832: where jut.USER_SEQUENCE = v_user_sequence
4833: and jut.TRANS_ACCESS_CODE7 is not null
4834: and jut.TERR_RSC_ACCESS_ID7 is null
4835: and jut.header = v_header

Line 4841: FROM JTY_WEBADI_RESOURCES jut

4837: union all
4838: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4839: 8 qual_type_num, TERR_RSC_ACCESS_ID8 TERR_RSC_ACCESS_ID,
4840: TRANS_ACCESS_CODE8 TRANS_ACCESS_CODE
4841: FROM JTY_WEBADI_RESOURCES jut
4842: where jut.USER_SEQUENCE = v_user_sequence
4843: and jut.TRANS_ACCESS_CODE8 is not null
4844: and jut.TERR_RSC_ACCESS_ID8 is null
4845: and jut.header = v_header

Line 4851: FROM JTY_WEBADI_RESOURCES jut

4847: union all
4848: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4849: 9 qual_type_num, TERR_RSC_ACCESS_ID9 TERR_RSC_ACCESS_ID,
4850: TRANS_ACCESS_CODE9 TRANS_ACCESS_CODE
4851: FROM JTY_WEBADI_RESOURCES jut
4852: where jut.USER_SEQUENCE = v_user_sequence
4853: and jut.TRANS_ACCESS_CODE9 is not null
4854: and jut.TERR_RSC_ACCESS_ID9 is null
4855: and jut.header = v_header

Line 4861: FROM JTY_WEBADI_RESOURCES jut

4857: union all
4858: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4859: 10 qual_type_num, TERR_RSC_ACCESS_ID10 TERR_RSC_ACCESS_ID,
4860: TRANS_ACCESS_CODE10 TRANS_ACCESS_CODE
4861: FROM JTY_WEBADI_RESOURCES jut
4862: where jut.USER_SEQUENCE = v_user_sequence
4863: and jut.TRANS_ACCESS_CODE10 is not null
4864: and jut.TERR_RSC_ACCESS_ID10 is null
4865: and jut.header = v_header

Line 4890: FROM JTY_WEBADI_RESOURCES jut

4886: (
4887: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4888: 1 qual_type_num, TERR_RSC_ACCESS_ID1 TERR_RSC_ACCESS_ID,
4889: TRANS_ACCESS_CODE1 TRANS_ACCESS_CODE
4890: FROM JTY_WEBADI_RESOURCES jut
4891: where jut.USER_SEQUENCE = v_user_sequence
4892: and jut.TRANS_ACCESS_CODE1 is not null
4893: and jut.TERR_RSC_ACCESS_ID1 is not null
4894: and jut.header = v_header

Line 4900: FROM JTY_WEBADI_RESOURCES jut

4896: union all
4897: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4898: 2 qual_type_num, TERR_RSC_ACCESS_ID2 TERR_RSC_ACCESS_ID,
4899: TRANS_ACCESS_CODE2 TRANS_ACCESS_CODE
4900: FROM JTY_WEBADI_RESOURCES jut
4901: where jut.USER_SEQUENCE = v_user_sequence
4902: and jut.TRANS_ACCESS_CODE2 is not null
4903: and jut.TERR_RSC_ACCESS_ID2 is not null
4904: and jut.header = v_header

Line 4910: FROM JTY_WEBADI_RESOURCES jut

4906: union all
4907: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4908: 3 qual_type_num, TERR_RSC_ACCESS_ID3 TERR_RSC_ACCESS_ID,
4909: TRANS_ACCESS_CODE3 TRANS_ACCESS_CODE
4910: FROM JTY_WEBADI_RESOURCES jut
4911: where jut.USER_SEQUENCE = v_user_sequence
4912: and jut.TRANS_ACCESS_CODE3 is not null
4913: and jut.TERR_RSC_ACCESS_ID3 is not null
4914: and jut.header = v_header

Line 4920: FROM JTY_WEBADI_RESOURCES jut

4916: union all
4917: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4918: 4 qual_type_num, TERR_RSC_ACCESS_ID4 TERR_RSC_ACCESS_ID,
4919: TRANS_ACCESS_CODE4 TRANS_ACCESS_CODE
4920: FROM JTY_WEBADI_RESOURCES jut
4921: where jut.USER_SEQUENCE = v_user_sequence
4922: and jut.TRANS_ACCESS_CODE4 is not null
4923: and jut.TERR_RSC_ACCESS_ID4 is not null
4924: and jut.header = v_header

Line 4930: FROM JTY_WEBADI_RESOURCES jut

4926: union all
4927: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4928: 5 qual_type_num, TERR_RSC_ACCESS_ID5 TERR_RSC_ACCESS_ID,
4929: TRANS_ACCESS_CODE5 TRANS_ACCESS_CODE
4930: FROM JTY_WEBADI_RESOURCES jut
4931: where jut.USER_SEQUENCE = v_user_sequence
4932: and jut.TRANS_ACCESS_CODE5 is not null
4933: and jut.TERR_RSC_ACCESS_ID5 is not null
4934: and jut.header = v_header

Line 4940: FROM JTY_WEBADI_RESOURCES jut

4936: union all
4937: select user_sequence, TERR_RSC_ID,lay_seq_num, header,
4938: 6 qual_type_num, TERR_RSC_ACCESS_ID6 TERR_RSC_ACCESS_ID,
4939: TRANS_ACCESS_CODE6 TRANS_ACCESS_CODE
4940: FROM JTY_WEBADI_RESOURCES jut
4941: where jut.USER_SEQUENCE = v_user_sequence
4942: and jut.TRANS_ACCESS_CODE6 is not null
4943: and jut.TERR_RSC_ACCESS_ID6 is not null
4944: and jut.header = v_header

Line 4950: FROM JTY_WEBADI_RESOURCES jut

4946: union all
4947: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4948: 7 qual_type_num, TERR_RSC_ACCESS_ID7 TERR_RSC_ACCESS_ID,
4949: TRANS_ACCESS_CODE7 TRANS_ACCESS_CODE
4950: FROM JTY_WEBADI_RESOURCES jut
4951: where jut.USER_SEQUENCE = v_user_sequence
4952: and jut.TRANS_ACCESS_CODE7 is not null
4953: and jut.TERR_RSC_ACCESS_ID7 is not null
4954: and jut.header = v_header

Line 4960: FROM JTY_WEBADI_RESOURCES jut

4956: union all
4957: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4958: 8 qual_type_num, TERR_RSC_ACCESS_ID8 TERR_RSC_ACCESS_ID,
4959: TRANS_ACCESS_CODE8 TRANS_ACCESS_CODE
4960: FROM JTY_WEBADI_RESOURCES jut
4961: where jut.USER_SEQUENCE = v_user_sequence
4962: and jut.TRANS_ACCESS_CODE8 is not null
4963: and jut.TERR_RSC_ACCESS_ID8 is not null
4964: and jut.header = v_header

Line 4970: FROM JTY_WEBADI_RESOURCES jut

4966: union all
4967: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4968: 9 qual_type_num, TERR_RSC_ACCESS_ID9 TERR_RSC_ACCESS_ID,
4969: TRANS_ACCESS_CODE9 TRANS_ACCESS_CODE
4970: FROM JTY_WEBADI_RESOURCES jut
4971: where jut.USER_SEQUENCE = v_user_sequence
4972: and jut.TRANS_ACCESS_CODE9 is not null
4973: and jut.TERR_RSC_ACCESS_ID9 is not null
4974: and jut.header = v_header

Line 4980: FROM JTY_WEBADI_RESOURCES jut

4976: union all
4977: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4978: 10 qual_type_num, TERR_RSC_ACCESS_ID10 TERR_RSC_ACCESS_ID,
4979: TRANS_ACCESS_CODE10 TRANS_ACCESS_CODE
4980: FROM JTY_WEBADI_RESOURCES jut
4981: where jut.USER_SEQUENCE = v_user_sequence
4982: and jut.TRANS_ACCESS_CODE10 is not null
4983: and jut.TERR_RSC_ACCESS_ID10 is not null
4984: and jut.header = v_header

Line 5117: update JTY_WEBADI_RESOURCES

5113: --dbms_output.put_line(' # records processed for create: '||SQL%ROWCOUNT);
5114:
5115: if (l_get_terr_rsc_rec.terr_rsc_id.count > 0) then
5116: forall i in l_get_terr_rsc_rec.terr_rsc_id.first..l_get_terr_rsc_rec.terr_rsc_id.last
5117: update JTY_WEBADI_RESOURCES
5118: set terr_rsc_id = l_get_terr_rsc_rec.terr_rsc_id(i)
5119: where resource_id = l_get_terr_rsc_rec.resource_id(i)
5120: -- and terr_id = l_get_terr_rsc_rec.terr_id(i)
5121: and interface_type = l_intf_type

Line 5230: (select 1 from JTY_WEBADI_RESOURCES jwr

5226: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last
5227: update JTY_WEBADI_OTH_TERR_INTF jwot
5228: set status = x_return_status
5229: where exists
5230: (select 1 from JTY_WEBADI_RESOURCES jwr
5231: where jwr.LAY_SEQ_NUM = jwot.LAY_SEQ_NUM
5232: and jwr.header = jwot.header
5233: and jwr.user_sequence = jwot.user_sequence
5234: and jwr.interface_type = jwot.interface_type

Line 5254: (select 1 from JTY_WEBADI_RESOURCES jwr

5250: update JTY_WEBADI_OTH_TERR_INTF jwot
5251: set status = x_return_status,
5252: error_msg = x_msg_data
5253: where exists
5254: (select 1 from JTY_WEBADI_RESOURCES jwr
5255: where jwr.LAY_SEQ_NUM = jwot.LAY_SEQ_NUM
5256: and jwr.header = jwot.header
5257: and jwr.user_sequence = jwot.user_sequence
5258: and jwr.interface_type = jwot.interface_type

Line 5295: (select 1 from JTY_WEBADI_RESOURCES jwr

5291: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last
5292: update JTY_WEBADI_OTH_TERR_INTF jwot
5293: set status = x_return_status
5294: where exists
5295: (select 1 from JTY_WEBADI_RESOURCES jwr
5296: where jwr.LAY_SEQ_NUM = jwot.LAY_SEQ_NUM
5297: and jwr.header = jwot.header
5298: and jwr.user_sequence = jwot.user_sequence
5299: and jwr.interface_type = jwot.interface_type

Line 5319: (select 1 from JTY_WEBADI_RESOURCES jwr

5315: update JTY_WEBADI_OTH_TERR_INTF jwot
5316: set status = x_return_status,
5317: error_msg = x_msg_data
5318: where exists
5319: (select 1 from JTY_WEBADI_RESOURCES jwr
5320: where jwr.LAY_SEQ_NUM = jwot.LAY_SEQ_NUM
5321: and jwr.header = jwot.header
5322: and jwr.user_sequence = jwot.user_sequence
5323: and jwr.interface_type = jwot.interface_type

Line 5342: (select 1 from JTY_WEBADI_RESOURCES jwr

5338: update JTY_WEBADI_OTH_TERR_INTF jwot
5339: set status = x_return_status,
5340: error_msg = X_Msg_Data
5341: where exists
5342: (select 1 from JTY_WEBADI_RESOURCES jwr
5343: where jwr.LAY_SEQ_NUM = jwot.LAY_SEQ_NUM
5344: and jwr.header = jwot.header
5345: and jwr.user_sequence = jwot.user_sequence
5346: and jwr.interface_type = jwot.interface_type)