APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on AR_GTA_TRX_HEADERS

Line 53: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,

49: --add by Lv Xiao for bug#7626503 on 10-Dec-2008, begin
50: ---------------------------------------------------------
51: --this cursor is to keep all the duplicated description record
52: TYPE draft_dup_record IS RECORD
53: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,
54: description AR_GTA_TRX_HEADERS.description%TYPE,
55: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,
56: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE
57: ) ;

Line 54: description AR_GTA_TRX_HEADERS.description%TYPE,

50: ---------------------------------------------------------
51: --this cursor is to keep all the duplicated description record
52: TYPE draft_dup_record IS RECORD
53: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,
54: description AR_GTA_TRX_HEADERS.description%TYPE,
55: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,
56: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE
57: ) ;
58: TYPE crmemo_dup_cur_TYPE IS REF CURSOR RETURN draft_dup_record;

Line 55: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,

51: --this cursor is to keep all the duplicated description record
52: TYPE draft_dup_record IS RECORD
53: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,
54: description AR_GTA_TRX_HEADERS.description%TYPE,
55: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,
56: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE
57: ) ;
58: TYPE crmemo_dup_cur_TYPE IS REF CURSOR RETURN draft_dup_record;
59:

Line 56: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE

52: TYPE draft_dup_record IS RECORD
53: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,
54: description AR_GTA_TRX_HEADERS.description%TYPE,
55: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,
56: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE
57: ) ;
58: TYPE crmemo_dup_cur_TYPE IS REF CURSOR RETURN draft_dup_record;
59:
60: --this record is to keep all the dupliacted desription record

Line 64: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,

60: --this record is to keep all the dupliacted desription record
61: --that fatch from the cursor
62:
63: TYPE dup_record IS RECORD
64: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,
65: description AR_GTA_TRX_HEADERS.description%TYPE,
66: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,
67: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE
68: ) ;

Line 65: description AR_GTA_TRX_HEADERS.description%TYPE,

61: --that fatch from the cursor
62:
63: TYPE dup_record IS RECORD
64: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,
65: description AR_GTA_TRX_HEADERS.description%TYPE,
66: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,
67: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE
68: ) ;
69: TYPE dup_record_tbl IS TABLE OF dup_record;

Line 66: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,

62:
63: TYPE dup_record IS RECORD
64: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,
65: description AR_GTA_TRX_HEADERS.description%TYPE,
66: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,
67: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE
68: ) ;
69: TYPE dup_record_tbl IS TABLE OF dup_record;
70: ---------------------------------------------------------

Line 67: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE

63: TYPE dup_record IS RECORD
64: (ra_trx_id AR_GTA_TRX_HEADERS.ra_trx_id%TYPE,
65: description AR_GTA_TRX_HEADERS.description%TYPE,
66: org_id AR_GTA_TRX_HEADERS.org_id%TYPE,
67: gta_trx_number AR_GTA_TRX_HEADERS.gta_trx_number%TYPE
68: ) ;
69: TYPE dup_record_tbl IS TABLE OF dup_record;
70: ---------------------------------------------------------
71: --add by Lv Xiao for bug#7626503 on 10-Dec-2008, end

Line 73: TYPE vat_tbl_type IS TABLE OF AR_GTA_TRX_UTIL.TRX_header_rec_TYPE INDEX BY AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE; --Add by Sabrina for ER#14830536

69: TYPE dup_record_tbl IS TABLE OF dup_record;
70: ---------------------------------------------------------
71: --add by Lv Xiao for bug#7626503 on 10-Dec-2008, end
72:
73: TYPE vat_tbl_type IS TABLE OF AR_GTA_TRX_UTIL.TRX_header_rec_TYPE INDEX BY AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE; --Add by Sabrina for ER#14830536
74:
75: --==========================================================================
76: -- PROCEDURE NAME:
77: --