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.ARH_DQM_CUST_HELPER dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 95: -- Return Y if the P_CUST_ACCT_SITE_ID is already inserted in HZ_MATCHED_PARTY_SITES_GT

91: END;
92:
93: FUNCTION Is_acct_site_in_ps_gt
94: ---------------------------------------------------------------------------------------
95: -- Return Y if the P_CUST_ACCT_SITE_ID is already inserted in HZ_MATCHED_PARTY_SITES_GT
96: -- Otherwise N
97: ---------------------------------------------------------------------------------------
98: ( p_ctx_id IN NUMBER,
99: p_cust_acct_site_id IN NUMBER,

Line 107: FROM hz_matched_party_sites_gt a,

103: RETURN VARCHAR2
104: IS
105: CURSOR c1 IS
106: SELECT 'Y'
107: FROM hz_matched_party_sites_gt a,
108: hz_cust_acct_sites b
109: WHERE a.search_context_id = p_ctx_id
110: AND -a.party_id = p_cust_account_id
111: AND -a.party_site_id = p_cust_acct_site_id

Line 119: FROM hz_matched_party_sites_gt a,

115: AND a.score < 0;
116:
117: CURSOR c2 IS
118: SELECT 'Y'
119: FROM hz_matched_party_sites_gt a,
120: hz_cust_acct_sites_all b
121: WHERE a.search_context_id = p_ctx_id
122: AND -a.party_id = p_cust_account_id
123: AND -a.party_site_id = p_cust_acct_site_id

Line 216: -- Return the score of the party_site related to a cust_acct_site in HZ_MATCHED_PARTY_SITES_GT if found

212: END;
213:
214: FUNCTION score_of_rel_ps
215: -------------------------------------------------------------------------------------------------------
216: -- Return the score of the party_site related to a cust_acct_site in HZ_MATCHED_PARTY_SITES_GT if found
217: -- Otherwise -99999
218: -------------------------------------------------------------------------------------------------------
219: ( p_ctx_id IN NUMBER,
220: p_cust_acct_site_id IN NUMBER,

Line 228: hz_matched_party_sites_gt b,

224: IS
225: CURSOR c1 IS
226: SELECT NVL(b.score,0)
227: FROM hz_cust_acct_sites a,
228: hz_matched_party_sites_gt b,
229: hz_party_sites c
230: WHERE a.cust_acct_site_id = p_cust_acct_site_id
231: AND DECODE(p_status,'ALL','ALL',NVL(a.status,'A')) = p_status
232: AND a.party_site_id = b.party_site_id

Line 241: hz_matched_party_sites_gt b,

237:
238: CURSOR c2 IS
239: SELECT NVL(b.score,0)
240: FROM hz_cust_acct_sites_all a,
241: hz_matched_party_sites_gt b,
242: hz_party_sites c
243: WHERE a.cust_acct_site_id = p_cust_acct_site_id
244: AND DECODE(p_status,'ALL','ALL',NVL(a.status,'A')) = p_status
245: AND a.party_site_id = b.party_site_id

Line 273: -- Insert in CUST_ACCT_SITE_ID in HZ_MATCHED_PARTY_SITES_GT

269: END;
270:
271: PROCEDURE ins_as_in_ps_gt
272: -------------------------------------------------------------------------
273: -- Insert in CUST_ACCT_SITE_ID in HZ_MATCHED_PARTY_SITES_GT
274: -- If 1) the cust_acct_site_id is related to a matched party
275: -- 2) the cust_acct_site_id is not yet in HZ_MATCHED_PARTY_SITES_GT
276: -------------------------------------------------------------------------
277: -- CUST_ACCOUNT_ID CUST_ACCT_SITE_ID -PSscore(-1) SEARCH_CONTEXT_ID

Line 275: -- 2) the cust_acct_site_id is not yet in HZ_MATCHED_PARTY_SITES_GT

