48: --add by Lv Xiao for bug#7626503 on 10-Dec-2008, begin
49: ---------------------------------------------------------
50: --this cursor is to keep all the duplicated description record
51: TYPE draft_dup_record IS RECORD
52: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,
53: description JMF_GTA_TRX_HEADERS.description%TYPE,
54: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,
55: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE
56: ) ;
49: ---------------------------------------------------------
50: --this cursor is to keep all the duplicated description record
51: TYPE draft_dup_record IS RECORD
52: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,
53: description JMF_GTA_TRX_HEADERS.description%TYPE,
54: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,
55: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE
56: ) ;
57: TYPE crmemo_dup_cur_TYPE IS REF CURSOR RETURN draft_dup_record;
50: --this cursor is to keep all the duplicated description record
51: TYPE draft_dup_record IS RECORD
52: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,
53: description JMF_GTA_TRX_HEADERS.description%TYPE,
54: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,
55: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE
56: ) ;
57: TYPE crmemo_dup_cur_TYPE IS REF CURSOR RETURN draft_dup_record;
58:
51: TYPE draft_dup_record IS RECORD
52: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,
53: description JMF_GTA_TRX_HEADERS.description%TYPE,
54: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,
55: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE
56: ) ;
57: TYPE crmemo_dup_cur_TYPE IS REF CURSOR RETURN draft_dup_record;
58:
59: --this record is to keep all the dupliacted desription record
59: --this record is to keep all the dupliacted desription record
60: --that fatch from the cursor
61:
62: TYPE dup_record IS RECORD
63: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,
64: description JMF_GTA_TRX_HEADERS.description%TYPE,
65: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,
66: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE
67: ) ;
60: --that fatch from the cursor
61:
62: TYPE dup_record IS RECORD
63: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,
64: description JMF_GTA_TRX_HEADERS.description%TYPE,
65: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,
66: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE
67: ) ;
68: TYPE dup_record_tbl IS TABLE OF dup_record;
61:
62: TYPE dup_record IS RECORD
63: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,
64: description JMF_GTA_TRX_HEADERS.description%TYPE,
65: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,
66: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE
67: ) ;
68: TYPE dup_record_tbl IS TABLE OF dup_record;
69: ---------------------------------------------------------
62: TYPE dup_record IS RECORD
63: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,
64: description JMF_GTA_TRX_HEADERS.description%TYPE,
65: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,
66: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE
67: ) ;
68: TYPE dup_record_tbl IS TABLE OF dup_record;
69: ---------------------------------------------------------
70: --add by Lv Xiao for bug#7626503 on 10-Dec-2008, end