APPS.QP_ATM_UPGRADE dependencies on QP_PTE_SOURCE_SYSTEMS

Line 96: -- Private function to check if Source System Exists in QP_PTE_SOURCE_SYSTEMS table

92: --
93:
94: FUNCTION p_ssc_exists(p_application_short_name in varchar2,
95: p_pte_code in varchar2) return number is
96: -- Private function to check if Source System Exists in QP_PTE_SOURCE_SYSTEMS table
97: -- for a given PTE.
98: dummy varchar2(1);
99: begin
100: select 'x'

Line 102: from qp_pte_source_systems

98: dummy varchar2(1);
99: begin
100: select 'x'
101: into dummy
102: from qp_pte_source_systems
103: where application_short_name = p_application_short_name and
104: pte_code = p_pte_code and
105: rownum = 1;
106: return(0);

Line 582: INSERT into QP_PTE_SOURCE_SYSTEMS

578: p_pte_code in varchar2) is
579: -- Private procedure to insert Source Systems.
580: begin
581: g_ssc_seqno := g_ssc_seqno + 1;
582: INSERT into QP_PTE_SOURCE_SYSTEMS
583: (PTE_SOURCE_SYSTEM_ID,
584: PTE_CODE,
585: APPLICATION_SHORT_NAME,
586: ENABLED_FLAG,

Line 1000: from qp_pte_source_systems

996: where segment_id < 100000;
997: --
998: select nvl(max(pte_source_system_id),100)
999: into g_ssc_seqno
1000: from qp_pte_source_systems
1001: where pte_source_system_id < 100000;
1002: --
1003: select nvl(max(segment_pte_id),100)
1004: into g_psg_seqno

Line 1078: FROM qp_pte_source_systems

1074: WHERE lookup_type = 'QP_PTE_TYPE';
1075: --
1076: CURSOR get_pte_cur (p_application_short_name in varchar2)is
1077: SELECT pte_code
1078: FROM qp_pte_source_systems
1079: WHERE application_short_name = p_application_short_name;
1080: --
1081: CURSOR all_segments_cur is
1082: SELECT b.prc_context_code,

Line 1112: from qp_list_headers_b a,qp_pte_source_systems b

1108: b.attribute_code;
1109: --
1110: CURSOR assign_pte_cur is
1111: select a.list_header_id,b.pte_code
1112: from qp_list_headers_b a,qp_pte_source_systems b
1113: where nvl(a.source_system_code,'x') = b.application_short_name
1114: order by decode(b.pte_code,'ORDFUL',2,1);
1115: --
1116: l_segment_level varchar2(10);

Line 1271: -- Insert into qp_pte_source_systems, source systems and their corresponding PTEs

1267: --
1268: p_insert_lookup_code('REQUEST_TYPE',g_req_ssc_rec.request_type_code);
1269: p_insert_rqt (g_req_ssc_rec.request_type_code,l_pte_code);
1270: --
1271: -- Insert into qp_pte_source_systems, source systems and their corresponding PTEs
1272: --
1273: if p_ssc_exists(g_req_ssc_rec.source_system_code,l_pte_code) = -1 then
1274: p_insert_ssc(g_req_ssc_rec.source_system_code,l_pte_code);
1275: end if;