DBA Data[Home] [Help]

APPS.FND_CP_OPP_IPC dependencies on FND_CP_GSM_OPP_AQ_PAYLOAD

Line 253: msg system.FND_CP_GSM_OPP_AQ_PAYLOAD;

249:
250: enq_opts DBMS_AQ.enqueue_options_t;
251: msg_props DBMS_AQ.message_properties_t;
252: msg_id raw(16);
253: msg system.FND_CP_GSM_OPP_AQ_PAYLOAD;
254:
255:
256: pragma AUTONOMOUS_TRANSACTION;
257:

Line 259: msg := system.FND_CP_GSM_OPP_AQ_PAYLOAD(groupid, type, message, Parameters);

255:
256: pragma AUTONOMOUS_TRANSACTION;
257:
258: begin
259: msg := system.FND_CP_GSM_OPP_AQ_PAYLOAD(groupid, type, message, Parameters);
260:
261: enq_opts.visibility := DBMS_AQ.ON_COMMIT;
262: enq_opts.sequence_deviation := NULL;
263: msg_props.delay := DBMS_AQ.NO_DELAY;

Line 451: payload system.FND_CP_GSM_OPP_AQ_PAYLOAD;

447: Message_Wait_Timeout IN Number default 60,
448: Correlation IN Varchar2 default null) is
449:
450:
451: payload system.FND_CP_GSM_OPP_AQ_PAYLOAD;
452: dq_opts DBMS_AQ.DEQUEUE_OPTIONS_T;
453: msg_props DBMS_AQ.MESSAGE_PROPERTIES_T;
454: msgid raw(16);
455: queue_timeout exception;

Line 464: payload := system.FND_CP_GSM_OPP_AQ_PAYLOAD(NULL,NULL,NULL,NULL);

460:
461: pragma AUTONOMOUS_TRANSACTION;
462:
463: Begin
464: payload := system.FND_CP_GSM_OPP_AQ_PAYLOAD(NULL,NULL,NULL,NULL);
465:
466: dq_opts.DEQUEUE_MODE := DBMS_AQ.REMOVE;
467: dq_opts.NAVIGATION := DBMS_AQ.FIRST_MESSAGE;
468: dq_opts.VISIBILITY := DBMS_AQ.IMMEDIATE;