APPS.FND_CP_GSM_IPC dependencies on FND_CP_GSM_IPQ_AQ_PAYLOAD

Line 96: PAYLOAD system.FND_CP_GSM_IPQ_AQ_PAYLOAD;

92:
93: procedure Init_Cartridge is
94:
95: Not_Done Boolean;
96: PAYLOAD system.FND_CP_GSM_IPQ_AQ_PAYLOAD;
97: dq_opts DBMS_AQ.DEQUEUE_OPTIONS_T;
98: msg_props DBMS_AQ.MESSAGE_PROPERTIES_T;
99: msgid raw(16);
100:

Line 201: msg system.FND_CP_GSM_IPQ_AQ_PAYLOAD;

197:
198: enq_opts DBMS_AQ.enqueue_options_t;
199: msg_props DBMS_AQ.message_properties_t;
200: msg_id raw(16);
201: msg system.FND_CP_GSM_IPQ_AQ_PAYLOAD;
202: sessionid number;
203:
204: pragma AUTONOMOUS_TRANSACTION;
205:

Line 207: msg := system.FND_CP_GSM_IPQ_AQ_PAYLOAD(

203:
204: pragma AUTONOMOUS_TRANSACTION;
205:
206: begin
207: msg := system.FND_CP_GSM_IPQ_AQ_PAYLOAD(
208: Handle,Message,Parameters,Debug_Level);
209:
210: enq_opts.visibility := DBMS_AQ.ON_COMMIT;
211: enq_opts.sequence_deviation := NULL;

Line 261: PAYLOAD system.FND_CP_GSM_IPQ_AQ_PAYLOAD;

257: Not_Done Boolean;
258: Status_Name Varchar2(30);
259: Status_code Varchar2(1);
260: More_Flag Varchar2(1);
261: PAYLOAD system.FND_CP_GSM_IPQ_AQ_PAYLOAD;
262: dq_opts DBMS_AQ.DEQUEUE_OPTIONS_T;
263: msg_props DBMS_AQ.MESSAGE_PROPERTIES_T;
264: msgid raw(16);
265: last_msg raw(16);

Line 399: PAYLOAD system.FND_CP_GSM_IPQ_AQ_PAYLOAD;

395: old_rcg varchar2(32);
396: etrace varchar2(4) := Null;
397: diag_level char := Null;
398: sql_stmt VARCHAR2(200) := null;
399: PAYLOAD system.FND_CP_GSM_IPQ_AQ_PAYLOAD;
400: dq_opts DBMS_AQ.DEQUEUE_OPTIONS_T;
401: msg_props DBMS_AQ.MESSAGE_PROPERTIES_T;
402: msgid raw(16);
403:

Line 530: payload system.FND_CP_GSM_IPQ_AQ_PAYLOAD;

526: Message_Wait_Timeout in number default Null,
527: Blocking_Sleep_Time in number default 30) is
528:
529: Not_Done boolean;
530: payload system.FND_CP_GSM_IPQ_AQ_PAYLOAD;
531: dq_opts DBMS_AQ.DEQUEUE_OPTIONS_T;
532: msg_props DBMS_AQ.MESSAGE_PROPERTIES_T;
533: msgid raw(16);
534:

Line 539: payload := system.FND_CP_GSM_IPQ_AQ_PAYLOAD(NULL,NULL,NULL,NULL);

535:
536: pragma AUTONOMOUS_TRANSACTION;
537:
538: Begin
539: payload := system.FND_CP_GSM_IPQ_AQ_PAYLOAD(NULL,NULL,NULL,NULL);
540:
541: Not_Done := TRUE;
542:
543: if (Consume_Flag = 'Y') then

Line 718: msg system.FND_CP_GSM_IPQ_AQ_PAYLOAD;

714: Status in Varchar2) is
715:
716: msg_props dbms_aq.message_properties_t;
717: enq_opts dbms_aq.enqueue_options_t;
718: msg system.FND_CP_GSM_IPQ_AQ_PAYLOAD;
719: msg_id raw(16);
720:
721: pragma AUTONOMOUS_TRANSACTION;
722:

Line 724: msg := system.FND_CP_GSM_IPQ_AQ_PAYLOAD(Handle, Status, NULL, NULL);

720:
721: pragma AUTONOMOUS_TRANSACTION;
722:
723: Begin
724: msg := system.FND_CP_GSM_IPQ_AQ_PAYLOAD(Handle, Status, NULL, NULL);
725:
726: enq_opts.visibility := DBMS_AQ.IMMEDIATE;
727: enq_opts.sequence_deviation := NULL;
728: