DBA Data[Home] [Help]

APPS.FND_EXEC_MIG_CMDS dependencies on TBL_MIG_TYPE

Line 56: l_message_data SYSTEM.tbl_mig_type;

52: x_return_status OUT NOCOPY VARCHAR2)
53: IS
54: l_status VARCHAR2(30) := 'SUCCESS';
55: l_err_code NUMBER := 0;
56: l_message_data SYSTEM.tbl_mig_type;
57: l_enqopt DBMS_AQ.enqueue_options_t;
58: l_msgprop DBMS_AQ.message_properties_t;
59: l_deqopt DBMS_AQ.dequeue_options_t;
60: l_enq_msgid RAW(16);

Line 86: l_message_data := SYSTEM.tbl_mig_type

82: elsif child_lineno_rec.execution_mode = 'S' then
83: l_queue_name := 'tblmig_seq_messageque';
84: end if;
85:
86: l_message_data := SYSTEM.tbl_mig_type
87: (child_lineno_rec.migration_cmd,
88: child_lineno_rec.lineno,
89: child_lineno_rec.owner,
90: child_lineno_rec.object_name,

Line 114: l_message_data SYSTEM.tbl_mig_type;

110: l_lineno NUMBER;
111: l_aqretVal NUMBER;
112: l_mig_cmd VARCHAR2(4000);
113: l_err VARCHAR2(4000);
114: l_message_data SYSTEM.tbl_mig_type;
115: l_outmessage_data SYSTEM.tbl_mig_type;
116: l_enqopt DBMS_AQ.enqueue_options_t;
117: l_msgprop DBMS_AQ.message_properties_t;
118: l_deqopt DBMS_AQ.dequeue_options_t;

Line 115: l_outmessage_data SYSTEM.tbl_mig_type;

111: l_aqretVal NUMBER;
112: l_mig_cmd VARCHAR2(4000);
113: l_err VARCHAR2(4000);
114: l_message_data SYSTEM.tbl_mig_type;
115: l_outmessage_data SYSTEM.tbl_mig_type;
116: l_enqopt DBMS_AQ.enqueue_options_t;
117: l_msgprop DBMS_AQ.message_properties_t;
118: l_deqopt DBMS_AQ.dequeue_options_t;
119: l_enq_msgid RAW(16);

Line 263: l_message_data := SYSTEM.tbl_mig_type

259: cmdtab.parent_owner, cmdtab.parent_object_name LIMIT 1000;
260: EXIT WHEN cmdtab.lineno.COUNT = 0;
261: FOR i IN cmdtab.lineno.FIRST..cmdtab.lineno.LAST
262: LOOP
263: l_message_data := SYSTEM.tbl_mig_type
264: (cmdtab.migration_cmd(i),
265: cmdtab.lineno(i),
266: cmdtab.owner(i),
267: cmdtab.object_name(i),

Line 288: l_message_data := SYSTEM.tbl_mig_type

284: cmdtab.parent_owner, cmdtab.parent_object_name LIMIT 1000;
285: EXIT WHEN cmdtab.lineno.COUNT = 0;
286: FOR i IN cmdtab.lineno.FIRST..cmdtab.lineno.LAST
287: LOOP
288: l_message_data := SYSTEM.tbl_mig_type
289: (cmdtab.migration_cmd(i),
290: cmdtab.lineno(i),
291: cmdtab.owner(i),
292: cmdtab.object_name(i),