[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*)
INTO l_num_of_terr
FROM jtf_terr_denorm_rules_all jtdr
WHERE jtdr.source_id = p_source_id
AND rownum < 2;
SELECT COUNT(*)
INTO l_num_of_terr
FROM jtf_terr_denorm_rules_all jtdr
WHERE jtdr.source_id = p_source_id
AND rownum < 2;
DELETE jty_terr_1003_offer_trans_gt;
INSERT INTO jty_terr_1003_offer_trans_gt (
use_type
,source_id
,transaction_id
,trans_object_id
,trans_detail_object_id
,SQUAL_CHAR01
,SQUAL_CHAR02
,SQUAL_CHAR03
,SQUAL_CHAR04
,SQUAL_CHAR05
,SQUAL_CHAR06
,SQUAL_CHAR07
,SQUAL_CHAR08
,SQUAL_CHAR09
,SQUAL_CHAR10
,SQUAL_CHAR11
,SQUAL_CHAR12
,SQUAL_CHAR13
,SQUAL_CHAR14
,SQUAL_CHAR15
,SQUAL_CHAR16
,SQUAL_CHAR17
,SQUAL_CHAR18
,SQUAL_CHAR19
,SQUAL_CHAR20
,SQUAL_CHAR21
,SQUAL_CHAR22
,SQUAL_CHAR23
,SQUAL_CHAR24
,SQUAL_CHAR25
,SQUAL_CHAR26
,SQUAL_CHAR27
,SQUAL_CHAR28
,SQUAL_CHAR29
,SQUAL_CHAR30
,SQUAL_CHAR31
,SQUAL_CHAR32
,SQUAL_CHAR33
,SQUAL_CHAR34
,SQUAL_CHAR35
,SQUAL_CHAR36
,SQUAL_CHAR37
,SQUAL_CHAR38
,SQUAL_CHAR39
,SQUAL_CHAR40
,SQUAL_CHAR41
,SQUAL_CHAR42
,SQUAL_CHAR43
,SQUAL_CHAR44
,SQUAL_CHAR45
,SQUAL_CHAR46
,SQUAL_CHAR47
,SQUAL_CHAR48
,SQUAL_CHAR49
,SQUAL_CHAR50
,SQUAL_NUM01
,SQUAL_NUM02
,SQUAL_NUM03
,SQUAL_NUM04
,SQUAL_NUM05
,SQUAL_NUM06
,SQUAL_NUM07
,SQUAL_NUM08
,SQUAL_NUM09
,SQUAL_NUM10
,SQUAL_NUM11
,SQUAL_NUM12
,SQUAL_NUM13
,SQUAL_NUM14
,SQUAL_NUM15
,SQUAL_NUM16
,SQUAL_NUM17
,SQUAL_NUM18
,SQUAL_NUM19
,SQUAL_NUM20
,SQUAL_NUM21
,SQUAL_NUM22
,SQUAL_NUM23
,SQUAL_NUM24
,SQUAL_NUM25
,SQUAL_NUM26
,SQUAL_NUM27
,SQUAL_NUM28
,SQUAL_NUM29
,SQUAL_NUM30
,SQUAL_NUM31
,SQUAL_NUM32
,SQUAL_NUM33
,SQUAL_NUM34
,SQUAL_NUM35
,SQUAL_NUM36
,SQUAL_NUM37
,SQUAL_NUM38
,SQUAL_NUM39
,SQUAL_NUM40
,SQUAL_NUM41
,SQUAL_NUM42
,SQUAL_NUM43
,SQUAL_NUM44
,SQUAL_NUM45
,SQUAL_NUM46
,SQUAL_NUM47
,SQUAL_NUM48
,SQUAL_NUM49
,SQUAL_NUM50
,txn_date
)
VALUES (
p_use_type
,p_source_id
,p_trans_id
,p_trans_rec.trans_object_id(i)
,p_trans_rec.trans_detail_object_id(i)
,p_trans_rec.SQUAL_CHAR01(i)
,p_trans_rec.SQUAL_CHAR02(i)
,p_trans_rec.SQUAL_CHAR03(i)
,p_trans_rec.SQUAL_CHAR04(i)
,p_trans_rec.SQUAL_CHAR05(i)
,p_trans_rec.SQUAL_CHAR06(i)
,p_trans_rec.SQUAL_CHAR07(i)
,p_trans_rec.SQUAL_CHAR08(i)
,p_trans_rec.SQUAL_CHAR09(i)
,p_trans_rec.SQUAL_CHAR10(i)
,p_trans_rec.SQUAL_CHAR11(i)
,p_trans_rec.SQUAL_CHAR12(i)
,p_trans_rec.SQUAL_CHAR13(i)
,p_trans_rec.SQUAL_CHAR14(i)
,p_trans_rec.SQUAL_CHAR15(i)
,p_trans_rec.SQUAL_CHAR16(i)
,p_trans_rec.SQUAL_CHAR17(i)
,p_trans_rec.SQUAL_CHAR18(i)
,p_trans_rec.SQUAL_CHAR19(i)
,p_trans_rec.SQUAL_CHAR20(i)
,p_trans_rec.SQUAL_CHAR21(i)
,p_trans_rec.SQUAL_CHAR22(i)
,p_trans_rec.SQUAL_CHAR23(i)
,p_trans_rec.SQUAL_CHAR24(i)
,p_trans_rec.SQUAL_CHAR25(i)
,p_trans_rec.SQUAL_CHAR26(i)
,p_trans_rec.SQUAL_CHAR27(i)
,p_trans_rec.SQUAL_CHAR28(i)
,p_trans_rec.SQUAL_CHAR29(i)
,p_trans_rec.SQUAL_CHAR30(i)
,p_trans_rec.SQUAL_CHAR31(i)
,p_trans_rec.SQUAL_CHAR32(i)
,p_trans_rec.SQUAL_CHAR33(i)
,p_trans_rec.SQUAL_CHAR34(i)
,p_trans_rec.SQUAL_CHAR35(i)
,p_trans_rec.SQUAL_CHAR36(i)
,p_trans_rec.SQUAL_CHAR37(i)
,p_trans_rec.SQUAL_CHAR38(i)
,p_trans_rec.SQUAL_CHAR39(i)
,p_trans_rec.SQUAL_CHAR40(i)
,p_trans_rec.SQUAL_CHAR41(i)
,p_trans_rec.SQUAL_CHAR42(i)
,p_trans_rec.SQUAL_CHAR43(i)
,p_trans_rec.SQUAL_CHAR44(i)
,p_trans_rec.SQUAL_CHAR45(i)
,p_trans_rec.SQUAL_CHAR46(i)
,p_trans_rec.SQUAL_CHAR47(i)
,p_trans_rec.SQUAL_CHAR48(i)
,p_trans_rec.SQUAL_CHAR49(i)
,p_trans_rec.SQUAL_CHAR50(i)
,p_trans_rec.SQUAL_NUM01(i)
,p_trans_rec.SQUAL_NUM02(i)
,p_trans_rec.SQUAL_NUM03(i)
,p_trans_rec.SQUAL_NUM04(i)
,p_trans_rec.SQUAL_NUM05(i)
,p_trans_rec.SQUAL_NUM06(i)
,p_trans_rec.SQUAL_NUM07(i)
,p_trans_rec.SQUAL_NUM08(i)
,p_trans_rec.SQUAL_NUM09(i)
,p_trans_rec.SQUAL_NUM10(i)
,p_trans_rec.SQUAL_NUM11(i)
,p_trans_rec.SQUAL_NUM12(i)
,p_trans_rec.SQUAL_NUM13(i)
,p_trans_rec.SQUAL_NUM14(i)
,p_trans_rec.SQUAL_NUM15(i)
,p_trans_rec.SQUAL_NUM16(i)
,p_trans_rec.SQUAL_NUM17(i)
,p_trans_rec.SQUAL_NUM18(i)
,p_trans_rec.SQUAL_NUM19(i)
,p_trans_rec.SQUAL_NUM20(i)
,p_trans_rec.SQUAL_NUM21(i)
,p_trans_rec.SQUAL_NUM22(i)
,p_trans_rec.SQUAL_NUM23(i)
,p_trans_rec.SQUAL_NUM24(i)
,p_trans_rec.SQUAL_NUM25(i)
,p_trans_rec.SQUAL_NUM26(i)
,p_trans_rec.SQUAL_NUM27(i)
,p_trans_rec.SQUAL_NUM28(i)
,p_trans_rec.SQUAL_NUM29(i)
,p_trans_rec.SQUAL_NUM30(i)
,p_trans_rec.SQUAL_NUM31(i)
,p_trans_rec.SQUAL_NUM32(i)
,p_trans_rec.SQUAL_NUM33(i)
,p_trans_rec.SQUAL_NUM34(i)
,p_trans_rec.SQUAL_NUM35(i)
,p_trans_rec.SQUAL_NUM36(i)
,p_trans_rec.SQUAL_NUM37(i)
,p_trans_rec.SQUAL_NUM38(i)
,p_trans_rec.SQUAL_NUM39(i)
,p_trans_rec.SQUAL_NUM40(i)
,p_trans_rec.SQUAL_NUM41(i)
,p_trans_rec.SQUAL_NUM42(i)
,p_trans_rec.SQUAL_NUM43(i)
,p_trans_rec.SQUAL_NUM44(i)
,p_trans_rec.SQUAL_NUM45(i)
,p_trans_rec.SQUAL_NUM46(i)
,p_trans_rec.SQUAL_NUM47(i)
,p_trans_rec.SQUAL_NUM48(i)
,p_trans_rec.SQUAL_NUM49(i)
,p_trans_rec.SQUAL_NUM50(i)
,l_sysdate
);
DELETE jty_terr_1003_claim_trans_gt;
INSERT INTO jty_terr_1003_claim_trans_gt (
use_type
,source_id
,transaction_id
,trans_object_id
,trans_detail_object_id
,SQUAL_CHAR01
,SQUAL_CHAR02
,SQUAL_CHAR03
,SQUAL_CHAR04
,SQUAL_CHAR05
,SQUAL_CHAR06
,SQUAL_CHAR07
,SQUAL_CHAR08
,SQUAL_CHAR09
,SQUAL_CHAR10
,SQUAL_CHAR11
,SQUAL_CHAR12
,SQUAL_CHAR13
,SQUAL_CHAR14
,SQUAL_CHAR15
,SQUAL_CHAR16
,SQUAL_CHAR17
,SQUAL_CHAR18
,SQUAL_CHAR19
,SQUAL_CHAR20
,SQUAL_CHAR21
,SQUAL_CHAR22
,SQUAL_CHAR23
,SQUAL_CHAR24
,SQUAL_CHAR25
,SQUAL_CHAR26
,SQUAL_CHAR27
,SQUAL_CHAR28
,SQUAL_CHAR29
,SQUAL_CHAR30
,SQUAL_CHAR31
,SQUAL_CHAR32
,SQUAL_CHAR33
,SQUAL_CHAR34
,SQUAL_CHAR35
,SQUAL_CHAR36
,SQUAL_CHAR37
,SQUAL_CHAR38
,SQUAL_CHAR39
,SQUAL_CHAR40
,SQUAL_CHAR41
,SQUAL_CHAR42
,SQUAL_CHAR43
,SQUAL_CHAR44
,SQUAL_CHAR45
,SQUAL_CHAR46
,SQUAL_CHAR47
,SQUAL_CHAR48
,SQUAL_CHAR49
,SQUAL_CHAR50
,SQUAL_NUM01
,SQUAL_NUM02
,SQUAL_NUM03
,SQUAL_NUM04
,SQUAL_NUM05
,SQUAL_NUM06
,SQUAL_NUM07
,SQUAL_NUM08
,SQUAL_NUM09
,SQUAL_NUM10
,SQUAL_NUM11
,SQUAL_NUM12
,SQUAL_NUM13
,SQUAL_NUM14
,SQUAL_NUM15
,SQUAL_NUM16
,SQUAL_NUM17
,SQUAL_NUM18
,SQUAL_NUM19
,SQUAL_NUM20
,SQUAL_NUM21
,SQUAL_NUM22
,SQUAL_NUM23
,SQUAL_NUM24
,SQUAL_NUM25
,SQUAL_NUM26
,SQUAL_NUM27
,SQUAL_NUM28
,SQUAL_NUM29
,SQUAL_NUM30
,SQUAL_NUM31
,SQUAL_NUM32
,SQUAL_NUM33
,SQUAL_NUM34
,SQUAL_NUM35
,SQUAL_NUM36
,SQUAL_NUM37
,SQUAL_NUM38
,SQUAL_NUM39
,SQUAL_NUM40
,SQUAL_NUM41
,SQUAL_NUM42
,SQUAL_NUM43
,SQUAL_NUM44
,SQUAL_NUM45
,SQUAL_NUM46
,SQUAL_NUM47
,SQUAL_NUM48
,SQUAL_NUM49
,SQUAL_NUM50
,txn_date
)
VALUES (
p_use_type
,p_source_id
,p_trans_id
,p_trans_rec.trans_object_id(i)
,p_trans_rec.trans_detail_object_id(i)
,p_trans_rec.SQUAL_CHAR01(i)
,p_trans_rec.SQUAL_CHAR02(i)
,p_trans_rec.SQUAL_CHAR03(i)
,p_trans_rec.SQUAL_CHAR04(i)
,p_trans_rec.SQUAL_CHAR05(i)
,p_trans_rec.SQUAL_CHAR06(i)
,p_trans_rec.SQUAL_CHAR07(i)
,p_trans_rec.SQUAL_CHAR08(i)
,p_trans_rec.SQUAL_CHAR09(i)
,p_trans_rec.SQUAL_CHAR10(i)
,p_trans_rec.SQUAL_CHAR11(i)
,p_trans_rec.SQUAL_CHAR12(i)
,p_trans_rec.SQUAL_CHAR13(i)
,p_trans_rec.SQUAL_CHAR14(i)
,p_trans_rec.SQUAL_CHAR15(i)
,p_trans_rec.SQUAL_CHAR16(i)
,p_trans_rec.SQUAL_CHAR17(i)
,p_trans_rec.SQUAL_CHAR18(i)
,p_trans_rec.SQUAL_CHAR19(i)
,p_trans_rec.SQUAL_CHAR20(i)
,p_trans_rec.SQUAL_CHAR21(i)
,p_trans_rec.SQUAL_CHAR22(i)
,p_trans_rec.SQUAL_CHAR23(i)
,p_trans_rec.SQUAL_CHAR24(i)
,p_trans_rec.SQUAL_CHAR25(i)
,p_trans_rec.SQUAL_CHAR26(i)
,p_trans_rec.SQUAL_CHAR27(i)
,p_trans_rec.SQUAL_CHAR28(i)
,p_trans_rec.SQUAL_CHAR29(i)
,p_trans_rec.SQUAL_CHAR30(i)
,p_trans_rec.SQUAL_CHAR31(i)
,p_trans_rec.SQUAL_CHAR32(i)
,p_trans_rec.SQUAL_CHAR33(i)
,p_trans_rec.SQUAL_CHAR34(i)
,p_trans_rec.SQUAL_CHAR35(i)
,p_trans_rec.SQUAL_CHAR36(i)
,p_trans_rec.SQUAL_CHAR37(i)
,p_trans_rec.SQUAL_CHAR38(i)
,p_trans_rec.SQUAL_CHAR39(i)
,p_trans_rec.SQUAL_CHAR40(i)
,p_trans_rec.SQUAL_CHAR41(i)
,p_trans_rec.SQUAL_CHAR42(i)
,p_trans_rec.SQUAL_CHAR43(i)
,p_trans_rec.SQUAL_CHAR44(i)
,p_trans_rec.SQUAL_CHAR45(i)
,p_trans_rec.SQUAL_CHAR46(i)
,p_trans_rec.SQUAL_CHAR47(i)
,p_trans_rec.SQUAL_CHAR48(i)
,p_trans_rec.SQUAL_CHAR49(i)
,p_trans_rec.SQUAL_CHAR50(i)
,p_trans_rec.SQUAL_NUM01(i)
,p_trans_rec.SQUAL_NUM02(i)
,p_trans_rec.SQUAL_NUM03(i)
,p_trans_rec.SQUAL_NUM04(i)
,p_trans_rec.SQUAL_NUM05(i)
,p_trans_rec.SQUAL_NUM06(i)
,p_trans_rec.SQUAL_NUM07(i)
,p_trans_rec.SQUAL_NUM08(i)
,p_trans_rec.SQUAL_NUM09(i)
,p_trans_rec.SQUAL_NUM10(i)
,p_trans_rec.SQUAL_NUM11(i)
,p_trans_rec.SQUAL_NUM12(i)
,p_trans_rec.SQUAL_NUM13(i)
,p_trans_rec.SQUAL_NUM14(i)
,p_trans_rec.SQUAL_NUM15(i)
,p_trans_rec.SQUAL_NUM16(i)
,p_trans_rec.SQUAL_NUM17(i)
,p_trans_rec.SQUAL_NUM18(i)
,p_trans_rec.SQUAL_NUM19(i)
,p_trans_rec.SQUAL_NUM20(i)
,p_trans_rec.SQUAL_NUM21(i)
,p_trans_rec.SQUAL_NUM22(i)
,p_trans_rec.SQUAL_NUM23(i)
,p_trans_rec.SQUAL_NUM24(i)
,p_trans_rec.SQUAL_NUM25(i)
,p_trans_rec.SQUAL_NUM26(i)
,p_trans_rec.SQUAL_NUM27(i)
,p_trans_rec.SQUAL_NUM28(i)
,p_trans_rec.SQUAL_NUM29(i)
,p_trans_rec.SQUAL_NUM30(i)
,p_trans_rec.SQUAL_NUM31(i)
,p_trans_rec.SQUAL_NUM32(i)
,p_trans_rec.SQUAL_NUM33(i)
,p_trans_rec.SQUAL_NUM34(i)
,p_trans_rec.SQUAL_NUM35(i)
,p_trans_rec.SQUAL_NUM36(i)
,p_trans_rec.SQUAL_NUM37(i)
,p_trans_rec.SQUAL_NUM38(i)
,p_trans_rec.SQUAL_NUM39(i)
,p_trans_rec.SQUAL_NUM40(i)
,p_trans_rec.SQUAL_NUM41(i)
,p_trans_rec.SQUAL_NUM42(i)
,p_trans_rec.SQUAL_NUM43(i)
,p_trans_rec.SQUAL_NUM44(i)
,p_trans_rec.SQUAL_NUM45(i)
,p_trans_rec.SQUAL_NUM46(i)
,p_trans_rec.SQUAL_NUM47(i)
,p_trans_rec.SQUAL_NUM48(i)
,p_trans_rec.SQUAL_NUM49(i)
,p_trans_rec.SQUAL_NUM50(i)
,l_sysdate
);
DELETE jty_terr_1500_cntrct_trans_gt;
INSERT INTO jty_terr_1500_cntrct_trans_gt (
use_type
,source_id
,transaction_id
,trans_object_id
,trans_detail_object_id
,SQUAL_CHAR01
,SQUAL_CHAR04
,SQUAL_CHAR07
,SQUAL_NUM01
,txn_date
)
VALUES (
p_use_type
,p_source_id
,p_trans_id
,p_trans_rec.trans_object_id(i)
,p_trans_rec.trans_detail_object_id(i)
,p_trans_rec.SQUAL_CHAR01(i)
,p_trans_rec.SQUAL_CHAR04(i)
,p_trans_rec.SQUAL_CHAR07(i)
,p_trans_rec.SQUAL_NUM01(i)
,l_sysdate
);
DELETE jty_terr_1700_partner_trans_gt;
INSERT INTO jty_terr_1700_partner_trans_gt (
use_type
,source_id
,transaction_id
,trans_object_id
,trans_detail_object_id
,SQUAL_CHAR01
,SQUAL_CHAR02
,SQUAL_CHAR03
,SQUAL_CHAR04
,SQUAL_CHAR05
,SQUAL_CHAR06
,SQUAL_CHAR07
,SQUAL_CHAR08
,SQUAL_CHAR09
,SQUAL_CHAR10
,SQUAL_CHAR11
,SQUAL_CHAR12
,SQUAL_CHAR13
,SQUAL_CHAR14
,SQUAL_CHAR15
,SQUAL_CHAR16
,SQUAL_CHAR17
,SQUAL_CHAR18
,SQUAL_CHAR19
,SQUAL_CHAR20
,SQUAL_NUM01
,SQUAL_NUM02
,SQUAL_NUM03
,SQUAL_NUM04
,SQUAL_NUM05
,SQUAL_NUM06
,SQUAL_NUM07
,SQUAL_NUM08
,SQUAL_NUM09
,SQUAL_NUM10
,SQUAL_NUM11
,SQUAL_NUM12
,SQUAL_NUM13
,SQUAL_NUM14
,SQUAL_NUM15
,SQUAL_NUM16
,SQUAL_NUM17
,SQUAL_NUM18
,SQUAL_NUM19
,SQUAL_NUM20
,SQUAL_CURC01
,txn_date
)
VALUES (
p_use_type
,-1700
,-1701
,p_trans_rec.trans_object_id(i)
,p_trans_rec.trans_detail_object_id(i)
,p_trans_rec.SQUAL_CHAR01(i)
,p_trans_rec.SQUAL_CHAR02(i)
,p_trans_rec.SQUAL_CHAR03(i)
,p_trans_rec.SQUAL_CHAR04(i)
,p_trans_rec.SQUAL_CHAR05(i)
,p_trans_rec.SQUAL_CHAR06(i)
,p_trans_rec.SQUAL_CHAR07(i)
,p_trans_rec.SQUAL_CHAR08(i)
,p_trans_rec.SQUAL_CHAR09(i)
,p_trans_rec.SQUAL_CHAR10(i)
,p_trans_rec.SQUAL_CHAR11(i)
,p_trans_rec.SQUAL_CHAR12(i)
,p_trans_rec.SQUAL_CHAR13(i)
,p_trans_rec.SQUAL_CHAR14(i)
,p_trans_rec.SQUAL_CHAR15(i)
,p_trans_rec.SQUAL_CHAR16(i)
,p_trans_rec.SQUAL_CHAR17(i)
,p_trans_rec.SQUAL_CHAR18(i)
,p_trans_rec.SQUAL_CHAR19(i)
,p_trans_rec.SQUAL_CHAR20(i)
,p_trans_rec.SQUAL_NUM01(i)
,p_trans_rec.SQUAL_NUM02(i)
,p_trans_rec.SQUAL_NUM03(i)
,p_trans_rec.SQUAL_NUM04(i)
,p_trans_rec.SQUAL_NUM05(i)
,p_trans_rec.SQUAL_NUM06(i)
,p_trans_rec.SQUAL_NUM07(i)
,p_trans_rec.SQUAL_NUM08(i)
,p_trans_rec.SQUAL_NUM09(i)
,p_trans_rec.SQUAL_NUM10(i)
,p_trans_rec.SQUAL_NUM11(i)
,p_trans_rec.SQUAL_NUM12(i)
,p_trans_rec.SQUAL_NUM13(i)
,p_trans_rec.SQUAL_NUM14(i)
,p_trans_rec.SQUAL_NUM15(i)
,p_trans_rec.SQUAL_NUM16(i)
,p_trans_rec.SQUAL_NUM17(i)
,p_trans_rec.SQUAL_NUM18(i)
,p_trans_rec.SQUAL_NUM19(i)
,p_trans_rec.SQUAL_NUM20(i)
,p_trans_rec.SQUAL_CURC01(i)
,l_sysdate
);