DBA Data[Home] [Help]

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_TRX_HEADERS

Line 52: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,

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: ) ;

Line 53: description JMF_GTA_TRX_HEADERS.description%TYPE,

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;

Line 54: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,

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:

Line 55: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE

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

Line 63: (ra_trx_id JMF_GTA_TRX_HEADERS.ra_trx_id%TYPE,

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: ) ;

Line 64: description JMF_GTA_TRX_HEADERS.description%TYPE,

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;

Line 65: org_id JMF_GTA_TRX_HEADERS.org_id%TYPE,

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: ---------------------------------------------------------

Line 66: gta_trx_number JMF_GTA_TRX_HEADERS.gta_trx_number%TYPE

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