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 570: payload system.FND_CP_GSM_IPQ_AQ_PAYLOAD;

566: Message_Wait_Timeout in number default Null,
567: Blocking_Sleep_Time in number default 30) is
568:
569: Not_Done boolean;
570: payload system.FND_CP_GSM_IPQ_AQ_PAYLOAD;
571: dq_opts DBMS_AQ.DEQUEUE_OPTIONS_T;
572: msg_props DBMS_AQ.MESSAGE_PROPERTIES_T;
573: msgid raw(16);
574:

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

575:
576: pragma AUTONOMOUS_TRANSACTION;
577:
578: Begin
579: payload := system.FND_CP_GSM_IPQ_AQ_PAYLOAD(NULL,NULL,NULL,NULL);
580:
581: Not_Done := TRUE;
582:
583: if (Consume_Flag = 'Y') then

Line 758: msg system.FND_CP_GSM_IPQ_AQ_PAYLOAD;

754: Status in Varchar2) is
755:
756: msg_props dbms_aq.message_properties_t;
757: enq_opts dbms_aq.enqueue_options_t;
758: msg system.FND_CP_GSM_IPQ_AQ_PAYLOAD;
759: msg_id raw(16);
760:
761: pragma AUTONOMOUS_TRANSACTION;
762:

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

760:
761: pragma AUTONOMOUS_TRANSACTION;
762:
763: Begin
764: msg := system.FND_CP_GSM_IPQ_AQ_PAYLOAD(Handle, Status, NULL, NULL);
765:
766: enq_opts.visibility := DBMS_AQ.IMMEDIATE;
767: enq_opts.sequence_deviation := NULL;
768: