DBA Data[Home] [Help]

APPS.IEM_DP_MONITORING_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 786: x_account_status OUT NOCOPY jtf_varchar2_Table_100,

782: p_commit IN VARCHAR2 := null,
783: P_view_all_accounts IN VARCHAR2,
784: x_account_ids OUT NOCOPY jtf_number_Table,
785: x_email_address OUT NOCOPY jtf_varchar2_Table_200,
786: x_account_status OUT NOCOPY jtf_varchar2_Table_100,
787: x_processor_status OUT NOCOPY jtf_varchar2_Table_100,
788: x_last_run_time OUT NOCOPY jtf_date_Table,
789: x_inbox_msg_count OUT NOCOPY jtf_number_Table,
790: x_process_msg_count OUT NOCOPY jtf_number_Table,

Line 787: x_processor_status OUT NOCOPY jtf_varchar2_Table_100,

783: P_view_all_accounts IN VARCHAR2,
784: x_account_ids OUT NOCOPY jtf_number_Table,
785: x_email_address OUT NOCOPY jtf_varchar2_Table_200,
786: x_account_status OUT NOCOPY jtf_varchar2_Table_100,
787: x_processor_status OUT NOCOPY jtf_varchar2_Table_100,
788: x_last_run_time OUT NOCOPY jtf_date_Table,
789: x_inbox_msg_count OUT NOCOPY jtf_number_Table,
790: x_process_msg_count OUT NOCOPY jtf_number_Table,
791: x_retry_msg_count OUT NOCOPY jtf_number_Table,

Line 792: x_log OUT NOCOPY jtf_varchar2_Table_100,

788: x_last_run_time OUT NOCOPY jtf_date_Table,
789: x_inbox_msg_count OUT NOCOPY jtf_number_Table,
790: x_process_msg_count OUT NOCOPY jtf_number_Table,
791: x_retry_msg_count OUT NOCOPY jtf_number_Table,
792: x_log OUT NOCOPY jtf_varchar2_Table_100,
793: x_return_status OUT NOCOPY VARCHAR2,
794: x_msg_count OUT NOCOPY NUMBER,
795: x_msg_data OUT NOCOPY VARCHAR2)
796: is

Line 813: l_account_status jtf_varchar2_Table_100 := jtf_varchar2_Table_100();

809: l_count number;
810:
811: l_account_ids jtf_number_Table := jtf_number_Table();
812: l_email_address jtf_varchar2_Table_200 := jtf_varchar2_Table_200();
813: l_account_status jtf_varchar2_Table_100 := jtf_varchar2_Table_100();
814: l_processor_status jtf_varchar2_Table_100:= jtf_varchar2_Table_100();
815: l_last_run_time jtf_date_Table:= jtf_date_Table();
816: l_inbox_msg_count jtf_number_Table:= jtf_number_Table();
817: l_process_msg_count jtf_number_Table:= jtf_number_Table();

Line 814: l_processor_status jtf_varchar2_Table_100:= jtf_varchar2_Table_100();

810:
811: l_account_ids jtf_number_Table := jtf_number_Table();
812: l_email_address jtf_varchar2_Table_200 := jtf_varchar2_Table_200();
813: l_account_status jtf_varchar2_Table_100 := jtf_varchar2_Table_100();
814: l_processor_status jtf_varchar2_Table_100:= jtf_varchar2_Table_100();
815: l_last_run_time jtf_date_Table:= jtf_date_Table();
816: l_inbox_msg_count jtf_number_Table:= jtf_number_Table();
817: l_process_msg_count jtf_number_Table:= jtf_number_Table();
818: l_retry_msg_count jtf_number_Table:= jtf_number_Table();

Line 819: l_log jtf_varchar2_Table_100:= jtf_varchar2_Table_100();

815: l_last_run_time jtf_date_Table:= jtf_date_Table();
816: l_inbox_msg_count jtf_number_Table:= jtf_number_Table();
817: l_process_msg_count jtf_number_Table:= jtf_number_Table();
818: l_retry_msg_count jtf_number_Table:= jtf_number_Table();
819: l_log jtf_varchar2_Table_100:= jtf_varchar2_Table_100();
820:
821: cursor c_results is
822:
823: select a.email_account_id, a.email_address, a.active_flag, fl.meaning as account_status,