271: PROCEDURE ins_as_in_ps_gt
272: -------------------------------------------------------------------------
273: -- Insert in CUST_ACCT_SITE_ID in HZ_MATCHED_PARTY_SITES_GT
274: -- If 1) the cust_acct_site_id is related to a matched party
275: -- 2) the cust_acct_site_id is not yet in HZ_MATCHED_PARTY_SITES_GT
276: -------------------------------------------------------------------------
277: -- CUST_ACCOUNT_ID CUST_ACCT_SITE_ID -PSscore(-1) SEARCH_CONTEXT_ID
278: -------------------------------------------------------------------------
279: ( p_ctx_id IN NUMBER,

Line 312: INSERT INTO hz_matched_party_sites_gt

308: ELSE
309: l_ps_score := -1;
310: END IF;
311:
312: INSERT INTO hz_matched_party_sites_gt
313: ( PARTY_ID , PARTY_SITE_ID ,SCORE , SEARCH_CONTEXT_ID ) VALUES
314: ( -p_cust_account_id, -p_cust_acct_site_id ,l_ps_score , p_ctx_id );
315:
316: END IF;

Line 358: FROM hz_matched_party_sites_gt a,

354: RETURN VARCHAR2
355: IS
356: CURSOR c1 IS
357: SELECT 'Y'
358: FROM hz_matched_party_sites_gt a,
359: hz_cust_acct_sites b
360: WHERE a.search_context_id = p_ctx_id
361: AND NVL(a.score,0) >= 0
362: AND a.party_site_id = b.party_site_id

Line 368: FROM hz_matched_party_sites_gt a,

364: AND DECODE(p_status, 'ALL','ALL', NVL(b.status,'A')) = p_status;
365:
366: CURSOR c2 IS
367: SELECT 'Y'
368: FROM hz_matched_party_sites_gt a,
369: hz_cust_acct_sites_all b
370: WHERE a.search_context_id = p_ctx_id
371: AND NVL(a.score,0) >= 0
372: AND a.party_site_id = b.party_site_id

Line 501: --{ B Insert Cust_Acct_site_id in HZ_MATCHED_PARTY_SITES_GT

497: ( PARTY_ID , ORG_CONTACT_ID , SCORE , SEARCH_CONTEXT_ID) VALUES
498: ( -lrec.cust_account_id, -lrec.cust_account_role_id, l_score , p_ctx_id );
499:
500: ---------------------------------------------------------
501: --{ B Insert Cust_Acct_site_id in HZ_MATCHED_PARTY_SITES_GT
502: ---------------------------------------------------------
503: ins_as_in_ps_gt( p_ctx_id => p_ctx_id,
504: p_cust_account_id => lrec.cust_account_id,
505: p_cust_acct_site_id => lrec.cust_acct_site_id,

Line 566: -- INSERT all the CUST_ACCT_SITE_ID related to the P_PARTY_SITE_ID in HZ_MATCHED_PARTY_SITES_GT

562:
563:
564: PROCEDURE find_as_rel_ps
565: -----------------------------------------------------------------------------------------------
566: -- INSERT all the CUST_ACCT_SITE_ID related to the P_PARTY_SITE_ID in HZ_MATCHED_PARTY_SITES_GT
567: -- If necesary insert also the CUST_ACCOUNT_ID related in HZ_MATCHED_PARTIES_GT
568: -----------------------------------------------------------------------------------------------
569: ( p_ctx_id IN NUMBER,
570: p_party_site_id IN NUMBER,

Line 615: INSERT INTO hz_matched_party_sites_gt

611: l_score := -1;
612: ELSE
613: l_score := -p_score;
614: END IF;
615: INSERT INTO hz_matched_party_sites_gt
616: ( PARTY_ID , PARTY_SITE_ID ,SCORE , SEARCH_CONTEXT_ID ) VALUES
617: ( -l_cust_account_id , -l_cust_acct_site_id ,l_score , p_ctx_id );
618: END IF;
619: --}

Line 649: -- Return Y if the CUST_ACCT_SITE_ID related to the P_PARTY_SITE_ID exist in HZ_MATCHED_PARTY_SITES_GT

645:
646:
647: FUNCTION is_as_rel_ps_in_ps_gt
648: ------------------------------------------------------------------------------------------------------
649: -- Return Y if the CUST_ACCT_SITE_ID related to the P_PARTY_SITE_ID exist in HZ_MATCHED_PARTY_SITES_GT
650: ------------------------------------------------------------------------------------------------------
651: ( p_ctx_id IN NUMBER,
652: p_party_site_id IN NUMBER,
653: p_cur_all IN VARCHAR2,

Line 660: hz_matched_party_sites_gt c

656: IS
657: CURSOR c1 IS
658: SELECT 'Y'
659: FROM hz_cust_acct_sites b,
660: hz_matched_party_sites_gt c
661: WHERE b.party_site_id = p_party_site_id
662: AND b.cust_acct_site_id = -c.party_site_id
663: AND c.search_context_id = p_ctx_id
664: AND c.score < 0

Line 670: hz_matched_party_sites_gt c

666:
667: CURSOR c2 IS
668: SELECT 'Y'
669: FROM hz_cust_acct_sites_all b,
670: hz_matched_party_sites_gt c
671: WHERE b.party_site_id = p_party_site_id
672: AND b.cust_acct_site_id = -c.party_site_id
673: AND c.search_context_id = p_ctx_id
674: AND c.score < 0

Line 751: -- Cust Account Site / Party Site treatment in HZ_MATCHED_PARTY_SITES_GT

747: END;
748:
749: PROCEDURE as_ps_treatment
750: ------------------------------------------------------------------------
751: -- Cust Account Site / Party Site treatment in HZ_MATCHED_PARTY_SITES_GT
752: ------------------------------------------------------------------------
753: ( p_ctx_id IN NUMBER ,
754: p_cur_all IN VARCHAR2,
755: p_status IN VARCHAR2 )

Line 760: FROM hz_matched_party_sites_gt a

756: IS
757: CURSOR c1 IS
758: SELECT a.party_site_id,
759: NVL(a.score,0) score
760: FROM hz_matched_party_sites_gt a
761: WHERE a.search_context_id = p_ctx_id
762: AND NVL(a.score,0) >= 0;
763:
764: lrec c1%ROWTYPE;

Line 840: FROM hz_matched_party_sites_gt

836: RETURN VARCHAR2
837: IS
838: CURSOR c1 IS
839: SELECT 'Y'
840: FROM hz_matched_party_sites_gt
841: WHERE search_context_id = p_ctx_id
842: AND NVL(score,0) >= 0
843: AND party_id = p_party_id;
844: